I do something similar to what you are trying to do. I've got a Perl script which goes out and retrieves a list of the domain users. It then retrieves...

Remember that when a dynamic SQL statement is executed, it is executed in a separate batch from the calling statement. This means it's also a different scope. Therefore SCOPE_IDENTITY() in...

The SQL Server Central Newsletter is the newsletter for this site. Any articles that are published here are usually found in one of the two newsletters that go out weekly....

SQL Server Central Newsletter! OK, ok, I know, I know, print media, right? I like SQL Server Magazine but I also like SQL Server Professional from Pinnacle. I'm debating on...

1) Are you able to send successfully through Outlook?

2) Are you on Exchange 2000?

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

You can script stored procedures and store them in Visual SourceSafe aka VSS (which is free with Visual Studio). When you have all the stored procedures for a particular build,...

When you create a primary key, by default it creates a clustered index. If you specify PRIMARY KEY NONCLUSTERED, it'll create a non-clustered index instead.

Run an sp_help on the...

It may be a bad install, however, here's a question: On the NT side, is the SQL Server Agent service account a member of the local administrators group?

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

To piggy-back on both of these guys...

HFNetChk is a command-line tool from Shavlik. Shavlik has a more robust version out called HFNetChk Pro (imagine that) which can also do patch...

Try the following MSDN article. It documents how to use account impersonation with ASP.NET:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconImpersonation.asp

Also from the developer's guide:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaspnetimpersonation.asp

This KB article describes the issue:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q176377

Also take a look at the following to...

Hi Michael,

Can you give us an example of your query using sp_processmail?

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

If you're running XP, you've running MDAC 2.7. It has support for named instances. What the previous user was referring to was if you have MDAC 2.5 or below, you...

If your NT user account has access to the SQL server, make it a member of the sysadmin role. Change the registration to use NT authentication.

Getting the information on startup...

Books Online, which is the documentation that comes with SQL Server, has all the information you need including how data types implicitly convert, etc.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide...

Do you have administrative rights to the server?

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