If this is the case than opening any connection with "Database Engine Query" will result...

not quite sure what you mean by "saved queries".

I believe you need SQL Server BIDS.

http://msdn.microsoft.com/en-us/library/ms173767.aspx

The first time I open up a script, SSMS will ask me to pick a server connection. But each time after that, it will not. It will auto-connect to the...

A search of this forum would have resulted in many different post asking for and explaining this. Here is one in particular that gives two different examples on how to...

If you are looking to do this in SSIS here is a link that will get you started. http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx.

I would think that you are getting this error because the column you are trying to create a clustered index on (l_fundid) is not unique. http://msdn.microsoft.com/en-us/library/aa258260%28v=sql.80%29.aspx. You must have at...

Your view has not been created with schema binding. Here is the books online for create view, look at the scemabinding option.

Check sys.databases view.

I briefly looked into this and talked to our developers and it would very much depend on how the application was creating the connection it the first place and, when...

I have just ran into the exact same problem last week and this is what I came up with to auto-kill long running queries. I have not implemented this as...

this is also an option

INSERT INTO #table1

SELECT REPLACE('Jenny','Rack',name),dd

FROM #table1

this will get you your value

xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel'

and this will change it

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', REG_DWORD, 3

there is also a new dmv in denali and 2008 r2 sp1...

I believe this is the character you have in between the _ and T. http://www.fileformat.info/info/unicode/char/1f/index.htm I can replicate it in a text editor via ALT+031.

Can you do a manual backup to the backup share after you have failed over? Test with any database to both the actual path (ie c:\backups) and the share (ie...