Check this thread: http://www.sqlservercentral.com/Forums/Topic530477-1329-1.aspx. It's a discussion thread for an article about the dtutil command line utility. I haven't had the need for this yet, but the script...

sreedevi.balan (4/30/2009)

---

Thanks for the update mike..

But this is not what i want. I just want to know all the rights granted to the user like create database or create...

I think it was the first (and one of the few) movie I saw more than once in a theatre. And my friends and I had to drive more...

Anil Kumar Kurra (4/29/2009)

---

Hi Charles,

Thanks for the reply. My Stored Procedure contains the cursor. The output of the stored procedure contains all the Logins and their passwords...

You don't have to recreate the job. You will have to deploy the new version of the package to the expected storage location, though. Just repeat what you...

You're doing this in Management Studio? Are you connecting to an instance on your local machine or on a network server? Try looking on the "Network Servers" tab...

linda_web (4/29/2009)

---

;-)When I tried to login to one of the 2005 SQL SERVER, I typed server name “computer name”, then typed correct username and password. But didn’t allow to log...

This article http://thiagsundar.wordpress.com/export-data-to-text-file/ discusses several options for this. Personally, I'd create an SSIS package that executes the stored procedure and has a flat file connection for the destination file....

For the tables that have identity columns, click on the "Edit Mappings..." button in the Wizard and check the "Enable identity insert box. This will disable the identity increment...

I think the closest you could get to that would be to change the password so the login would fail. It begs the question though, why you want to...

This is exactly what foreign key constraints are meant for. Foreign keys on the columns in books reference the corresponding primary key value in the ancillary tables. When...

Please post the definitions of the two tables i.e. Create statements, your queries and the results you expect.

Thanks

Script the tables and create them in the destination database, then use the Import/Export Wizard to copy the data. Or create an SSIS package with a Transfer SQL Server...

You have to open the package and execute it withing DTS Designer. Alternatively, you can create a SQL Agent job with DTSRun in a job step.

You can see that information in the Job Activity Monitor screen which is displayed immediately under Jobs in the SSMS Object Explorer.