Viewing 15 posts - 9,931 through 9,945 (of 11,678 total)
I would run a SQL Server Agent job every 15 minutes. This job will execute a stored procedure.
The stored procedure runs the openquery and checks the result. If it is...
March 4, 2011 at 1:39 am
Premium SEE (3/3/2011)
Hi DearVisit this link
i am sure it would be very helpful for you
http://www.selfexamengine.com/microsoft-70-448.htm
Good Luck
There are practice questions in the self-paced training kit book, which costs...
March 4, 2011 at 12:37 am
akhil 46199 (3/3/2011)
A column which has datatype int, big int, tiny int or small int can only be set as an Auto Increment field.
Quoting BOL directly:
The IDENTITY property can be...
March 4, 2011 at 12:34 am
The condition split and the unpivot seem like a good solution to get rid of the other columns.
The unpivot is a semi-blocking transformation, but you shouldn't worry about it too...
March 3, 2011 at 11:50 pm
Dammit, I got it wrong because of this misleading quote in Wikipedia:
RAID 1+0: mirrored sets in a striped set (minimum two disks but more commonly four disks to take advantage...
March 3, 2011 at 11:46 pm
Another sad case of copyright infringement (or plagiarism, I can't tell them apart):
http://www.sqlservercentral.com/Forums/Topic1072353-2912-1.aspx#bm1072920
March 3, 2011 at 11:39 pm
You can copy paste, but as Brandie said, watch out for "hidden" things like expressions and variables.
You are most likely to reconfigure all the connection managers, as SSIS keeps an...
March 3, 2011 at 11:34 pm
With the built-in utilities from SQL Server Standard edition, you're stuck with the triggers as you said before, since change_tracking doesn't take all updates into account.
CDC does...
If you can modify...
March 3, 2011 at 11:30 pm
MauroPichiliani (3/3/2011)
It's very sad that nowadays you can see a complete copy of your work without authorization and even a simple reference.
You shouldn't put up with this. Contact the guy,...
March 3, 2011 at 11:22 pm
Allright, other option, download the OLE DB Oracle adaptor from Microsoft (search MSDN for attunity) and directly connect to Oracle.
Or is that not allowed?
March 3, 2011 at 12:41 pm
GSquared (3/3/2011)
... but we're still in 2005, and in Standard Edition at that.
Ouch... 🙂
March 3, 2011 at 12:38 pm
Again, what do you mean with dynamic reports?
Drill down/up, drill through, active filtering (such as in Project Crescent), ... ?
Your question is quite general, so it is not easy to...
March 3, 2011 at 12:34 pm
Sorry, but I can't guide, for several reasons:
* I'm not that well versed in high availability, and I don't feel like explaining something that I don't understand fully myself
* high...
March 3, 2011 at 12:30 pm
Are you sure the connectionstrings from the configuration files are used? Check the logging (enable it if you have to) and see if there are any warnings or errors regarding...
March 3, 2011 at 12:25 pm
At the moment, I can only think of 8 parallel Execute Package Tasks who all call the child packages, so yeah, not so neat 😀
You could also call 8 different...
March 3, 2011 at 12:22 pm
Viewing 15 posts - 9,931 through 9,945 (of 11,678 total)