Try to figure out the Order of the tables vs constraints.

Drop the constraints

Change the Datatype and re-create the constraints.

Or Next Option will be using

ALTER TABLE

ALTER COLUMN [column_name] [new_data_type]

ok, this is one the approach. I had come across this myself.

Check to see if there are hypothetical indexes in Sql server. if there are Many hypothetical indexes, try deleting...

Yes they are Partitioned Views then you need to supply all values required in table.

Something like this:

INSERT INTO vwDEMO

VALUES

(

''Mani1,

...

Which service pack are you on with SQL Server 2005. and windows 2003

There is a OS terminal services Bug, that can cause this issue, have you checked that

Check this Link: http://www.sqlservercentral.com/articles/Administration/clusteringreportingservices/2398/

That error number pretains to something about transaction Log Error.

Run a dbcc checkdb(dbname)

Restore filelistonly from disk = 'Backup Location and name'

Get the Logical Names...

Then execute the Following

RESTORE DATABASE DATABASENAME from disk = 'Backup Location and Name'

WITH REPLACE,

MOVE 'Logical Data File...

did you try changing the cmptlevel to 90 and then do a backup and restore.. is it the same?

You got me here.. you are right...

so BOl is the right place...

yes you can.

Just do a : sp_msforeachdb @command1='USE [?] EXEC sp_change_users_login ''report'' '

to check for all orphaned logins on these boxes.

it is the SQL Login that gets Orphaned when you...

Try this:

Update PatientTable

Set Notes = NOTES + ' This is a new TEXT Message'

Where PatientId =

(Select PatientID From PatientVisitTable

Where TicketNumber = 9)

Check which protocol the ODBC connection uses.. in their DSN.

Double click on their DSN and goto the screen that has the "Client Configuration" button/link click on it to see what...

sp_msforeachdb @command1='USE ? DELETE from sysusers where name ='' '' '

something like this.. Or use Cursor to scroll through each DBNAMe and Delete the user in the Database...(each DB).

Declare...

What is the Authentication Method (SQL or BOTH(SQL/NT)

Also Enable both Named Pipes and TCPIP on the Server.

When you open SQL Server Management Studio.

It Open a Dialogbox to "connect to Server"...

How many Filegroups and how many file in each Filegroup you have for this DB.