Personally avoid the SELECT INTO method as it will issue a lock on the original table and will hold it until you drop the temporary table blocking other transactions. This...

Actually it has no effect on the stored procedure. The table will remain available as long as the connection remains live. This however creates a problem if you want to...

Tell us about the DB, what type of failover need you have, and what constraints are you under? There are many possible options but it will be hard to tell...

Look at the SQLServer Object item in BOL. The property you will use is Status which will return the state of the service.

"Don't roll your eyes at me. I will...

You are correct. The problem with SELECT INTO is the way it issues locks to block access to the data. The NOLOCK hint however in a select statement will allow...

Couple of things, What version and SP revision of SQL are you running? Check out [urlhttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q203777[/url] . And finally if that doesn't help try reinstalling just the client tools, may...

This is an example of generating the .trc output file from a trace of Login Auditing.

SQL 2000

declare @P1 int

set @P1=0

exec sp_trace_create @P1 output, 2, N'C:\LoginAudit', NULL, NULL

select @P1 --You will...

Please do not crosspost. Responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4682&FORUM_ID=23&CAT_ID=2&Topic_Title=execution+plan%3F&Forum_Title=General

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

That would be a real big YEP!

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Excert From SQL BOL

quote:

---

Error Message Formats

All of the Microsoft® SQL Server™ 2000 components can issue informational, warning, or error messages to applications....

I would look at Andy's solution.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Unfortunately no, there are a few examples of generating a truer random number then you get by default with RAND() but most use temp tables and multiple lines of sql...

I like your original idea but their point can be handled. But take a look at sp_start_job to allow them to run the process you mention.

Excerpt From SQL 2K BOL

If you want to set as deafult then in EM you can right click the Server, choose properties, then on the Server Options tab (name may be wrong) you can...

I agree DTS has some major flaw. I hate worse than anything having to recreate a package I build on my machine when putting on the server. It would be...