it's ridiculously easy....use the exact same script, but rename the output to .xls when you save it.

excel will automatically translate HTML to the proper format when it opens the file.

[post...

SQLRecon is excellent for this:

http://www.specialopssecurity.com/labs/sqlrecon/

it finds all SQL Server instances by scanning all sorts of methods in order to give a comprehensive list. it's also free.

can you use an outer procedure to determine which database to use?

ie

CREATE procedure pr_dbSwitch as(@dbname) as

declare @sql varchar(2000)

select @isql='USE @dbname pr_yourprocedure'

  select @isql = replace(@isql,'@dbname',@dbname)

  print @isql

  exec(@isql)

that way your proc is not dynamic,...

i've seen programs which generate code based on user selections build queries like this....i would guess just running it thru query analyzer and having the show plan on would let...

We had a similar kind of situation with a database software package; the vendor does not want clients to alter the database schema, and the knee jerk reaction was replication...

like Mike says, it depends on your tolerance for differences between the two database....log shipping is free, but your backup database is out of sync by the xminutes you have...

additionally, even though two connections might create a temp table witht he same name, #temp, they are actually stored as two different sysobjects in the tempdb database;

here's an example for...

the case returns one of two values, 0 or the calculation.

you could replace it with the same functionality:

column1=isnull(SUM(ABS(t.Amount)*c.CalcInvestedAmount) ,0)

a little less verbose, but with the same results.

here's a real basic example from vb6: hope it helps. you don't save the file in any format...you actually save the file, in binary format, within the database using the...

it pretty much cannot be done.

the FOR XML returns a stream to a dataset or recordset, adn not an standard object in SQL server, so you cannot capture the data,...

someone created a script here on SSC which creates HTML documentation of a database and it's schema;

it produces results in HTMl, and a google search showed me a lot of...

you can get that value by running DBCC USEROPTIONS

set rowcount 50

DBCC USEROPTIONS

vb6 cannot build any dll that can be used as an extended stored proc; you have to do it in C/C++/Delphi or any .NET language.

VB6 can't do it because for...

when you did the manual backup on Saturday 4pm, could it be that the backup was set to the default of "append to existing media"?

in that case, the backup file...

i stick this in master and use the command sp_kill dbname to kick my users out:

what is nice is that when called in a job or script, it is not...