Paul White (4/5/2009)

Why would your being rude to someone you have...

One thing I will suggest, if this does have to be done on the DB. Put an order by in place. As it currently stands, there's no guarantee that the...

I do know, but I'm curious. Why do you want to set the server's time through SQL? That should be something that's done maybe once, by the server admin. If...

Generally this is more appropriately done on the front end, as it's usually a formatting/display issue.

While Florian's solution works very nicely, in relational terms, the resulting rowset has three...

Not using T-SQL. To do that you'd need to use xp_cmdshell and issue OS commands

Most likely someone's been directly updating the system tables after configuring the server to allow updates to them. This is the usual kind of mess that results from someone doing...

Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.

What's the results from...

Any idea who did that? There should be entries in the application event log and they...

You can also create the primary key as a nonclustered index and then create the cluster elsewhere.

ALTER TABLE .. ADD CONSTRAINT ... PRIMARY KEY NONCLUSTERED

Is this still a SQL 2000 server or has it been upgraded to a SQL 2005 server?

It's an important question that needs an answer. The methods of fixing are very...

Backup log with truncate only means truncate...

Interview question?

Triggers fire when a change happens to a table. That's it. If you want scheduling, try SQL Agent.

Well, there's two different types of table valued udf, and they follow completely different rules.

The inline table valued...

I'm just surprised that...

You're looking for the MCITP certifications. There are two, one for dev, one for admin

http://www.microsoft.com/learning/mcp/certifications.mspx