the poper use would be servername.databasename.schemaname.table

since your server name has a dot in it, it needs to be contained in square brackets

so I think yours would be [EEmpact.Bunnhill.com].[databasename].[dbo].[AIM024]

good point on the varchar(max). Also good info with the sys.sql_modules. I was not aware of that one.

we add ours to the sqlagentuserrole and sqlagentreaderrole in msdb. they are able to view jobs, but not control or change them unless they own them.

for ours, we clear out the TCP Dynamic Ports boxes for all the IP connections, and only fill in the TCP Port boxes, all with the same port. This configuration...

WOW, I just happened to be working on exactly that today. Since the syscomments table can only hold 4000 characters, some stored procedures will be split into multiple records. if...

I believe our developers install the full product on their workstations and use it from there. they use VS for DB Pros

depends on the number of sprocs you have and how much memory you have.

having all queries in sprocs is great for security reasons, plus SQL will cache the query plans...

try detaching the database and then move the files and try sp_attach_db stored procedure to attach the files.

thanks, I didn't expect to see a difference, but the print worked over the select. Thanks for the help!

I don't even need anything to print really.I'm just printing for debugging purposes. What I'm really trying to do is isolate the database name so that I can prevent a...

If I do this:

SET @xmldata = EVENTDATA()

print CAST(@xmldata AS NVARCHAR(MAX))

SELECT @xmlData.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(256)')

I get this (Note the blank line and 1 row affected - If I print...

thanks for the reply, but I was hoping for some native SQL commands. Since you can load an image into the database using native SQL commands, I figured you could...

can you provide an error msg?

we use SQLMail for some of our legacy stuff. there are a couple of test instances that we never could get it working on. It can be done though, wish...

Generally it is best to use a role and assign the appropriate permissions to the role, then add the appropriate users to the role. what you stated above is what...