One of the things you can do to avoid this problem is to give yourself a default database other than master. For instance, on one particular server where I work...

It can be done using ADSI or some of the API calls (in which case, you're probably out of scripting for the latter). As I told Void, since he fancies...

Yeah, I do need to do that. Though I'll use the ADO objects since that's easier for most who've done Windows development than say DBI.

K. Brian...

I have several Perl scripts that run to retrieve this information once a night. I then store it in SQL. One of the things it lets me see is what...

Also, if that server was rebooted recently, check the event logs to see if for whatever reason it wasn't able to rebind on the port it uses.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start...

The cert proves you have the wherewithall to actually go take the test and I know some companies are pro-certs just for that reason.

I know from interviewing that there are...

Can you put "cold dump" in context? That's not normal SQL Server lingo.

As for what SQL Server puts in the registry, there's actually a lot of information. Anything you are...

It will violate the license agreement. The license agreement specifies the number of processors on the machine, not the number of processors intended for use.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

Regular Certification: Microsoft Certified Professional (MCP)

Premier Certifications: Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Solutions Developer (MCSD), Microsoft Certified Systems Engineer (MCSE)

I haven't kept up, but I'm assuming Microsoft Certified...

Yes, but if you're staying pure T-SQL, you'll have to use xp_cmdshell and execute the package using DTSRun.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Take a look in Books Online for Web Assistant Wizard. The wizard uses a set of system stored procedures to manage web tasks. Here's a link to the relevant...

Who is your hardware vendor for both your servers and the SAN itself?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

For stored procedures I intend to use as a system stored procedure I have placed in the master database. A good example is sp_blocker_pss80 which is included with Microsoft's knowledge...

You can't use default on both of them. This is basically how clustering SQL Server works for an active/active cluster.

When you install the first instance of SQL Server, you'll be...

Dynamic SQL runs in a separate batch than the calling batch. The implications are:

(1) You lose the advantage of ownership chains. This requires additional security checks. Also, it requires you...