Thanks for the article, Jimmy. One thing you might want to consider is that if you have large data files with small amounts of data in them, backup and...

Yes, and then revoke access for all the users on all objects except the procs and views, so that the users don't continue to run the old queries.

John

Start with a query something like this:

SELECT

TABLE_SCHEMA + '.' + TABLE_NAME AS [Table]

, COLUMN_NAME AS [Column]

, DATA_TYPE + COALESCE('('+CAST(CHARACTER_MAXIMUM_LENGTH AS varchar(4))+')','') AS [Data Type]

FROM

INFORMATION_SCHEMA.COLUMNS

ORDER BY

...

Interesting behaviour. If you change the last SET line to SET @msg = @msg+@msg+@msg then you get 111111 (at least you do with SQL Server 2005 SP3). Strange...

(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.