Okay here is a simpler query that i need Central time and date but it is in UTC format;

select ServerName, Heading, UTCOccurrenceDateTime

from dbo.Alerts where Heading like '%fail%'

AND (UTCOccurrenceDateTime >=...

oh and the timedatestamp is

YYYY-MM-DD HH:MM:SS:MMM

Someone help me please, so confused and it so easy....

Lowell,

Here a query that returns count without the date and time convertion

SELECT Column1, COUNT(*) AS [Count], Column3, Column4

FROM ...

I have thought of that ALZDBA, ah can't wait to spring forward...

Thanks Lowell but it still came back with UTC time, Basically I am trying to convert the time and then count Column1, Column3, and Column4, and order it by Column1...

Thank you Gail, I have perople breathing down my neck, really overwhelmed at the moment...Thank you!:-D

Can anybody cut the exclude and paste it in here. That script is a little overwhelming to me.

The DB is crazy. In orde to get the index to rebuild we are going to have to exclude about 10 and place them into another job. The other job...

Thanks, I figured it out and I am using Red Gate! Good Luck if you ever have an issue!

Anybody have any ideas?

I removed log shipping and put it back in place noe will it not copy over the *.trn file but now if I set off the LSCopy...

Found it!

select SessionLoginName, * from FN_TRACE_GETTABLE ('C:\Program Files\Microsoft SQL server\MSSQL.1\MSSQL\LOG\LOG_382.trc',default)

you need at least sp3 on sql 2005. If you click on a shorcut and it goes down, sounds like a hardware spec issue. Was the hardware ready in spec...

Okay I got it back online and this is what I did.

1. sp_get_distributor

2. delete from msdb.dbo.MSdistpublishers

delete from msdb.dbo.MSdistributiondbs

3. sp_adddistributiondb 'distribution'

4. Created a new publication and enabled it

5. created...

I got it to work thanks!

Mike,

This is what I get, can you help me out?

Msg 21110, Level 16, State 1, Procedure sp_browsereplcmds, Line 48

@xact_seqno_start and @publisher_database_id must be specified if @command_id is specified.