You'll have to drop the constraint also. To figure out what the constraint is, I usually script out the table. The constraint could also be the statistics.

Alter table...

You can't have to servers (windows) with the same names, so hence unless your using named instances of Sql,(2 part name) you can not have 2 Sql servers with the...

It thinks that the numbers are int's to start with. Try to do:

select cast((30.0/364.0) as dec(20,20))

That will return the value.

Tom Goltl

How is the Server licensed??

Tom Goltl

Another thing with the application log. You can set the max log file size and overwrite option, by right clicking on the appropriate log and setting those options. ...

You can issue a couple different commands to make sure you are getting correct information.

dbcc updateusage

or

sp_spaceused 'table_name','true'

the true in the second command indicates you want to update usage.

Hope...

Could you be truncating some of the data from @MyAttachment???

Also try to verify that sql has access to the file by executing:

master..xp_getfiledetails 'Your file path here'

Just to check that your...

I'm not sure I understand your question completely but here goes.

You can place a generic stored procedure in the master database with an 'sp' prefix and you can...

Here is a stored procedure that I have. It tells me the current connections in a database. You can either give it the name of the database you...

You could turn this into a dts package. That would simplify the administration of the stored procedure. And to boot, I'm pretty sure you can export the results...

I agree with Steve. Put a batch size on this. Also for this load I would make sure the table does not have a PK or any indexes...

In the first query the plan is doing a clustered index seek (as per the index hint). Very optimal. The second query is doing a table scan. ...

Thanks for the information. Although to late to use in my case.

Tom

I tried this and it worked for some of my users and not others. I discovered the problem to be that 2000 supports 7.0 encryption but some of my...

You might try shutting down the sql agent. I thnik that is the service that the maintenance plans run under.

Just a thought.

Tom