It's not considered good practice to shrink a production database.

If the database has been shrunk and new data is added then it has to grow again, probably at an...

I found a bug in sp4.

The packages doesnt open in it even if we install the sql 2000 dts designer components.

Regards,

Sushant

nvarchar(max) i guess its used in sql 2005 also.

not sure thou

Regards,

Sushant

no.

Regards,

Sushant

I need just 1 table

bcp dbname.dbo.ccSales_test in "C:\CCSalesSep10_Feb11.CSV" -SERVERNAME -c -t, -T -F 1 -r -h "TABLOCK" -C RAW -a 10240

I get

bcp unknown option W

and then all bcp signs and symbols whcih...

I changed the excel file into a csv file and then ran bcp :-

I got

Starting copy....

0 rows copied.

The bcp statement i used is :-

bcp dbname.dbo.ccSales_test in "C:\CCSalesSep10_Feb11.csv" -c -T

Regards,

Sushant

It happened to me once in sql 2008.

I wanted to change the data type of the column from date to datetime.

When I did that in sql 2008, it failed and...

Did the OP got the answer ?

SQL 2005 Standard --> SQL 2005 Enterprise??

Can any1 plz tell me the steps for that upgrade.

Regards,

Sushant

@ pioulot

Agreed, its not weird but if i ran

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

inside the sql server management studio express

IT SHOULDN'T say

9.00.4035.00 SP3 Enterprise edition

Now,...

@ alex..

Yes its only dev server.

Some developers dont ask me before doing any things ...:(

Yes, when i see in hte control panel, add or remove programs,

I can see both...

Also, if i try to connect to the that server from my local machine (having sql server 2005 sp3 installed) , then it successfully connects to that server sql server...

I ran

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

inside the sql server management studio express and it says

9.00.4035.00 SP3 Enterprise edition

Regards,

Sushant

has people tried sp4 on production servers as yet??

you mean sp3 or sp4