If I have

LookupID LookupValue

====== =========

1 Red

2 ...

tmlink99 (2/23/2014)

---

This is why I suggested doing both. Seeing what the OP has found is the best for their situation doesn't preclude seeing what's voted as best by the...

rodjkidd (2/24/2014)

---

On Saturday I went to the Classic Rock Society awards. Fairly small run outfit, but well respected.

It was being hosted by one of my musical heroes - Fish, he...

I meant write code that looks for

count(lookup value) = count(*)

for a table. Also, look for items in your text fields like "<script language=js>"

We've seen both of these hacks here on...

I'm not sure what you mean? Do you mean mark articles with a version?

The articles that mention newer code specifically tend to note the version. If the version has been...

You are welcome.

good luck

yw, glad it's working.

try to bcp out the data from Alloy. If it doesn't work, try copying data out in ranges and see if you can get data before/after the corruption. Sometimes that...

One more suggestion: think about writing a script, perhaps in Powershell, that will take all files in a folder and build the proper recovery scripts. That way you can point...

Did you sqlservr.exe get moved? There should be something in error logs or the Event logs that an attempt was even made.

Sure, in a second step in job 1. Set to t-sql

if SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)) = getdate()

-- need some formatting conversion here.

exec sp_startjob jobid=2

stormsentinelcammy (2/21/2014)

---

You'd hope if you're working on instances that big that you'd be...

We had a bug that allowed anyone to mark a post on pages >2 as a solution. I think we've fixed that, but if anyone finds posts that should not...

There's no way answer what you are asking in a few sentences or a post. Latency will depend on the load you're moving across links and the bandwidth. You need...

You can look at replication from SQL Server. You can move data that way to Oracle. Search Books Online.

If you don't need it real time, or transaction by transaction, SSIS...