| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-06 : 07:38:36
|
| shawn michaels writes "How do you create a stored procedure to be ran as a scheduled task that when executed on the local server, performs a query on a remote server. Both severs are operating SQL Server 6.5?Does SQL 6.5 support this operation." |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-06 : 08:15:16
|
| Use Linked Servers for accessing the other server .check for "linked servers" in BOL.About accessing the objects of another server. follow this calling convention servername.ownername.objectnameSchedule your Stored Procedure using Job Scheduling Wizard.HTH--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God isEdited by - Nazim on 02/06/2002 08:16:17 |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-06 : 09:47:53
|
| Linked servers are not supported under 6.5, but remote servers can be set up. The remote procedure call interface would be used to execute the remote query.You could also use isql.exe to run a query on the remote machine, simply by specifying the server name, login & password, and passing either a SQL command string or the name of a .sql file containing the query you need, as a command-line operation. If you need to retrieve the results of the query, bcp can put them into a text file for you (and also import them into the local server).I'm fuzzy on the exact syntax for isql and bcp (never used remote servers either), but I do know that they are all well documented in Books Online 6.5 (man, I miss that version!). |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-06 : 09:57:51
|
oops! never knew there are no linked server's in 6.5 . Thanx Rob .Hey! i dont believe it. i think 6.5 was a lousy product. quote:
I'm fuzzy on the exact syntax for isql and bcp (never used remote servers either), but I do know that they are all well documented in Books Online 6.5 (man, I miss that version!).
--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-06 : 10:29:21
|
quote:
Hey! i dont believe it. i think 6.5 was a lousy product.
Oh, you could not be more wrong. Wonderful program! Totally solid. Yeah, dealing with devices can be a drag, but it's not much different from using filegroups, if you look at them from 180 degrees around. Some of the other things like 255 characters max seem like huge limitations, but they're not. And I'll tell ya, the Enterprise Manager for 6.5 has a CLEAN interface; 7.0 and 2000 can get cluttered pretty quickly. And I really have to scream at MS for not making a snap-in that lets you manage a 6.5 server using MMC. Of course they won't do it now, but switching between 2 different EMs was ridiculous.And I have a rant about SQL 7.0 Books Online and higher: we've all found entries that have cool titles like "Using bcp or BULK INSERT to automate importing" and you click the link and it says something like "SQL Server uses the BulkCopy interface to perform bulk copy tasks"...AND THAT'S IT! That's not documentation!Granted, there are a few like that in BOL 6.5, but nowhere near as many. I've found 3 at most, while in 7.0 I've gone from link to link sometimes 10 deep that have entries like that. The documentation for this stuff, if it exists at all, is in a completely different section, and there are NO links to that section. NOTHING is more frustrating than being under the gun, finding these tantalizing clues that promise wonders galore, and then hitting a brick wall of no useful documentation.OK, I'm done!  |
|
|
|
Spyder
SQLTeam Author
75 Posts |
Posted - 2002-02-06 : 10:31:35
|
Well, it is somewhat comforting to know that there are other poor bastards out there besides myself that still have to support SQL Server 6.5... |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-06 : 10:54:40
|
| I still prefer 6.5.It could do most things you need to do and didn't pretend to work like v7. Only real benifits from v7 are unicode and longer character strings and maybe full text search.You didn't have people creating databases (or tr logs) that grew to fill the whole disk, creating stored procedures that reference objects that don't exist and not finding out until they run, crating linked servers and expecting to access them like local tables, ...It's a lot easier to use v7 but that causes a degradation in expertise and a lot of problems not turning up until the system has been running a long time. The problems used to be 'how do we get this to work', now they are 'how do we get this working again and recover our data'.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
Spyder
SQLTeam Author
75 Posts |
Posted - 2002-02-08 : 17:04:54
|
quote:
I still prefer 6.5. It could do most things you need to do and didn't pretend to work like v7.
Agreed! To add to that, it also seems that SQL Server 7.0 / 2000 and beyond have also made it easier (especially for the non-inititated) to create somewhat functional databases of poor design (in fact, it seems like we are having SQL Server and MSDE instances sprouting up all over the place these days). Back in the good (bad?) old days, installation was much more difficult and poor database designs really stuck out like a sore thumb! |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-10 : 10:19:47
|
| My personal experience with 6.5 hasnt been good. i have always struggled with tables with identity value(God knows why, everytime an error occoured on insert the identity value will give me problems ). --------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-10 : 10:46:26
|
quote:
i have always struggled with tables with identity value
Got a solution to that...DON'T USE IDENTITY!  ----------------------------------------------------------------------------------Don't struggle with your Identity columns, tell your Identity columns to f--- off! |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-10 : 10:57:52
|
LOL instead i kicked off 6.5.Rob, you have Solution to Every problem on Earth , Keep it UP --------------------------------------------------------------"Happiness is not something you experience, it's something you remember."Edited by - Nazim on 02/10/2002 10:59:12 |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-02-10 : 11:32:06
|
| >> everytime an error occoured on insert the identity value will give me problemsAnother option is to not have errors.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-16 : 00:31:01
|
| that probably explains why Rob and nr are the leading posting members --------------------------------------------------------------"Happiness is not something you experience, it's something you remember." |
|
|
|
|
sql server 6.5