I just went to a session on Event Notifications by Jonathan Kehayias at SQLSaturday #32 in Tampa last Saturday where he showed how he did something similar so you should...

Something like this:

CREATE PROCEDURE sync_employee_table

AS

SET NOCOUNT ON

IF EXISTS (SELECT 1 FROM linkedserver.DATABASE.sys.tables WHERE NAME = 'Employee')

BEGIN

UPDATE L

...

Is it possible that you have 2 instances of SQL Server installed? One may be patched and the other may not.

The other thing to keep in mind is that you will need licenses for all the servers you are planning to install on.

SSRS does not support custom CSS. See here. I think I read somewhere that you can hack the stylesheet for your report server instance to make things look...

Sounds like you just need to use the PARTITION BY clause on the ROW_NUMBER() function.

Something like:

ROW_NUMBER() OVER (PARTITION BY sName ORDER BY dtAsOf)

PARTITION BY basically restarts the numbering whenever the...

Lynn,

Yeah, I also did one with a CTE that used MAX(fx_date) instead of the Row_Number function, but, on the limited 2 rows of data the windowing function solution produced a...

Ray K (1/26/2010)

Lynn Pettis (1/26/2010)

Alvin Ramard (1/26/2010)

Alvin Ramard (1/26/2010)

Edit: Oops, I missed...

Here's a solution, but I probably wouldn't use it against a large table without some kind of date filter:

CREATE TABLE Trade (trade_date DATETIME);

CREATE TABLE fx

(

...

What happens if you put fully qualify the table (schema.tblTest)? You really should fully qualify objects regardless, but I'm guessing that somehow this is your issue.

The only reason I can see that this might send 2 emails is if you have multiple email addresses in the contacts.email column.

There is one issue with this trigger though,...

Can you run Profiler when you execute the asp page and post the results? Just add the Error And Warnings: User Error Message to the Standard Template and you...

RedGate now offers a tool for object level recovery SQL Object Level Recovery Native that will recover an object from a native sql server backup.

So RoomCode was incorrect, but Floor was correct? Are you sure everything else is the same in each row and that the sort order is just different? Are...

Sounds like the component did not get registered in the GAC. I wrote a blog post about how to install the assembly here.