Check out this article that I found here several months ago. I implemented it as a weekly job on our systems and it's been working quite well.

http://www.sqlservercentral.com/columnists/jreade/howtoscheduleasqlserverdatabasecreationscript.asp

Good luck!

Brian

I was mostly using canned code examples I found various places. I did some more research and I found a quote from a Microsoft rep saying that they didn't intend...

Oh, I misunderstood somewhat what you were after. Try incorporating this:

Server svr = new Server()

Database db = new Database(svr, "MyDatabase")

db.DatabaseOptions.AutoClose = true

Scripter scripter...

I'm not sure if this is going to be exactly what you need, but I've found this to work in my environment, adapted from a script I found here:

--This will...

I haven't yet tried this myself but a consultant I know swears by it... if you have room in the server, find two relatively small SCSI or SATA drives and...

First off, I know this link gets thrown around a lot, but it is good info:

http://www.sommarskog.se/dynamic_sql.html

For many of his reasons I'd recommend using exec sp_executesql @sql instead of exec(@sql)...

You might try reading this article on using the sysprocesses table... I've found it helpful tracking down rogue Crystal reports that users have been running against our production db:

http://www.sqlservercentral.com/columnists/tTroisi/detectingperformanceissueswithsysprocesses.asp

Good...

Several things that I've read on these forums seem to indicate that you can get even better results combining your WHERE filter into your JOIN clause. For example, if you...

I hope I'm not missing something here, but from what I'm seeing you should be able to use:

CREATE PROC mySP

if exists (select name from sysdatabases where name = 'MyDB')...

Perhaps this will help, as I just worked this out a week ago myself. You have your procedure sp_testoutput with one parameter, @outparam. It's defined INSIDE the procedure when you...

While I've never done this personally, it still may be a valid solution for you. Have you considered using server-side tracing, such as with sp_trace_create? Once that is created you...

There was a recent article on the site discussing this topic... I believe the author was Leo Peysakovich (apologies if I butchered the spelling). Hopefully it has the answers you...

Something along the lines of:

select distinct inmast.fpartno, inmast.frev, cast(round(sum(X.cost),0) as money) as PartCostTot

from inmast inner Join

(select rcitem.fpartno, rcitem.fpartrev, ((rcitem.fqtyrecv -...

Well, I'm fairly new to this myself, but one thing I'd look at would be the JOIN section:

from inmast inner Join rcitem

on inmast.fpartno + inmast.frev =...

On that workstation, do you see an entry in the registry similar to this?

"HKLM\Software\ODBC\ODBC.INI\%ODBCNAME%\Description" with an appropriate string value? Also, make sure the entries are in HKEY Local Machine (System...