There is no need to create such a script. The users will be restored in the new server with the database, because they are stored in the database. ...

Sysadmin is a server level role and not a database level, so you can’t add users to this role and grant them all sysadmin’s rights on 3 databases only. ...

I'd try to look at sys.remote_logins.

Adi

ps (12/13/2008)

---

You can also create a dummy database with the same name as your original database, shut down sql server service and overwrite your data files with original files. Restart...

It suppresses the message about the number of of records that were effected by the SQL Statement.

Adi

You can try running sp_dropremotelogin old_name (Have to admit that I was never in this situation, so I never tried it).

Adi

You can create a stored procedure and use the execute as clause. In then you can grant permissions to use this procedure to anyone that needs to be able...

jordonpilling (12/11/2008)

---

Greetings all

We operate 4 SQL Servers:

SQL Server 8 X 2 - About 50 different databases, with 2 main ones (that do alot of over night processing)

SQL Server 9 X...

Let me see if I understand you. You need to show a list of dates. Not only that the dates are important, it is also important that it...

Why don’t you specify what you need? If all you want is...

You can use the profiler and the database's ID as a filter

Adi

Why do you want to get the dates only during run time? With SQL Server 2005 you can use Common Table Expression, but since you are working with SQL...

The question that you should ask your self is – will it be beneficial to work with more memory. For example if you have only 1 database and its...

arup_kc (12/10/2008)

---

HI Gail,

Want 2 know something.

"Also u may try to tune each query individually, like

use WHERE NOT EXISTS(SELECT 1 FROM D_Allocation D...

instead of WHERE NOT EXISTS(SELECT D.Label FROM D_Allocation D..

There's...

Just use information_schema.routines view:

select routine_name from information_schema.routines where routine_type = 'procedure'

Adi