You already have the query. All you need to do is create the table to match and then convert the select to an insert. All that required is adding the...

Nope. It performs like a dog on SQL...

Using nolock doesn't just allow dirty data. It essentially says to SQL that...

Hmmm. Odd. Did you create that through the management studio GUI? If so, what options did you select?

What do the following return?

select name, type_desc from sys.objects

where object_id = OBJECT_ID('NAMES') OR...

Create the table, then do an insert into... select ... with that query as the select. If you want it to refresh ever day, then you'll need to set up...

It doesn't add builtin\administrators. It adds windows accounts that you specify to SQL server and makes them sysadmin. There's no good reason not to run it.

If your server is set...

I'll be blunt. That form of query does not and can not perform well. Regardless of indexes, order of bits in the...

I also took very few photos. I checked my camera this afternoon and realised that I took just 1 photo during the 3 main days. 🙁

Oh, thanks.

The primary key is actually non-clustered, and I'm trying to delete a clustered...

Not on Vista or Server 2008. On those...

The primary key is enforced by an index and, I'd guess from your description that the primary key is the clustered index (use sp_helpindex to check). You can't drop the...

Trace does show before execution. That's what the StmtStarting and SPStarting events are. The StmtCompleted and SPCompleted are the events that fire after execution. It's not going to let you...

Thread continues here: http://www.sqlservercentral.com/Forums/FindPost609378.aspx

Marin: It's better to continue posting on a single thread than to start a new one. That way the people helping you can see when new posts...

For the sample data that you've posted, what's the output that you want? What records do you want back?

You can use profiler and catch the statement/sp starting events. Not sure if it's the right solution though.

What's the reason behind the question? What are you trying to do with...