a well designed and configured SAN should be capable of losing a fabric and still be...

what happens when you try

server\instancename?

Have you set the instance to use a static port or dynamic?

definitely sounds like an authentication issue

that would be depend on what virtualisation platform is employed and how it is licenced\configured!

7 separate VM's for homing...

AFAIK on a server side trace you would need to use the function fn_trace_gettable to read the trace file(s) into a table

when you launch the installer (via cd or control panel) you get the option to modify an existsing instance. You select an instance then elect to uninstall components from that...

denying select and insert should stop the users opening the objects, are you sure they havent been given sysadmin server role?

xp_regread to enumerate the installed instances in the registry 😎

Mohanraj (9/2/2008)

---

Hi All

Created Supervisor group in the Active Directory and added 4 person in that group. (AA,BB,CC,DD) - Windows Authentication users

Later, I have Added AD group Supervisor under Server->Security->Logins

This Supervisor...

nlion84DBA (10/24/2007)

---

Hello

Is it also true that you must be running SQL Server 2005 EE in order to take advantage of the space available by using PAE? Standard Edition cannot...

indeed the whole table is there for backward compatibility, the SQL2005 table is sys.objects

You will also find some other sys------- tables which are for backward compatibility too

if not using windows authentication then you would need to specify the following

EXEC @hr...

Lowell (8/29/2008)

---

when you delete a file, regardless of the recycle bin, the file is still there, but the disk space it used is open for use by other programs...if you...

ohh so true!

Vegard Hagen (9/1/2008)

---

What he should have done is of course to detach the DB, move the files and then...

DMC

we dont use maint plans (they generally are a pain). All our maint\backup jobs are scripted using T-SQL.

Any database maintenance ops should be carried out before a backup. As Gsquared...