If its the bids error I'm thinking of, try this.

regsvr32 msxml3.dll

regsvr32 msxml6.dll

I've used that TSQL type solution in the past. My problem with it is it uses a substring on the file name and those formats can and do change...

Blowing the trumpet for Powershell and SQLPSX.

You can use a scriptingoptions object to make the script output configurable.

Get-SqlDatabase -dbname test -sqlserver server | Get-SqlTable | Get-SqlScripter | Set-Content...

Also, is this in a development or test environment?

shaban osmani-267622 (8/26/2011)

---

Hi Roy,

I used once on the test environment KEEP_REPLICATION while restoring the log back into the Primary Server and it didn't worked.

When I used KEEP_REPLICATION on both sides...

chandan_jha18 (8/30/2011)

---

Leave the...

You could use powershell and do this in a couple of lines with relative ease

This is the "guts" of one of the scripts I'm using. (EDIT: There may be some...

chandan_jha18 (8/30/2011)

---

It will show you the last snapshot generated (say for 300 articles). At this point, just start the snapshot agent. (Do not click on checkbox saying 'Reinitialize'). Simply run...

Its a common problem. The clean up task is based on the lastwrite time, so if the duration of the backup fluctuates you can end up with extra backups.

We...

You can start a SSIS job on another server using sql 2005, but you wont be able to call a 2008 SSIS package directly from 2005. So you will...

Lowell (8/26/2011)

---

MysteryJimbo (8/26/2011)

---

I disagree.

I've just tested this on a table column with no constraints, fk etc. Ran the statement given which worked instantly. I then did...

Lowell (8/26/2011)

---

MysteryJimbo (8/26/2011)

---

Dont do GUI. The GUI is very cautious when it comes to altering tables and will more often than not copy data into a temporary table, rename...

Lowell (8/26/2011)

---

I'm not sure if there would be an adverse impact if you had something like Change Data Capture running or something like that, so there's probably a good...

Dont do GUI. The GUI is very cautious when it comes to altering tables and will more often than not copy data into a temporary table, rename the original,...

What you are asking for is a traceflag.

http://sugeshkr.blogspot.com/2009/01/introduction-to-sql-server-trace-flags_14.html

3609 - Skips the creation of the tempdb database at startup. Use this trace flag if the device or devices on which tempdb...