Try to ping and connect (RDP) to the server during the time frame when users complain the server is not responding. Try to run SSMS from the RDP session. Also...

Execute this command from SSMS:

exec xp_cmdshell N'whoami'

Make sure the account listed in the results has the correct permissions to execute the BCP executable and to write to the destination folder....

You need to alter the text "servername" in the BCP command to the name of your server where you want to execute the query. Also alter the text "\\servername\d$\directoryname\" into...

spectra (9/13/2013)

---

I just want to extract user/permission from source machine and then want to run the same in my target machine through GUI way

Can I use idera for this...

spectra (9/13/2013)

---

I find it hard to understand....this looks a bit difficult process that other databases like mysql and oracle.

I am stuck because of the following reasons

Could you please tell...

1. Script all applicable logins from the source (use sp_help_revlogin: http://support.microsoft.com/kb/918992) and use this script to create the logins on the target instance.

2. Make a backup on the source and...

You could wait with the installation of SP untill you have added the node-installation of all three SQL instances. After the installation of all three SQL instances you can apply...

I totally agree!! 😎

But with such a limited sample you better prepare for the worst. Or at least provide different solutions. The OP...

If there are double rows (like the same NAME is entered twice both with the ROLE 'User') the solution of Koen will give false results. The code below will just...

Above you have conflicting...

Do you recieve an e-mail if you execute the code below? I have taken the original code and removed the IF statement (so it will always execute sp_send_dbmail) and removed...

Execute the query below to get a list of all e-mails sent by the instance over the past 7 days. Look specific at the results in the "sent_status", "event_type" and...

Please give us the DDL statements (CREATE TABLE) and some sample data (preferrably multiple rows) for each table. Tell us the expected results for the samples provided.

I also don't read...

Note that varchar values in Excel *could* be compatible with the...

Create a copy of the table as a teest-table. Use the import/export wizard multiple times to load the data of the Excel sheet one column at the time. This will...