Steve Jones - Editor (2/13/2008)

---

An insert/update would cause a last modified time to change, but I think the file has to close for this to be triggered. So the last...

run profiler whilst representative work is taking place and feed the results into the index tuning wizard? The recommendations it gives compared to the indexes you have could give clues.

andre.deslauriers (2/5/2008)

---

Open the registry of the SQL Server machine and navigate to HKLM\System\CurrentControlSet\Services\lanmanworkstation\parameters

Create a new DWORD value named SessTimeout

Set the value to decimal 600 (hex 0x258)

This...

the date and time stamp on database file will only change when the file is modified as far as the OS is concerned, which would include file grows or shrinks....

I'd have to disagree with Tommy and say you can upgrade by restoring a backup from 2000 to 2005, for user databases only, not the system databases. Its a perfectly...

in enterprise manager select 'Tools' from the menu bar across the top then select 'SQL Query Analyser', you can run the script from in there having made sure you are...

welcome to a real DBMS where you don't need another database and a week long course to...

adam, our last posts crossed...

I need to automate it because I have a log shipped server with multiple databases, log shipping in both directions. I might need to fail over...

Adam, thankyou so much. I thought there must be a way to do this in SSMS as it was possible in enterprise manager. Unfortunatly to me things are not as...

If you want to stripe your backups to multiple files you have to use backup devices to do this, you cannot stripe using the 'to disk = 'fi'lename' ' option.

apart...

Sugesh, thanks for trying but I need to script out ALL the jobs and the first URL is the SSMS method to script out a single job and the second...

where it asks for the file extension make sure you put just 'bak' and not '.bak'

Absinthe, great script and very timely. I am migrating databases between data centres which are ring fenced so using 3rd party tools to compare could be problematic.

The auditors require...

It can't do any harm to re-try the SP4 install, if SQL thinks it is complete already it simply won't do anything.

did the install bomb out? Did all the upgrade...

lets have one from the admin viewpoint - how about the maintenance plans. More flexible but just not as intuitive as in 2000. Nothing like those jaw dropping moments when...