Oh and forgot to mention...

You should not store data this way. It really is a horrible way to do things. Still, I'm guessing your dealing with someone...

Right, sorry on the road so doing this in notepad. Think you might have to cast or convert the variables to add them to the "set" clause of the...

I've gotta agree with Sergiy on this, it's not a good idea to do this kind of thing.

However....

In the above example, what's supposed to happen columns 1, 2 and 3...

OK, we ended up fixing this. Ran sp_MSremovedbreplication just about everywhere and emptied that table. Rebooted the server and tried again. No disco.

Tried to just...

Sorry, we're running SQL Server 2000 SP4 on Win Srv 2003.

Hi Dana,

When you created the maintenance plan, on the "Data Integrity Check" part did you tick the "Attempt to repair any minor problems" checkbox? As far as I know,...

Thanks Carl! I think I'll do just that. I'll have to get a release for the data though.

And thanks for the advice Colin but I wish it were...

Hi,

Yep, I see what you mean. I don't know why that text column is locking the space like that though. ...

Hi Carl,

Thanks for the reply. Yep, I re-ran the REINDEX, UPDATEUSAGE and sp_spaceused again exactly as you mentioned to double check it wasn't my befuddled brain but it's coming...

Whoops! Sorry about the misunderstanding. Right, my guess is you might be looking for something along the lines of the OSQL command line utility.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp

If you can...

Hi,

Yep. You can schedule a job to run your bat files in SQLServerAgent. Create a job and give it a name and assign it's owner. When...

If I understand your question correctly, you want to know how to tell the script to make the new table in the new database. Is this correct?

If so you'll...