I saw solutions that used Group By without aggregates.

I answered correctly, but please, post the reference for the search order.

I found one at SQL Server 2005 Books Online at:

http://msdn2.microsoft.com/en-us/library/ms190387.aspx

User-Schema Separation  

that says: "...In SQL Server 2005,...

Jeff,

I don't know. There are no more ReportServerCervice logs that looked like:

ReportServerService__11_19_2005_12_58_08.log

but there are 2 short logs from Report Server (without Service) like

ReportServer__11_21_2005_11_29_10.log

I will better apply the service pack.

Thanks for...

Thanks!!!

I will do that. But I will keep trace level 0 (no logging).

Do you know by chance how to move log files to another location, for example to another drive?...

Hi,

I have to think about the dynamic implementation, but I do the following that I think can be modified to be implemented dynamically:

1. I create SQL Server Views that will...

I answered correctly, but I would record  a trace and then select fileds for LoginName, NTUserName, LoginSID. When it is SQL Authentication thenit will be LoginName + Short SID, NT...

Hi,

This error message is when a Windows user is trying to connect to your SQL Server and SQL Server can not resolve his SID. For example, this user is from...

Hi,

The first difference is that it is 2 different users running the show, you personally in Query Analyzer and the application login for the Web App. There may be many...

Unattended.iss  may actually contain a section [CDKEYDialog-0] for CD Key.   iss files are text files, so users will have a CD key as well.

I would create a package using any packaging...

Hi,

In addition to the Kemp's solution you may try to use Windows Scheduler to copy out the backup and run the scheduled task like 30 min after your SQL backup...

Mike,

Did you check the pasword for the person on a new server?

The user on another server may exist but his/her/its password is different from the one you have in the...

Hi,

Sql Junkie  Posted a question yesterday at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=237536

asking how to make SQL Server Agent to post a message that...

Hi,

"Unknown owner" happens when the owner can not be resolved: for example someone's Windows login was the owner and this Windows login does not exsit anymore or Domain controller is...

Kory,

I do understand what you are asking. The service startup account can be anything even with minimal privileges, the only thing it should have is the access to the folder...

Kory,

then your Windows login should be a member of Administrators or Power Users or as our sysadmin suggested here, maybe Backup Operators too have the same right. From within SQL...