Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I stumbled across a really scary bit of...

1. Yes. Use sp_addlinkedserver or SSMS wizard (server objects, linked...

Did you register the linked server?

This should do:

Select *

Into #TempA

From TB_ARTICLE

Where ARTICLE_ID not in (Select ARTICLE_ID from remote_server_name.database_name.schema_name.TB_ARTICLE)

EXEC('USE database_name; set identity_insert TB_ARTICLE on') AT remote_server_name

Insert into remote_server_name.database_name.schema_name.TB_ARTICLE

Select * From #TempA

Hope this helps

Gianluca

Looks like a good place for replication.

Have you checked that option?

In SQL Server 2008 you can use the HierarchyId datatype to store tree structures.

AFAIK, MLM is illegal in many countries (including Italy).

Be careful what you do.

Brandie Tarvin (7/25/2011)

---

mtillman-921105 (7/25/2011)

---

Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic...

You're right.

I'll stop it here. Would have lots to say, but I'll stop it here. 😉

Ninja's_RGR'us (7/25/2011)

---

Gianluca Sartori (7/25/2011)

---

... unless you're working with Oracle. :Whistling:

It's called "cold backup" and it's advertised as "the...

GSquared (7/25/2011)

---

GilaMonster (7/25/2011)

---

I just had a fun one. Told someone that they shouldn't run Backup log with truncate only as it breaks the log chain. So they reference an article...

... unless you're working with Oracle. :Whistling:

It's called "cold backup" and it's advertised as "the only consistant backup"....

I don't think so, unless you're really using SQL Server 2000 (is this the right forum?).

Take a look at these articles and see if they help:

Displaying Sorted Hierarchies[/url]

Hierarchies in SQL[/url]

Hope...

Nice, thank you.

You could add it to the scripts section, using the contribution center.

Probably the user that connects to the database is requested to write an object (auditing table) that is outside of his permissions, due to the trigger execution. You could wrap...

I suspect this is not the right forum: logon triggers are not available in SQL Server 7 or 2000.

However, what is failing in your logon trigger?