not sure about the error; it's so wierd that it refers to a backup.

whenever i've used sp_msdependencies , i've always used the parameter @intrans = 1 ,

and i'm...

i usually add a blank xsd file to my project, then with server explorer, create a connection to the database.

once that is there, you can drag and drop all 60...

i had done this requirement before, but additionally one of the values had to be populated...i didn't see if both values were allowed to be null or not;

the only way...

ok this was kewl to know;

once you doink up an object name so it has a dot in it, you need your brackets around the object, and it was easier...

{edit after i posted, i saw this is in a SQL 2000 forum, and this requires 2005 and up.

doing this in SQL2000 usually requires asticking the results in a temp...

it's an ugly implementation, but it works.

it's based on the actual contents....if something was defined as a varchar(max), how big is it in a fixed with file?

for me,i'm looping thru...

good job on providing the table structures and the desired output;

if you had posted the INSERT INTO for the data, your question would be perfect!

to convert rows into a comma...

ahh that's just syntax; the SET switch is for IDENTITY_INSERT, all one word with an underscore,no brackets around identity; i fat fingered my example and forgot the underscore.

--you had SET...

he had a similar thread on this;

i think the original poster is trying to get a formula like (#records matching my WHERE clause) / Total Records, but he thinks it...

Seriously? you need to ask? just by the question itself, you can tell it involved moving something(migration)

from one server to another vs upgrading an existing server?

you are posting...

i just saw something with that same question here that woudl probably answer the question more completely.

another thing I've done is use a Tally table to split the company name into single words....then try to match the single word against another copy of the table;

that way,...

apache i don't know SSIS, but i know .NET;

I've already written some code that i use in .NET all the time that takes any dataset and returns the data as...

Hi Neel;

I'd expect anything called 10K times to be in the realm of a max of 400 items per second; so for 10K calls, i'd expect that to take 25...

dynamic sql....

declare...