The first one I gave exists at my database level. It's a Windows collation... so it's based on what is available for the OS.

If you go to Start |...

Yes. Programmatically you can do this within the application, with it taking care of the NT authentication. Are you wanting to prompt them for a username and password...

I did a quick search on the web but didn't turn up anything. I'll keep looking. However, this may be a case where you need to get in...

If you are installing it and setting it for the server, select Collation designator (this is using the Windows collations) as opposed to SQL Collations. Choose Latin1_General and check...

If you do a DROP PROC and CREATE PROC , you'll lose any security settings. Therefore, you'll have to also redo the GRANT EXECUTE and DENY EXECUTE. If...

Maybe Latin1_General_CS_AI?

Latin1 is for Western European, and if I am understanding the nomenclature right on that abbreviation, CS = Case Sensitive and AI = Accent Insensitive.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

It does work, but you have to enclose the owner and name in quotes. For instance:

EXEC sp_MStablespace 'joe.tableA'

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

This is for SQL Server 2000.

Consider the case of a simple recovery configuration. The transaction log will be truncated whenever an automatic checkpoint occurs. Automatic checkpoints...

Try: SET NOCOUNT ON

It is supposed to eliminate the statement returning the count. It's needed in some applications, especially when developers are using the data connection functionality for ASP...

See if the following works for you:

SELECT so.name [Table],

  si.name [Index], sc.name [Column]

FROM sysindexes si 

  JOIN sysobjects so ON si.id = so.id

 ...

That would be fun... sort of like the type of stuff covered by the Inside {} series of books from MS Press?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

SQLMail (xp_sendmail) and SQLAgentMail (sends notification of the job failure) are two different things entirely, so there usually isn't anything there if the Profile(s) are set correctly. I've seen...

You didn't say if persontypebin & 2 = 2 matters or not. If it doesn't, you can do:

SELECT *

FROM persontypes

WHERE persontypebit & 13 = 13

[/code]

If it needs to be...

See if this is any help:

http://www.microsoft.com/licensing/programs/sa/SQL.asp

It's gotten to be a pretty confusing animal.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

The key is to convert the password to varbinary and then to use sp_addlogin and script encryption. Brian Moran, et. al., detail it here:

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=7777

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/