LOGIN login_name

Specifies the SQL Server login for which the database user is being created. login_name must be a valid login in the server. When this SQL Server login enters the...

The time...

kkapferer (3/4/2010)

---

Sarab,

Thanks for your response. This is a non-critical production system, so I will be able to recycle the instance in the off hours today. I'll also look...

vbprogrammer1986 (3/4/2010)

---

then you can restore the day 3 diff on top of all without restoring full backup again, but the restriction remains the same the last backup which was restored...

to restore the diff backup you should restore full backup first.

but in your case if you've already installed day 1 full backup and then

restored day 2 diff backup on...

You can use the undocumented procedure described here:

http://solutions-guru.com/articles/sql-server/86-undocumented-procedure-spmsforeachtable-a-spmsforeachdatabase.html

gmamata7 (3/3/2010)

---

Hi,

We have sql server 2005 enterprise edition with SP3 and all the storage is from SAN and all drives are RAID 10. We are getting high disk queue length...

Never got such exposure but try google 😉 you can find the step by step too

like this one:http://msmvps.com/blogs/shane/archive/2009/04/29/install-guide-sp2-for-sharepoint-wss-v3-and-moss-2007.aspx

ALL D BEST

crainlee2 (3/3/2010)

---

I'm working on a database offline tonight and I set it into single user mode.

I'm logged on as "sa".

Now, I can't access the database. Can anyone give me any...

create a login on one server and use sp_help_revlogin to script the login and use the output of the sp to recreate it on another server

visit this link for more...

If the server is not business critical restart the SQL service and it will recycle the error log.

is there any anti-virus running on the server, if so, make exceptions for...

Hi Bhuvnesh,

that worked like anything.

which method are you using to script out the login?

theres one catch to this, scripting the login and recreating the login on another server will only...

Bhuvnesh (3/4/2010)

---

can you do a test for me ?. just create a sql auth. login in one instance and migrate it to another one and then try to login...

No, you don't have to reset the password, the moment you script out the login, it captures the password along with login.

--...

sqlquery-101401 (3/3/2010)

---

I have a requirement where my connection string in web.config of IIS will connect to SQL Server with SQL Login so i have to supply the password in the...