(2) View the data? What if you want to modify it?

(3) That's interesting - I've never used it. Does it include foreign key constraints?

(4) So the numbers are...

(1) Security. You can only have one password per spreadsheet, instead of one per user. And Excel passwords are very easy to crack.

(2) Concurrency. It's much easier...

Even if a query runs quicker without a where clause, this isn't necessarily a reason to leave it out. That's because if you return more data than you need,...

washawgolla (7/28/2009)

---

As I said I was using xml file configuration to make my package portable; but I an facing a problem

the connection string property of the OLE DB connection manager...

Look up the SERVERPROPERTY function in Books Online. One of the options tells you which physical node you're running on.

John

Jeff Moden (7/21/2009)

---

Heh... don't over look what's in Books Online. If you lookup "DBCC SHOWCONTIG" and scroll down, you'll find a section with the following label...

[font="Arial Black"]E. Using DBCC...

sqlbuddy123 (7/21/2009)

---

Hi Wayne,

Here is an article which says that it's not recommended to have more than one instance installed on a single cluster node.

http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx

...

Kevin

Try xp_msver. It returns lots of information on the processor, the Windows version, SQL Server and more.

John

Scott

I'm pleased that you found your answer, although I notice that the final query you showed doesn't look much like your original requirement!

I'd encourage you not to put object names...

Have you looked at DDL triggers? As far as I know, you can create a trigger that will fire when a DDL event (such as creation of a database)...

Got errors when I posted this and now it's there three times! And it won't let me delete it, either.

Got errors when I posted this and now it's there three times! And it won't let me delete it, either.

I think Jack meant to say SQL Server Configuration Manager (SSCM) instead of Surface Area Configuration. It is important that you change service accounts here and not in the...

One irritating word that's spilled out from IT into the wider world is solution. Ready meals are now meal solutions, and stereos are now home entertainment solutions. I...

Here's another couple of reasons why backup/restore may be better than detach/attach:

(1) You cannot always detach the database. This may occur if, for instance, the database participates in replication.

(2)...