Welcome to the new and improved security in Windows Server 2008 and SQL Server 2008. When you installed the system, there was a barely noticeable check box to use...

On the new system - did you just install reporting services, or do you have a new instance with new databases?

If you just installed reporting services, then you are going...

For a single row insert, this is how I would approach it:

First, start a transaction...

Update the rows associated with the key - changing the position:

UPDATE table

SET pos = pos +...

A CTE is just a part of a normal DML statement. It can be included with any SELECT, INSERT, UPDATE or DELETE statement.

You are going to have to show...

koolme_85 (5/17/2011)

---

sorry for being opaque ...actually they want the work done using the data conversion transformation , so basically i have to use the flate file source and then use...

The coalesce and case statements are not equivelant. COALESCE will return the firt non-null value and your case statement is going to return the first code that does not...

colin.Leversuch-Roberts (5/17/2011)

---

note that you can't issue any writes and your mirror server must be licensed. ( normally failover/standy servers don't require sql licenses )

I will say I did some tests...

You could also look at replication as an option - again, it really depends on what you need to accomplish.

The only way I can think of to guarantee that format would be to create your query with a single column where you concatenate every column into the result.

SELECT quotename(column1,...

RLB (5/16/2011)

---

I would like to implement a similar solution but I don't understand what role snapshots play in this scenario? Is it not enough to just set up the...

You have not seen it before, because you did...

LM1 (5/11/2011)

---

You can use the following to convert the date column to the date with a time of midnight:

SELECT DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0) AS DateOnly

(Replace GETDATE() with the name...

I think it really is going to depend on what you are trying to accomplish. Is this requirement for reporting, and does it need to be real-time?

If it doesn't...

How have you determined that this is happening automatically? Do the SQL Server Logs show that SQL Server was shut down and then restarted? Is there any indication...

Also talk to your SAN guys - or your SAN vendor, if the LUN where the log file is located has been presented from a SAN and is not direct...