What permissions do you need to run the...

RE: Silly Question

Yup.....almost as good as Einstein's MC^2.

RE: not null value in stored procedure

Check if query get any candidates for the update Select Count(*) from tblshipping_sched where NOT (shipped_qty is null)

RE: Shrink Log file when restoring a backup?

I don't know of a way to achieve what you're trying to do - that is shrink the 20gb log component of the backup before restoring, or tell restore to shrink it on the fly. However, if your disk space is at a premium, the following may be worth a try. I've just tested it […]

RE: return TOP

Thanx exactly this I need

RE: Replacing BCP with SQLBulkLoad

quote: I think the BULK INSERT statement is a good substitute to bcp. From a performance perspective, it should be slightly faster. BULK INSERT runs in the memory context of SQL Server whereas bcp does not. Both of these would be faster than DTS and the described method here. K. Brian Kelley http://www.truthsolutions.com/ Author: Start […]

RE: Stored Procedure and parameters

You have two possibilities. The first one is using IF statements, each with their own query. This is OK if you only have a few parameters, but the number of combinations grows very quickly. Another possibility is to change the query to take left out parameters into account. In your example, the query would look […]

RE: I need your help

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 http://support.microsoft.com/default.aspx?scid=kb;en-us;314546

RE: Smily question

Here I think this is right. quote: EIGHTBALL 'Eightball' is a highly uncomplimentary slang word standing for a rather objectionable character ('gold brick', 'goof'). The word owes its origin to the billiard game where the number 8 ball has some restrictive associations which make it an object of disapproval. Namely, in a pocket billiard game, […]

Which one of these common SQL Server network...