The fastest operation is to detach it and attach...

Erode P. Satheesh (3/9/2009)

---

While I am trying to start the mirror, I'm getting an error . I can able to telnet Server A from Server B and Vice...

SELECT * from sys.syslogins WHERE dbname='yourdbname'

AS suggested varchar(max) is your best choice for large data types, nvarchar(max) if you are willing to use any national/unicode characters.

Is your default trace enabled?

check out this beginner's guide to default trace:

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

Transaction log backups does not disrupt Full backup process. You can definitely issue tlog backups.

But the question is, Why do you have to take Tlog backups immediately after a...

Yes as suggested Default trace will be right tool, load information into a table as it traces the events. You can look at: fn_trace_gettable function in BOL which extracts event...

I don't think you can downgrade a database form SQL 2008 to SQL 2005 it's not possible. Probably you could script it out and run it against the 2005 server.

Yep, found it Paul and voted it. It was my browser playing around with me:D. Thanks a lot!!

kerusy (3/9/2009)

---

I have backups that are done remotely, and would like to ensire that they are secure. How can i go about this?

And are there any free softwares that can...

How much did it compress to? How long did it take to transfer it over to ur USA...

Paul Randal (3/8/2009)

---

Or they may know all of that, but be totally socially inept - which would make them less than useful in an enterprise that requires teamwork or...

haha that's awesome!

But I think this discussion still goes on. You could really include those...

Hey Paul,

It was so kind of you to actually get some more views on this in your blog. The one which you blogged as "What's the name of the executable...

By default SQL server creates a clustered index on a primary key and a non clustered index on a unique key. As a rule of thumb yes, every table should...