jb,

i must agree with Brian, the business needs should always dictate the available money. 

to give you an idea of the budget you will need and to give you a strong arguement...

Oli,

I would suggest implementing the 2nd method within a test environment and inspect the resulting Execution plans within QA against those for the current solution to see how the query...

Eduardo,

Can you enlighten a bit more please?  What is the query that you are sending from your VB application, is is just basic delaritive SQL, i.e. SELECT, INSERT, UPDATE, DELETE...

Jane,

Sounds like your server is in a bit of a confused state.  Try the following: http://support.microsoft.com/default.aspx?scid=kb;en-us;224071#XSLTH3207121122120121120120 then see if sp_helpfile, sp_helpdb 'tempdb' and sysaltfiles return the same information.

hope this helps.

ll

El,

First of all, what is it that the application is perfroming that requires access to the msdb database, if anything? 

What errors are you getting from you application relating to...

Terry,

Assuming you are using SQL Server 2000 you can use the system stored procedure sp_attach_single_file_db, check BOL for documentation, but here is an example:

EXEC sp_detach_db @dbname = 'pubs'

EXEC sp_attach_single_file_db @dbname...

Another point to note is database space requirements, obviously your choice of RAID will determine the available space you have for databases and transaction logs.  I would agree completely with...

A great article.  Glad to see there are others out there using the SQL Server Operations Guide.  I was looking for something to tie the Operations Guide together and summarise...

Tell me about it, that's what took the majority of the time, you can see my commented out SELECT statement to make sure the resultant command was formatted correctly.  quotename...

Shawn,

Many many thanks for your response.  I have spent a good few hours thinking about this solution and investigating OPENQUERY.  I had never really used this function before.  However I immediately...

We wrote a simple batch file that fires off svrinfo.exe (Resource Kit) at all servers we want to monitor and dumps the results out to file like so:

<ServerInfo.bat>

"c:\tools\srvinfo.exe" \\server1 > "c:\tools\server1.txt"

"c:\tools\srvinfo.exe"...

Adam,

Are the MSSQLSERVER and SQLSERVERAGENT services running?

ll

Joseph,

What do you get returned when you run SELECT SERVERPROPERTY('SERVERNAME')?

ll

Phil,

I was just looking ahead to the use of these scripts in environments where replication is setup but am now unsure why this would be an issue as replication is...

Thanks ever so much everyone for your input.  Through much googling I have found the following MS article:

"HOW TO: Transfer Logins and Passwords Between Instances of SQL Server" http://support.microsoft.com/?id=246133

I...