John,

sp_recompile 'table_name'

will recompile all objects (eg, stored procedures) that use a given table to be recompiled the next time they are run.

Also have a look at DBCC FREEPROCCACHE in BOL.

BTW,...

I think the first thing you need to do is decide the order of precedence.

For example, if you have a record in Table 1, Table 2 and Table 3 and...

Hi Smk,

--You need to firstly declare your variable

-- Also, assuming that @ApptId is an id field and not a datetime field I changed the datatype to int

DECLARE @ApptID int

-- Then you...

Al,

You cannot drop a user that owns an object.  You will need to change the object owner to another user, delete the first user, then change the owner again.

This is...

It sounds like you are describing orphaned users.  Have a look in BOL.  You do not need to restore the master database.

The article you provided a link to, also describes...

Hi Juan,

You can't achieve 'merging' of data on a central database with backups.  Have a look at Replication in BOL (SQL Server Books Online)

Cheers,

Angela

Hi HerbieChin,

In regard to your question

I am also having this problem on our new SQL box that is connected to a SAN.  Our CPU hits 100%, the system freezes, then we get the ConnectionCheckForData error....

Eric,

I agree with Frank.  I don't understand why you would need a trigger.

Create a Primary Key on your tables with a corresponding Foriegn Key in the other tables.  Have a...

Hi Lucky,

You are right.  Performance and storage will be improved if you have two tables.  Table 1 should contain all the mandatory fields, Table 2 should contain all of the...

Please don't double, or in this case triple post!!!

See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=112989

Hi Jeff,

Had a simalar situation here and looked at both combinations.  After reviewing the execution plans, it appears that although there is a clustered index on the PK, it would...

Please do not cross post !!!  Your question has been answered here: http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=112334

Hi John,

I agree with Kenneth.  I am not aware of any problems with changing the time in SQL Server since the operating system is controlling the clock.

To answer your first...

You can only remove the second file not the first one.

To remove the second file.  Backup the database, in Enterprise Manager right click the database, select all tasks, shrink database,...