Thank you. That did it!!

Brian,

I am experiencing the same issue with some jobs in one of our servers.

Would you please elaborate a little bit further and, if possible, place some example code to...

Thanks anyway Andy. This site has beeen my right hand for quite sometime and I am always grateful for each issue I have had and all the answers and suggestions...

Thank you all. I did figured it out!

Thank you. jobs are run with a Windows user in all other servers and they run fine. the users have admin permissions as well as SQL Server admin rights. What...

I did forward my resume directly to you. One question though, if accepted, are moving expenses considered as part of the package? Than you

Jim Kirkpatrick

Symantec

I did forward my resume directly to you. Thank you.

I did not have the chance to add the new column. The text file definition did not show up at all. That is why I tried to create a new...

It was just an opinion on the distinct and the count. I did not pretende to go further than group by name and an extra column in which you have...

I will use:

select name, count(name) as namecount

from tablename

group by name

order by name

I won't add distinct. The reason? if you are grouping by some field, SQL knows that it needs to...

I found the article and my apologies to Steve Jones. He wrote the article. Here is the link:

http://www.sqlservercentral.com/columnists/sjones/gettingyourserverinformation.asp

Hope this helps. Good luck!

About that, yesterday I read a posting in which one of the paricipants (I think it was Andy Warren) explained that it is better to use @@version because it grabs...

I agree with Allen_Cui, Linking servers using SQL authentication should not be a big of a deal as long as your machines are behind your fire wall. You need to...

AER,

SQL Sercer Central posted a script to force shrinking files a while ago. Have you search the site? I grabbed the script and here it is.

It was written for SQL...

Matt1,

I do use windows performance and add SQL instances like memory, users, etc. This way I can monitor the SQL Servers other than the options giving by SQL Server Profiler.

I...