does the comments...

SELECT * FROM FROM sys.objects

, yeah the parse assumes the second FROM is a table name, and so the alias 'sys.tables' is an error.

a longer, better error message comes from...

I've played with this a couple of times, Jason; i've used it to chop a SQL statement into elements, so i could play with building my own formatter, and of...

Data is the first thing that comes to mind.

If you save any data of any kind in that database, it would of course be unique to you and your...

because you...

On computers running...

here's a link to a copy of the pdf that doesn't require his damn password.

boy that pissed me off for some reason.

oh, and some of his code example references the...

opc.three (11/1/2012)

---

Lowell, do you have any definitive info on whether the Server Proxy extends to other external operations besides xp_cmdshell? I would be interested in a reference to help...

What? without system stored procedures? like msdb.dbo.sp_send_dbmail?

so you are saying instead of using the built in,...

these issues are notoriously hard to dig for...there's a connect item out there stating why not add the column name of the violating size issue to the error message.

because this...

note that the end user may have troulbe if they don't use SSMS for connecting;

as an example, i created this login:

USE [master]

GO

CREATE LOGIN [ExampleLogin]

WITH PASSWORD=N'NotTheRealPassword'

...

I have this procedure to help me kill users in a specific database:

usage is this easy:

sp_kill DatabaseName

and the code:

CREATE PROCEDURE sp_Kill ...

if you are selecting a row that is full of nulls, it would appear as an "extra" line in your file when BCP is finished.

here's a working example, assuming...

something that might help a little bit:

if you create a procedure that references a non-sys object in another database, you can find it via the sys.dm_sql_referenced_entities() function

here's an example...the server/database/table...

It sounds like the account used in Services has access to the shares(because that's what sa /sysadmin's would use for credentials outside of SQL server, but that the proxy_account is...