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...

If you want...

i had not heard of iReport before your post, i was expecting a SQL related question, of course.

i guess...

ok weird requirement, this won't work if ad Hoc is disabled, obviously.

this works for me on my dev machine, which does allow adhoc:

--DROP PROC pr_Processes

CREATE PROCEDURE pr_Processes

@SERVERNAME varchar(128)

AS

BEGIN --PROC

DECLARE @sql...

justin_post (10/30/2012)

---

On the front end, new students get added regularly. If I used the view I created today, on Friday, it wouldn't contain any new students that had been added...