Jeff Moden (12/29/2008)

---

Just so you know... storing dates in a database like that is a form of "Death by SQL"... it will bite you sometime in the future.

The only reason...

just to add-on to my thoughts....

I'd prefer the topic section to contain all topics; which should be grayed when an improper version is selected.

say a user has selected the...

Well that's the costliest mistake a DBA can make. I dont think...

Yes you can install more than one instance of SQL Server on a system.. Check maximum capacity specification on the limit of instances BOL... I guess its 50..

To access u...

If the database is important, why you dont have a backup policy in place?

Without a full backup + log backup chains i dont think you can restore to point in...

Hmmm.. there was a silly copy/paste error in the following line :w00t:..

set @a=convert(varchar, getdate(), 112) as int -- Implicit conversion to INT...

You need to remove the part mentioned in bold...

Do you want this?

--===========================

declare @a varchar(100)

set @a='myproc' -- This SP doesnt accept any parameter, myproc is an SP

exec @a

--========================

--===========================

declare @a varchar(100)

declare @param1 varchar(100)

set @a='myproc' -- This SP accepts a parameter

set...

Hmmmm. I dont know if this will be of any use. but what i feel is the structure be divided into two parts. a) Version b) Section.

A combo drop down...

What I understand from...

its coz of the where condition..

I tried something and i got desired result...

=================================

create table tab1

(

id...

I dont think u'd lose any data.

refer BOL on checkpoints: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/ccdfc689-ad4e-44c0-83f7-0f2cfcfb6406.htm

It says shutting down a database causes a checkpoint which means all the dirty pages would be written back...

by the time anyone even thinks of going in the right direction, the solution arrives at lightening speed!! Thats Jeff :hehe:

Next time i come up with a problem like that i'd rather use a checklist of all the points mentioned by Jeff and then try to strike a balance...

All major...

If the setup was completed successfully, Normally you enter the following in server name.

machineName\InstanceName

Check out the name of your pc and replace it with machineName and put SQLEXPRESS in place...

Also, the query that u're using to update plus index structures on your base table.