DBASkippack (11/20/2008)

---

[font="Courier New"]I successfullybacked up my DB to 4 seperate files:

BACKUP DATABASE MyDB TO DISK =

'D:\MyDB_01of04.bak',DISK='D:\MyDB_02of04.bak', DISK='D:\MyDB_03of04.bak', DISK='D:\MyDB_04of04.bak' WITH INIT, NOFORMAT

Unfortunately, my RESTE IS NOT WORKING. I...

randy.witt (11/20/2008)

---

One of our software vendors says that we need to have Cumulative Update 7 installed, before we upgrade their software with the newest update. When I go to...

very good info.

Thanks

Johan

I see you did discover the dbmail helper objects 😉

- Does it succeed if you use a vbs to send mail using that smtp server ?

- double check the port...

if you would use included column, the B-tree part of the index would be smaller, so faster.

I should have to test, if SQLserver still would resolve the filtering based on...

Is your SQL2000 db comming from a sql2000 version that is supported for upgrade (i.e. >= SQL2000 SP4) ?

Arch ... formatted exports...

FWIW ... early 2008 I joined a webcast regarding mysql and performance.

The main eye catcher was "to avoid joins"... because that was apparently considered for the niche "oracle /...

IMO sqlserver in finally entering companies because msaccess no longer suites their needs (performance / size).

"insert disk and run" now gets some shop it guy to the point they...

system xprocs or sprocs are equal for 32bit and 64bit.

As mentioned by the urls, you'll have to build your own version.

If doing it using xp_cmdshell, encapsulate it in a sproc...

presentation ....... should be handled by the front end application !

(and preferably client side)

Do not bother sqlserver with how you want things actually presented for the human eye.

One of...

it's gone in sql2005 ... it was undocumented .... so shouldn't have been in use ...

check out :

- http://forums.databasejournal.com/showthread.php?t=41753

- http://www.simple-talk.com/sql/learn-sql-server/building-my-first-sql-server-2005-clr/

This is the same like having an insurance ...

As already stated, this may be a straight $$ matter.

Some companies want to cut costs NOW.

The only thing you can do...

Mani Singh (11/17/2008)

---

Remember, the trace is recycled based on the transaction level of you SQL Server. So you might end up filling up the trace in 1/2 a day or...

double check the path to the xp is correct.

Check its path on the "old" server or maybe even restore an old mastedb (to an alternate dbname !) to find out...