My reflex was to post this same link which is my favorite resource to pass along on these types of posts!

All users have permissions to create local temporary (i.e. temp) tables by default. There are no issues with creating a single new temp table in and of itself. However, populating...

Have you tried EXEC() AT?

EXEC('EXEC msdb.dbo.sp_start_job ''My_Job_Name''') AT [ServerName];

I have not seen deadlock events in the system_health session that I thought should have been there. The session is setup to 'allow single event loss' so it's possible that...

Both instances cannot be the default instance. It sounds like your 2000 instance was already running on port 1433 so you need to figure the port for the Express instance....

Deadlocks can occur for many reasons. Without further information it will be impossible to assist you.

What you need is the deadlock graph so it can be analyzed. Enable global Trace...

gantavasu (12/20/2012)

---

Hi All,

Here I am new to the Replication.

So i want to know what is the push and pull subscriptions and how it will work.

When it will use.

Also please suggest...

leaf_update_count and leaf_insert_count appear to track logical update and insert operations correctly on a clustered index but not how I would expect for a nonclustered index.

SELECT SOUNDEX('Costco'),

SOUNDEX('COSTCO'),

SOUNDEX('Costco Whls'),

SOUNDEX('Costco Wholesale'),

...

Which version of SQL Server are you using?

SQLSACT (12/21/2012)

---

I think I figured out why this happens though - Looking at the transaction log using fn_dblog, I see LOP_MODIFY_ROW operations on the clustered index, LOP_DELETE_ROWS on the nonclustered...

You have a data type error occurring in the database when you run your query. What does your expression evaluate to at runtime? If you can capture that you can...

I am not sure if it will install since you have SNAC 11 but you can find it on the SQL 2008 or SQL 2008 R2 media. There is a...

@SQLSACT please answer WolfgangE re: whether the table accepts updates. Also, does the table accept deletes? You could be seeing a spreading out of the index on disk due to...

No, not using SNAC 11.

http://www.sqlservercentral.com/Forums/Topic1317581-2799-1.aspx

You could try using SNAC 10 but may run into problems with DTC. See workarounds:

http://connect.microsoft.com/SQLServer/feedback/details/731869/using-sqlncli10-to-create-a-linked-server-to-sql-server-2000-causes-a-fault#