You can also slug it out with BCP, unload from SS and BCP back into MySS.

This avoids any security concerns if you don't want to /can't add a linked server.

Also,...

DTS is notoriously buggy. Make sure you have the latest service pack installed, store your packages locally and don't password protect them.

Those are our rules of thumb to avoid...

Another possiblity is using "instead of" triggers to direct all updates/inserts/deletes to the new data base. Your existing app continues to work unchanged. The maintenance shifts to the...

Do the jobs all need to run at once? Could you have them single thread and correct the problem? I have a series of jobs where the last...

I would verify your data base. Resetting the "suspect" status bit did only that: turned off the error. Use DBCC to verify your data base is still fully...

Ya --- TCP/IP = no problem. what was your resolution?

In many ways, SQL Server is kinda stupid. Or is it that it just expects you to know what you're doing? Seems to me another index that duplicates...

information_schema will show you the defined length but since you already know that, use steve's answer to find the actual value length stored therein.

I use both and prefer XP over 2000. More features, more stability. I have Xp at work and 2K at home. Comparable machines.

I will upgrade to XP...

quote:

---

Hi, All

how can I put header & Trailer info after or before I pull the data? Is there any DTS function or...

Just remove it!

Seriously: By default SQL Server only checks permissions at the Stored proc level. If you can execute the proc, SQL Server do the higher overhead of checking...

There's not a function available without rolling your own anyway so take the word list above and create a simple table that accepts your words as input.

You also can use...

have you tried monster.com and hotjobs.com? I would also look for a recruiter in your area(?) to help with placement. If you have experience, you should be able...

Conventionally, we set up a SQL Server ID and use it for connection. The ID assigned has access only to the stored procs necessary for the application. It...

can you tell us if SS2K is the subscriber or the publisher? if SS2K is the subscriber, no problems at all. You can accept the updates and upward...