Go thru the below KB: http://support.microsoft.com/kb/918992 You have to use 'sp_help_revlogin '
Glad I could help, you are welcome
I figured it out myself with the help of a friend. Spanning the same command across multiple lines is not possible, my main intention in asking this...
I had to deal with similar issue before, check out the below and see if it helps...
Hello I am trying to use sqlcmd to run a set of sql statements. If I use -i switch and input a file with sql statements, it is working fine, but I am...
From the research I have done, the log reader agent reads only the transaction log and not the actual table. So we should be good in doing a create...
I guess you are doing this just for user databases, you can also customize the query by using sql like belo which drops users only from user...
A table called 'Customer' is a part of publication and is being replicated via transactional replication to another server. If I have to create an...
Thanks for the input I figured out what needed to be done. I had to 1. Create an AD group and add the service accounts to that group. 2. Add the...
I am trying to install SQL Server 2008 on Windows server 2003 and have a question about the stage of 'Cluster Security Policy'. We need to select 2...
Hi Arun Thanks for your input, turns out the problem I was having is explained below:...
I have a situation where a deadlock has occured because of keylocks being placed. I am trying to understand how keylocks work and how to resolve...
Thanks for the replies and suggestions, I was able to do some readingon batch commands and able to come up with below scripts for myrequirements,...
Hi I have a set of scripts that need to be executed against ahuge list of sql instances. Instead of opening a connection againsteach sql instance...
Is there a reason why you set the max growth for a t-log file to be 1 GB? If you have enough space on the disk, please set it to reasonably large. I...
I could find a consolidated solution in the below link...
First question, do you have auto growth enabled on the transaction log file? Go to properties of the database and check the tab 'files' and then...
Hi I know we can configure the alerts for the transaction logfile space used using the SQL Server alerts and configuring an alertfor SQL Server...
Hi Is there an archival/purging process that is going to be put in place? If your requirement is to eventually archive the data systematically as the...
I am planning to have a alerting system that monitors the data space usage within the physical files and I can see that 'dbcc showfilestats' can give...
Separate names with a comma.
