that's still a logical decision; from a static code point of vew, you could check if any procedure had a cursor: that would imply that it is calling some code...

this query would be an order of magnitude faster (at least!) for getting row counts per table.

something like this is what you'd wnat to wrap with sp_msForEachdb:

...

Partial match to what?

do you have a master table for states, for example?

your data had some single letter possible matches... if you filtered for the letter "A" or "U", how...

since redundancy type issues are logic based, i think you are stuck with actually reviewing the code. digging through the logic is a pain.

If you can give a better example...

looks like someone restored msdb ? or maybe actually did a DBCC CHECKIDENT with Ressed?

the diagnosis is easy, and so is the fix:

the diagnosis:

use msdb;

GO

DBCC CHECKIDENT ('dbo.backupset')

SELECT MAX(backup_set_id) +...

Mani I know you obfuscated the error, but i'll bet you an internet cookie that the procedure being called references a different database or different schema than what the procedure...

i assume the string can be anything, and not justa ~33 character GUID, right?

i think the right thing to do is to find find where the slash starts, and where...

imran.baig (4/16/2014)

---

But what if 2 users are using the same machine with their own user and password? It may be difficult to track in an environment with many users and...

the problem there is security, though, right?

an end user needs access to each of those tables in each of the schemas in order to use the view; ownership chaining gets...

my network guy was able to provide me with a list of user accounts + last workstation they logged in on;

I stuck that in a table, and use that...

you have to keep track of the files already processed someplace. that's #1. do you have that accessible?

Like Raunak Jhawar suggested, you'd move the processed files someplace, like to an...

Josh i inherited a similar solution once, and it depends on where it gets the next value from;

the original badly written proc would get the max value from a table,...

ben besides the join, i think you also have to be able to say where the level < previous level as well; that avoids the endless recursion

here's a rough example;...

Tom As far As I know, the trick to getting the column definitions is getting them into a temp table, so that piece is correct...

the real trick is to call...

well i can think of two things that might explain this:

1: you are not a sysadmin, and the object in question is outside of your permissions scope. ie the sysadmin...