Be very sure that you are in the correct database when you run this.

DECLARE @sObjectName NVARCHAR(128)

--Loop through all table objects.

SET@sObjectName = ''

WHILE@sObjectName IS NOT NULL

BEGIN

SELECT@sObjectName = MIN ( Name )

FROMSysObjects

WHEREType='U'...

Does your stored procedure depend on a view?

If the structure of the underlying tables for a view alter then the view can get confused as to which columns to retrieve....

SQL seems to handle it without any problems

Try select CAST(0xF43C2 AS INT)

Firstly, we always call stored procedures from our ColdFusion Apps

If in any doubt at all we pass the dates into the procs as varchars but in a known format. ...

When you say modified I presume that you mean structure rather than data? That is a column has been added/deleted from a table rather than a new record added?

There...

What is the login account for the service?

Is it the same as the MSSQLSERVER login account?

If not:

Does it have logon as service rights?

Does it have suitable permissions to run the...

I have not come across this one before but I would guess that the confusion is caused by the source and target machines being set to different locales

British Date DMY

American...

MSDE is a cut down version of SQL Server without any front end tools. Maximum database size is 2GB and max ram is 2GB.

If you are talking about small,...

If you use EM you can cause locking problems if other users are connected.

Unless you are talking millions of records I find that if I need manual updates I export...

Don't forget you need suitable permissions on the SQL2000 box to do this.

You may have read/write access to tables but DDL statements such as CREATE, ALTER and DROP may not...

I'm not suggesting we should be just database geeks or stand Canute like before the .NET tide.

I'm facing a situation where I have inheritted a mission critical system that was...

C:\WINNT\system32\os2 ?????????

Look in the C:\WINNT\system32\os2\DLL folder and see a DLL called doscalls.dll

Write out a million times "I must not be cynical".

You know morale is low when the company does a...

CREATE TABLE dbo.Product (

ID Int Identity (1,1) NOT NULL,

ProductName VARCHAR(50) NOT NULL ,

...etc

)

The parameters of identity are the start value of the sequence and the increment.

You can...

The great thing about an X-box is that you can chip it, upgrade the hard disk and get a fairly decent linux install on it for £99!

I think the hand...

Absolutely not.

SQL 6.5 is a totally different architecture to SQL 7 and onwards.

SQL 6.5 is nearer to SyBase on UNIX than it is to SQL 7 on Windows.

You can connect...