Not for those of us who are considered exempt from OT, which...

Unfortunately it comes with the...

If anyone else can provide some guidance here it would be appreciated.

Chill.

No, don't move the system databases. Script out the objects you need from the source server and run those...

Example:

@LastName VARCHAR(100) -- defined as VARCHAR(100)

@LastName = N'c' -- value being passed in is NVARCHAR (the N in front of the...

Not that I am aware. I am not familiar with log shipping as I have not worked in an environment where it is used at this time.

desiree.reagan (4/20/2010)

---

I've been told that once a user is connected to SQL Server using a trusted connection, they would then have access to all databases on that server.

I...

Hope this helps:

create table dbo.tbl_processes (proc_nammme nvarchar (500))

go

insert into dbo.tbl_processes values ('ProcessName:SqlWb |CpuUsage:5')

insert into dbo.tbl_processes values ('ProcessName:CPU Burn-in |CpuUsage:99')

insert into dbo.tbl_processes values ('ProcessName:cscript |CpuUsage:8')

go

select

*,

...

Thank you.

Based on this:

dbname_20100420115115.trn

current datetime 201004201453

The time difference is 3 hours, not 4...

Post the code for your stored procedure and the code where you are executing it.

If you solved your problem, it would be nice if you posted what you did. Someone else may have a similar problem and...

Couple of questions as it sounds like you are running log shipping. How did you setup log shipping and what is your time zone?

Paul White NZ (4/19/2010)

---

anthony_merriwether (4/19/2010)

---

Someone gave an example about a DBA asking a basic question that was readily available to him or her that was easily solved by a little...

I would still like to know which question you were refering to initially.

anthony_merriwether (4/19/2010)

---

Did any of you Water Coolers give the person who posted the request, an answer? I would venture to say no. I am not a troll whatever...