Agree with JB. INSTEAD OF Triggers are the first that I would use for the Hard Way and I have seen code using them. They can not be implemented in...

Sean,

You may include your previous experience on the separate line as "consulting" for for your current employer, which well describes your contributions. I would certainly get a certification, it really...

Daniel,

It is not an easy task unless you define a lot of rules in a kind of a dictionary or table. While it is easy to replace spaces with |...

Why do you need to Update Statistics on msdb?

Brian,

CREATE STATISTICS topic in BOL says:

"Computed columns can be specified only if the ARITHABORT and QUOTED_IDENTIFIER database options are set to ON. "

http://msdn2.microsoft.com/en-us/library/ms188038.aspx

One thing that may fail in this approach is if you have local accounts as logins to SQL Server then when you replace the server and re-create this new local...

I probably did not have my cofee yet. I am running a query from Management Studio 2005 towards 2000 Northwind database without grouping and I looked up that EmployeeID =...

I would try if you can create an ODBC source from your workstation using named Pipes. It will show you if you can connect at all. Your error message talks...

It is easier to ask the server sysadmins to submit you the list of logging modes then to give you the access to their servers to run...

I would not go as far as that. Make sure the recovery Model is Simple for TempDB. There are some other recommendations by Microsoft books:

- You may want to put...

Brian,

1. In the companies where the responsibilities are split to the point that server admins don't have the database access, then in these companies it is very unlikely that a DBA will...

C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\en\Microsoft.SqlServer.Smo.xml

This config file contains settings for the target servers (multi-server administration) if you are asking about enlisted servers. You have to search this doc for the keyword...

They will be able to get access to the secure data anyway:

1. By Changing the password for SQL Server Startup account. By Default (and by the question this is the default...

The Profiler traces can show Start Time and End Time for statements and batches

Alex,

I would not delete the folder. Because you have SQL Server pointing to this folder.

I read the message again. It says "The specified object cannot be found". It is just...