Our government guys are trying to get rid of identity theft but i'm sure that some corrupt official will need be selling the information long before the cards are issued...

Brandie Tarvin (7/15/2013)

---

GilaMonster (7/15/2013)

---

One of the worries I have when travelling is that I have my passport, ID book and driver's licence with me all at the same time. It's...

Hi Gail,

it is rather intimidating renewing Driver's License is a process and a half, either you need to be first in line or you will spend the whole...

Just a shot in the dark but try an if exists option

DECLARE @dbname nvarchar(128)

SET @dbname = N'Production'

IF (EXISTS (SELECT name

FROM master.dbo.sysdatabases

WHERE ('[' + name + ']' =...

HI

you need to find out what is keeping your server busy? have you looked wait state issues on the server.

otherwise setup a trace to get some perf data to...

Are you trying to get an execution plan for the whole script block or can you generate it on a per query basis.

The error can't find the object. ...

Screenshot isn't showing.

I would investigate if other WMI commands are working.

No, that is available standard no additional configuration is required.

I like the 3 envelop option...

Best line I've heard is we have SRM in place that is all the DR we need...

Just wondering have you checked the package isn't already running?

Hi SQL Geek,

read the two articles that GilaMonster gave, they will be the least invasive.

GilaMonster (6/5/2013)

---

I would strongly recommend not...

Open profiler,

File, new trace.

Connect to your sql server.

Use the template -> select Tuning

select save to file -> choose a location with sufficient space

select -> enable trace stop time 10...

Run a trace to see what is causing the "traffic"? Analyse the results or post an extract for assistance

It all depends on what you want...