If the data is so valuable that no one should be able to browse it, it should be encrypted.

If you don't want DBA's to be able to select data from...

Coming from Australia, where we like to represent dates as DD/MM/YYYY, SQL Server often gives date errors. Valid dates like 28-01-2005 cause SQL Server to spit. Remember that your User...

It appears that in SQL 2005, not all internal sprocs are editable. Look in the  master.sys.syscomments table and you'll see code for only some of the sprocs.

Most likely Microsoft has...

I've  been building using Visio for the last few weeks. It has a couple of nice features over SQL Diagram, but not many. Be aware with Visio though, you have...

Could you not script out the permissions from the databases, and just do find-and-replace changing olddomain\ to newdomain\ ?

Ideally, if you are using local machine groups, which have domain members...

The time out value you want to set is on your ADO connection / command object. You can set it as a property of the connection or command object as:

Change your sproc to not use the view... use the query :

SELECT     AD.Type_Of_Address, MBD.Tel_Nbr as BTN,

                       isnull(AD.Street_Address1, '') + ' ' + isnull(AD.Street_Address2, '') +

   ' ' + isnull(AD.Street_Address3, '')...

you could build a dynamic SQL statement, and execute it with sp_executesql... however, this isn't very safe, as a user could input some sql commands and do something else to...

You would need to custom code the (default) HTML output to either display the results in a different frame, or a scrolling table. But I don't think reporting services can...

Hi Arvind

Load up Query Analyser and turn on "display estimated execution Plan" under the query window. You should then get to see what the execution engine is thinking of doing....

Thanks for posting back the connection string, Vijay. I'm glad to hear its possible.

Yes, database design is key to your success, regardless of what level of design you go with.

If your database has evolved from a 10 year old DOS database, It's...

Good point there.

I 'step' the identity across multiple servers, so if I have 5 servers in the replication, I set the first server to IDENTITY(1,5) the second to IDENTITY(2,5) and...

I've experienced the same problem in the past. The quickest way to get yourself setup is to create a ReseeIdentities sproc with code like:

DECLARE @currentMax int
select @CurrentMax = max(identityCol) +1...

Think of where you might be a few years from now. While your largest client now has a database of 30GB is it hard to imagine a customer coming along...