It sounds like you were looping through every stored proc name;

if the role is going to have EXECUTE priviledges on all procs, without exception, i think you can simply do...

well, it really on if (and how) you've set up your proc to return success or failure;

you know a proc can return results in any and all of three different...

convert the date right away to time, and then you are working with hours from 0 to 23:59:59;

so when you round the TIMe, it's between 0 and 23:

--returns 10 AS...

rebuilding indexes wth sort in tempdb, maybe?

Ok if you can connect via SSMS from the 2005 machine to the 2008 Express, you can create a linked server;

change the server name belwo, and tell me if...

there are a lot of variables in there...

for example, by default, SQL Express does not allow remote connections...it has to be explicitly enabled.

can you connect via SSMS from the Other...

for #3, a Windows machine that is logged in will pass the token related to the user to the SQL server.

the token has the built in assumption that if...

in the code you posted but snipped out, there is a GO statement.

variables are desroyed at every GO, so you need to remove the GO, or re-declare and re-assign the...

without an ORDER BY, there's no guarantee that this "header" will be in the order you are expecting, but it's simple:

SELECT 'Name|Address_line_1|Address_line_2|City|State|Zip|Territory_Code|LDC_Account_Num|Account|POWERFLOW|POWERDROP|Unbilled|NotDue'

UNION ALL

SELECT

CONVERT(VARCHAR(500),UPPER(SUBSTRING(ea2.last_name,1,1)) + LOWER(SUBSTRING(ea2.last_name,2,499)))

+ ', '...

i'm sure xp_cmdshell is limited to 4096 chars; that's a hard limit with no work arounds, as it's a feature of the cmd.exe object int he operating system.

Powershell might be...

if you convert to MONEY datatype inbstead of decimal, the data will convert cleanly;

otherwise, as Ninja stated, you have to remove the non-numeric strings like commas and spaces.

with MySampleData (TheValue)

AS

(

SELECT...

if object = something in sys.objects, then yes, you can get teh default trace to see who last created/altered/dropped

if object = data, then no, unless you have an auditing...

absolutely agree; something as simple as create a database and adding a table, then backing it up is the first step;

screwing around with the tables so you see the data,...

ramjohn8 (12/7/2011)

---

Yeah right now I'm trying to learn as much on the subject. The DBA at my company is willing to let me in on some stuff but right...

when your query contains single quotes, you have to escape them, as it's now dynamic sql.

this is updated witht hat change and is at least syntactically correct:

EXEC msdb.dbo.sp_send_dbmail

@recipients=N'my.email@gmail.com',@body='Message Body',...