What do you mean?. Create Users/Passws ramdonly?

Did you check the Macros?...

Your other option is ALTER DATABASE database_name (a lot to read here)

The sys.databases catalog has all the options values. What about getting a snap-shot of those values... and...

Go to today's or yesterday's posted articule on CTE. There is recursive SP (using loop) that may help you since you are still on SQL2000.

Try reading a little on sp_configure and command RECONFIGURE.

You may want to considere adding a USE [db_name] at the top of each script if the are db specific, if...

Add a GRANT EXECUTE permission at the end of the SP to either a user list or group. See the command syntax for details.

Or, go to the SP list...

syscomments is also used to store long stored proc when they overflow the field for the script's text. I suspect that those with id null are the records related to...

I may not have a full understanding of the Business Logic behind your operation, however, once you insert a record in [Transmittal] the @@identity will hold its last...

if you data is for dates no older than 2000 and current year is the max(year)

select

convert(datetime,'200'

Try the other way. Create an excel Macro that connects to your SQL DB, loop thru all the categories and while in each category build a SELECT statement on the...

I would say your application development manager "is right". Make your Non-Confidential server the access point (server) and define there your linked server and views and manage only only connection...

Try sys.partition_range_values

Don't be fooled, neither get used to it. Go ahead and create some linked servers, or connect to other instances and so on and run the the same query.

copied from BOL:

To replace or modify large blocks of text, ntext, or image data, use WRITETEXT or UPDATETEXT instead of the UPDATE statement.

Are you considering only local candidates?. email me camilo.torres.1967@hotmail.com if considering remote contractors.