I believe this is due to connections being made from a service on the remote server using integrated Auth and the service is running with "Local System" the the user.

try the sys.columns view. http://msdn.microsoft.com/en-us/library/ms176106.aspx

possibly powershell would work for you. You can run a powershell step from sql agent.

Something like this should delete all files older than 30 days except except file that...

extended events.

Here is a great blog post by Jonathan Kehayias to get you started.

http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/01/a-xevent-a-day-31-days-of-extended-events.aspx

posted to this thread a while ago.

http://www.sqlservercentral.com/Forums/Topic745531-359-1.aspx

SQL mail vs DBmail

biggest difference is SQL mail uses MAPI and DBmail used SMTP. use dbmail as it is more secure and does not need a mail client installed on...

this should get you close to what you are looking for.

SELECT

'Select '+

substring((SELECT ( ', ' + name )

...

Try Max(http://msdn.microsoft.com/en-us/library/ms187751.aspx) Appointmentdate with group by(http://msdn.microsoft.com/en-us/library/ms177673.aspx) on customerid.

look at using a union to get your sum.

create table #tmp (num int)

insert into #tmp

values(105)

go 4

SELECT cast(round(num*.25,0) as int)

FROM #tmp

union all

select cast(SUM(num*.25) as int)

FROM ...

Thanks for the explanation and point to the blog post.

Thanks Jonathan.

I just did a quick comparison between the extended events output and the sql trace output and I get a similar number of rows returned. I must just be...

maybe this will help http://www.connectionstrings.com/sql-server-2008

I would think they would need to specify "servername,port" in their connection string.

the following query (from sqlskills http://www.sqlskills.com/BLOGS/PAUL/post/Script-open-transactions-with-text-and-plans.aspx) will give you all open transactions on server. The "Begin Time" column will be null for transactions that do not have a corresponding log...

that would depend on the type of security you have defined on the linked server.

If you just ran the statement as is then your security context is set as "Be...

this should do it for you

EXEC master.dbo.sp_addlinkedserver @server = N'servername,port', @srvproduct=N'SQL Server'