you would have to search the definition of the procedures to search for the CREATE TABLE statemenet;

SQL does not save information about who or what created any objects...just the create...

the problem with abstracting out the problem is it hides the actual issue.

i suspect that this would involve splitting ont he # sign, cleaning up any elements that meet the...

bcp is a command line utility...not a TSQL command.

if you get the error in a command window, it's because bcp is not in the path...so you need to use the...

I'm a lot less worried about performance impacts of server side traces than most people i guess;

I have three traces that are created by procedures that have been marked as...

just expand the number of columns being updated;

...

SET AA.Polcinumber = BB.Policynumber,

Column2 = GetDate(), --a function fromt...

assuming the ID is the join criteria between the two tables, this will do it:

UPDATE AA

SET AA.Polcinumber = BB.Policynumber

FROM BB

WHERE AA.ID = BB.ID

AND AA.Polcinumber <> BB.Policynumber

Try this stack of queries; they all give you some various information about what permissions your current login belongs to:

select * from fn_my_permissions(null,'SERVER')

select * from fn_my_permissions(null,'DATABASE')

--some inferred roles I may...

I'm with Braindonor:

I'd lean towards no instance at all.

just add a database to the server, create the user for the application with the appropriate permissions.

one instance with multiple databases...

That's what we've been trying to tell you.

SQL Server is designed to...

glad I could help Ali;

pay attention to the code at the bottom, which is creating a VIEW named sp_MyTrace so you can query the trace any time, with...

after an upgrade to a higher version, it's pretty much manditory to rebuild all your statistics;

the statistics in place are used differently by teh updated query engine, so if you...

a profiler session or a server side trace can catch...

i believe that can happen if a transaction between the server and a linked server gets rolled back, but never completes the rollback.

if you check sp_who2 for spid = -2,...

also take a look at this detailed 5 page thread on trying to delete all temp tables from tempdb.

http://www.sqlservercentral.com/Forums/Topic627590-146-1.aspx

a quick recap: you cannot drop tables from other connections that you...

yeah, i had mentioned "get you closer", because i saw you'll need to modify it some, and wanted you to understand that part.

looking at your cursor, do you notice...