DiverKas (12/10/2008)

---

No I'm right. SSMS may create...

From BOL

The Database Engine does not automatically generate values for the column. To insert a globally unique value, create a DEFAULT definition on the column that uses the NEWID function...

yes but sp_attach_single_file_db recreates the log file.

In this case the database was attached and no log file was created or accessible.

I'm not permitted in SSMS to use the DB... but the error I get when I try is a permissions type error

12/08/2008 00:00:47,spid58,Unknown,FileMgr::StartLogFiles: Operating system error 2(The system cannot find...

Jeff Moden (12/4/2008)

---

Does that mean you're using the cross-tab...

guptaajay1985 (12/3/2008)

---

Dear

May it work..

Starting Connection window of SS2k5 has Server name field in which u insert the name of the server and then give userid and password.

Now in the...

Jeff Moden (12/3/2008)

---

ZA_Crafty (12/3/2008)

---

I've never used Crystal reports myself... is there a place or menu where you can figure out the correct indexes for some of the more complex reports?...

My favorite way to do cross-tabs is to cheat..

Put the data into a cross tab friend format (measures and values to break it out by)

and feed it into crystal reports.

That was just an amazing read... learned some neat tricks that I didn't even think were possible (but in retrospect should have known)... very informative...

And that's where I would disagree. Included columns in 2008 are a feature that was introduced in 2005. They're nothing new to it.

Both 2 and 3 are correct.

These days it's very important to know when features were introduced. Include wasn't an option pre-2005. What it does is part 3.

Check boxes...

Resource wise things seem fine... all my cache hit ratios run around .50 or so...

It's 2000 copies of the same database (with different data in it)... I wonder if...

Well I was wrong... it's got 5 nodes (apparently another node was brought up without telling me)... each running different active instances. The cluster group has 5 small instances...

rbarryyoung (11/11/2008)

---

Are most of these databases not in use or something? Because this honestly seems waaay over the top. I mean how much memory do you have that...

Ah Profiler is your friend!

Captured 2005's doing this when I profiled the attach of a database via the GUI.

declare @Path nvarchar(255)

declare @Name nvarchar(255)

declare @fileName nvarchar(255)

select @fileName = N'E:\mssql\data\testdata.mdf'

declare @command...