First step to do before actually launching any upgrade/hotfix = backup ALL databases !

This way you are safe to at least a reinstall up to your current software level.

Most...

I've seen some demo stuff using the approach that every doctor had his own ssl certificate used for encryption of e.g. diagnose varchar columns, so only the one being granted...

This is the classic behaviour I wanted to point to in my warnings

http://www.sqlservercentral.com/Forums/Topic567766-8-1.aspx

- Did you switch your db to db-level 90 (sql2005) or did you leave it on 80 after the restore ?

- You need to rebuild all indexes.

- you need to...

How much do you trust your dba ?

Don't you have deonthology rules ?

Implement SOx or HIPAA guidelines, so that every (high privilege ) access needs to be justified by a...

Oh yes, functions can be like troyan horses,....

they may serve you very well, even for a long time, until your system reaches the condition for them to burst open...

SQL will try to balance the content of files in the same filegroup.

If you want to take that under your control, you should create your own filegroups and move...

the best is to retrieve as least as possible rows and columns using the minimal effort of I/O (and cpu).

Design your objects according to Dr Codds rules,and you'll be fine...

Is the job owner being granted use of the mail and the mail profile (at sqlserver level ! )

Sqlchamp (9/12/2008)

---

restore db step failed.

sp_help db test gave result test db does not exist.

Again in a nutshell I am trying to automate db and tran log restore via sql job.

I...

gomikem (9/12/2008)

---

I have some SQL in the code of one of my reports that calls fields from linked (SQL) tables and some pass through queries stored in stored procedures. When...

I'm sorry, I've overlooked the fact I was using sqlcmd. :blush:

Copy / paste .. you know :ermm:

did you try using the column separator parameter ?

from bol:

http://msdn.microsoft.com/en-us/library/aa214012(SQL.80).aspx

-s col_separator

Specifies the...

well ... here's what I used...

http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html

-- how to determin SQLServer Uptime

-- Source: Tracking Uptime by Brian Moran http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html

--

--

SELECT @@servername as ServerName, datediff(mi, login_time, getdate()) as SQLServer_UpTime_Minutes

FROM sys.dm_exec_sessions

WHERE...

If you log load isn't that much, you may want to consider making a full backup and use log backups.

Then you can restore the full backup (norecovery) (first...

Does anyone know what the terminology GDR and QFE means in the bulletin ?

It mentions SQL2000 GDR , SQL2000 QFE, SQL2005 GDR , SQL2005 QFE.

Am I having a weak...