EXEC sys.sp_bindefault @defname=N'[dbo].[def_UserID]',
@objname=N'[dbo].[tAA_MAD_Type4].[InsertedBy]' , @futureonly='futureonly'
GO

Thanks for your help with previous post, the queries given do work but I
actually need to restrict the records to a year from the closingdate, not a
year from current
date, does anyone know how to achieve this?.

What is the effect of removing the INSERT, UPDATE and DELETE access of
the public role in all user tables of a database?
Please help.
Thanks,

Hello, I'm very new with SQL. I wanted to find out if there was an easy way
to move (or even copy) a table from one database to another database (on the
same server). We are using SQL 2000.

I have a user table record in sysobjects but the table itself does not
exist. Has anyone come across this and how do I remove the entry from
sysobjects?
Cheers,

I want to add a column in a table and placed it in the first column, how to
write this sql statement?
(the alter table [tablename] add [columnName] ) only add the new column in
the last column.

Please, where I can see times when automatic file growth occurs?
I searched it in SQL-server Log and EventLog, but didn't found.

Any one not been able to install the Microsoft SQL Server 2000 DTS Designer
Components?  (SQLserver2005_DTS.msi) I can’t find the answer on the web, so
I’m turning to you guys.  I’m testing the upgrade to SQL 2005, and we have
about a dozen DTS packages.  None of them real ...

Hello, in SQL Server 2000 what is the difference between a backup file that
has the '.bak' extension versus one that doesn't like 'backup.bak' vs
'backup'?  And is it better practice or advantage to use one over the other?
Thanks in advace.

I have really weird issue. SQL server is in workgroup, my account in local
administrator's group on machine, default setup so I'm sysadmin as well. I
can register to server with MS just fine, I can not all operations just fine.
But when I try to delete Maintainance Plan (some of ...

I have this query where I can see the duplicate car_sightings because
they are grouped together.  However, what I want is the aggregate.
One record with the count of how many duplicate sightings for each
car, with the same mark, number and sighting date.      I tried one

Is there a way to enter more than one condition when you create a filter in
a Profiler Template? I want to enter a number of different application names
in a missing stats template but I cannot see any way to do this using the
GUI.

The outer query gives me the last sighting for a rail car.  Now I
have the very last sighting, however within the last sighting results
there will be multiple records with that clm_id(sighting)   with
that date but different sighting codes for different transactions

I am making a huge restore database with sql server 2000 and I need to know
how to find the percent of advance of the operation. I cannot find it

I have the following  cursor is running on my server and revoking
access for all users.
However, two of my databases are named: MY Mas and MY San. There is a
space in the name (don't ask - it was named before I got here).  We