You can use also something like this:

SELECT  TOP 5 MAX(salary_col) AS MaxSalary, Employee_ID

FROM   employee_salaray

GROUP BY employee_id

ORDER BY MAX(Salary_Col) DESC 

With some rest, I was able to think better!!! I got it and everything is back to normal. Just FYO to close this case!!

hi Doug, I resolved the problem by creating a backup device and then I can do the staright restore form EM. In any event, the syntax for UNC names should...

hello, that error has to do with the NT AUTHORITY\SYSTEM permissions. do you have that users in the server users? It is not SQL Server. Microsoft has that know issue....

Thank you, yes I did!

Don't do anything with sa, maybe the best way is to set 1433 inside the firewall and not allow any access thru that port. You can use NAT to give...

How are you running the export? Via DTS? if you run the statement in Query Analyzer, the results also truncate the field?

DTS has a way to set the size of...

Thank you. I will check this out as soon as I get back to the office tomorrow.

forgot, the only sure thing is the period is the separator. Thank you

Sure, it reads something like this:

CEO.New Address Validated.Location: \\Main\e:\NewAddressValue.Last Update Jeff Morgan

Another one reads like this:

CSR_HelpDesk.Starttime: 9:30AM Midshift.Changed Supervisor HR request.New Sup Anna Holland.New Shift: 7:30 AM

OK those are...

Thank you for your input. parse name does not work because the values are not as concistent as we want to have and split does not work either. Even though...

Thank you all for your input. I did work with Veritas in the past and it is a pain in the neck, to say the least, the other con against...

maybe this could help.

backup log model with truncate_only

-- This backup the log and truncate the log

dbcc shrinkfile(modellog,10)

-- The second part runs a DBCC to give the log the size you want.

I...

Hello there, I went through the idiot's guide on my own! Basically profiler is a tool to check SQL statements to help performance...

Hello, maybe this could help. Within the same job, create a 2nd schedule. This will allow you to set different schedules without creating a 2nd job. Just an idea! Hope...