both work for me:

select cast (getdate() as smalldatetime)

select convert(smalldatetime,getdate())

select @@version

results:

-----------------------

2009-07-17 09:16:00

(1 row(s) affected)

-----------------------

2009-07-17 09:16:00

(1 row(s) affected)

------------------------------------------------

Microsoft SQL Server 2005 - 9.00.4207.00 (X64)

(1 row(s) affected)

... and yet another way to skin the cat ...

sp_MSforeachtable @command1="select count(*) as '?' from ?"

... granted not efficient, nor possibly accurate ...

No matter how large or small a software project is things can go well and on time.

Testing on a modular level can be quite elegant and efficient. Take Unix and...

hmmm ... get it right the first time - like NASA !

http://www.sqlservercentral.com/articles/Editorial/67315/

DBCC CHECKDB() --> this is executing in the default database which is probable master

That is why it is so quick. Whereas ...

DBCC CHECKDB(yous_database_name) --> is performing the DBCC on the...

Replication anybody ?

Unless you are using an custom written application you will need to change (convert) all comp-3 (packed decimal) and comp (binary) data types to 'display' data on the mainframe first....

We use a software package called ECM - Enterprise Change Management - we have 250+ SQL Servers - it handles non-clustered SQL Servers but has issues wioth clusters !

Thats why...

hope this will help & make sense up to the extent that the information applies:

4GB RAM: /3GB (AWE support is not used)

8GB RAM: /3GB /PAE

16GB RAM: /3GB...

Are you running 2000 Standard ot 2000 Enterprise ? If you are running SQL 2000 Standard then adding more memory to the server will not help since SQL 2000 Standard...

I have used many schemes for keyword usage in many programming languages over the last 27+ years. Maybe I am just getting lazy in my old age, all lower case...

You should be able to modify the password through the services msc beforehand. Do not restart any services until the password(s) have been changed via the services msc on all...

Very good question.

How does this behavior stack up against ACID though ?

hmmm ... I live kind of simply so I would like things to be special like my Sundays usually are dining-wise ...

breakfast - homemade biscuits and sausage gravy with think...

I agree with Jeff's first response ...

Been in that same situation and did almoist the exact same thing, just used a few more words ...

That manager was not long for...