Are you saying that SQL Server management tool is accessible by Public? That is scary. If I am wrong, please correct me.

You could just set up a SQL Server...

The way we do it is to wait for a Service pack or Release Candidate and test them out in our QA before applying to production. I am talking about...

Everywhere I read, they all recommend atleast 10% of your physical RAM for the OS. If you have 128 GIG of RAM, then I would say you can afford to...

Glad we could help and thanks for letting us know that it worked.

That really was a strange one....lol

Did you link it to the Water cooler itself? When I click on the link, it brings me back to this page itself.... 🙂

Greg, That was a good one.... :hehe:

Yes it is possible. This is one of the main reason why you take a back up. If your server dies and you have back up, you just have to...

Did you run the DBCC command the message asked you to do?

DBCC CHECKDB (Database Name) WITH NO_INFOMSGS, ALL_ERRORMSGS

Also I hope you have Backups of this database when this error was...

If you just want to add a column to an existing article in a publication, you can use ALTER TABLE command itself. This command should be run in the publisher....

You should have advised the OP that SQl Server would start giving...

collection_set_3_upload has been failing for quite a few people. It was reported to Microsoft and a fix was supposed to be out last month. I am not sure if that...

select max(@pk_column_nm) from @table_nm

This can be done as a dynamic SQL.

About selecting values to a variable...

declare @testvar datetime

Select @testvar = getdate()

Along with what Lutz said, the update does not make sense. Look at this part of your update statement..

update itemnumbers

set userinteger_01 = @userinteger_01

...

where userinteger_01 = @userinteger_01

Why are you updating...

Whenever I hear Texas it reminds of the picture drawn in all of the Louis L'Amour books. 🙂 I was a big fan of it when I was a teen......