This thread was an awesome read!

@M_E_K, if this query is consistently pegging your DB instance where it affects other activity consider a defensive move...add a MAXDOP hint to the problem...

Use SUSER_SNAME():

SELECT name,

SUSER_SNAME(owner_sid) AS job_owner

FROM msdb.dbo.sysjobs

ORDER BY name ;

There are some restrictions but consider using BCP Native mode to get the best performance when transferring data between SQL Servers.

http://msdn.microsoft.com/en-us/library/ms191232.aspx

Congratulations Jeff, and Thank You for all you do 🙂

RTSConsult (9/20/2011)

---

hmm ok so thr param is after the where clause. and the string value would be my repeating value for the name of the db correct?

as for the...

RTSConsult (9/20/2011)

---

Yes Sir! 🙂

so hate to do this to you but a couple more questions arose once i ran this and it worked as expected.

1. Can...

Excellent! HTH 🙂

Are you running this on the same server where the SQL instance is installed?

Use the same server info you would plug into SSMS.

You can to use an application programming language, e.g. one of the .NET languages, to write the binary data selected from the table to a file.

RTSConsult (9/20/2011)

---

hey so another question.

I may want to only select to add them to 1 database.

Can i change line 23 to use the db name and forgo the...

You can use tail.exe. Microsoft released a version in the Windows Server 2003 Resource Kit and it works on Server 2008 as well: http://www.microsoft.com/download/en/details.aspx?id=17657

Or you can get an open source...

Here is a PowerShell 2.0 script that:

1. Reads a list of Windows users from a text file.

2. Creates a SQL Server login for that Windows user on an instance you...

What is the default database of login domain\user ?

Are you setting @execute_query_database in your call to sp_send_dbmail, or are you database-qualifying all object names in your query?

This will show you all the Windows Groups registered as SQL Server Logins that the login you're wondering about belongs to:

EXECUTE AS LOGIN = 'windows_login_name_with_access' ;

GO

SELECT sp.name

FROM ...

I know this is an old thread, but I am having a similar issue. Did you ever make progress on the issue?