Viewing 15 posts - 11,416 through 11,430 (of 39,963 total)
In terms of testing, building some setup harnesses for FK data shouldn't be too hard. It's also reuseable work, so that doesn't seem to be a valid argument for anything...
February 26, 2014 at 11:01 am
USE msdb
GO
SELECT * FROM dbo.sysssispackages
That's where they are. To run them, or edit them, you'll need BIDS/SSDT
February 26, 2014 at 10:58 am
There is stronger encryption, but you can implement better algorithms using the CLR, so that might not be a reason.
Overall, I'm not sure there are compelling reasons outside of Audit,...
February 26, 2014 at 10:55 am
February 24, 2014 at 10:23 am
You can search for some scripts here, but you'd need a separate trigger for each table. The fields copied over would vary, so your trigger scripts need to account for...
February 24, 2014 at 10:23 am
If I have
LookupID LookupValue
====== =========
1 Red
2 ...
February 24, 2014 at 10:00 am
tmlink99 (2/23/2014)
February 24, 2014 at 9:45 am
rodjkidd (2/24/2014)
It was being hosted by one of my musical heroes - Fish, he...
February 24, 2014 at 9:22 am
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...
February 24, 2014 at 9:12 am
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...
February 24, 2014 at 9:11 am
yw, glad it's working.
February 21, 2014 at 11:11 am
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...
February 21, 2014 at 9:04 am
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...
February 21, 2014 at 9:02 am
Did you sqlservr.exe get moved? There should be something in error logs or the Event logs that an attempt was even made.
February 21, 2014 at 8:59 am
Viewing 15 posts - 11,416 through 11,430 (of 39,963 total)