This scripit will not work with

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)

I did a test I have a login that I know the password to.

Run the sripit...

this is how Idera solves the problem.

--Scripting Server Login (password is null) and Default Database

wothless and it took like an hour to run. In other words it was as...

I don't believe that sp_script_login.txt would work going from 200 to 2008 the reason is that it makes the same call to the sproc sp_hexadecimal that [sp_help_revlogin_2000_to_2005] and sp_help_revlogin...

Go into Books Online and read about the system stored procedure sp_trace_setevent

in there you will see a parameter called @columnid

If you read through the Document you will see a...

Multi-Server Administration sure takes on a whole new meaning in SQL server 2008.

I appreciate the article I tried to implemnt this in 2000 and found the jobs a pain to...

I take it the magical Icon table was never created?

Here is a stumber then to add to the discussion. What does the Red arrow pointing down on a icon...

good work. You gave me another tool for my arsenal and a fresh perspective on handling raw data versus "human" data.

I would say as other mentioned that you should...

Just added her to the brief case. Will have to get back to this when we leave logical and I have some damn transactional data to play with...!

Hey Neon,

How do you account for FK that have more then one column? This query wont work for those. food for thought.

Like it well enough, was hopping for a SPROC that took into account dependencies across the entire database creating levels. With these levels you could say work from the...

All,

I hate the formatting myself so thought I would share. This code was "borrowed" from Mike Pearson, thanks Mike...

As you can see it's all in the CASE.

select j.name,

case...

Jose,

The difference is a few things.

one if you pass a table name in you are forced to use Dynamic SQL the whole time your in the SPROC (messy if you...

Gift Peddie,

I don't want to take up much more of your day, so one last post.

I have read a ton of facts today about JET, the new XML office format,...

Gift Peddie,

Thanks for the quick reply will test.

Mr. Peddie,

Are you stating that there is a provider that you can register that will work to get past the original posters error with OPENDATASOURCE

SELECT "Key", "Value" FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data...