Viewing 15 posts - 1,321 through 1,335 (of 1,479 total)
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. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2008 at 8:45 am
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. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2008 at 4:10 am
I'd try to look at sys.remote_logins.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2008 at 2:31 am
ps (12/13/2008)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2008 at 2:24 am
It suppresses the message about the number of of records that were effected by the SQL Statement.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2008 at 2:05 am
You can try running sp_dropremotelogin old_name (Have to admit that I was never in this situation, so I never tried it).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2008 at 1:52 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 12, 2008 at 7:50 am
jordonpilling (12/11/2008)
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 11, 2008 at 6:18 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 10, 2008 at 2:41 am
sabarichandru (12/10/2008)
i need for to run the single line statement in Tsql without using any specific tables ..
Why don’t you specify what you need? If all you want is...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 10, 2008 at 2:15 am
You can use the profiler and the database's ID as a filter
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 10, 2008 at 2:01 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 10, 2008 at 1:55 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 10, 2008 at 1:25 am
arup_kc (12/10/2008)
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 10, 2008 at 12:56 am
Just use information_schema.routines view:
select routine_name from information_schema.routines where routine_type = 'procedure'
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 9, 2008 at 10:45 pm
Viewing 15 posts - 1,321 through 1,335 (of 1,479 total)