Viewing 15 posts - 6,061 through 6,075 (of 18,926 total)
It means you merge multiple servers into a single one. That way you don't have to pay extra licenses and all the costs to maintain the extra servers.
May 16, 2011 at 10:54 am
Brandie Tarvin (5/16/2011)
I've done that before. Changed my code to post on the forums and,...
May 16, 2011 at 10:50 am
If you erased the prod db with the wrong backup and you don't have a vaild backup you don't have any option other than reentering the data manually from other...
May 16, 2011 at 10:47 am
If you don't have a valid backup of the production DB you're basically screwed.
Time to search for any sort of backups that run on that server and hope they have...
May 16, 2011 at 10:32 am
So do you need help figuring out the logic to pick out the "correct" tuesdays?
May 16, 2011 at 10:30 am
Ya I just misread your solution. Sorry for the confusion.
May 16, 2011 at 10:28 am
mazzz (5/16/2011)
I'd set a separate job to run every Tuesday, use T-SQL to figure out if this Tuesday fulfills the criterion, and then execute the other job or not, accordingly.
So...
May 16, 2011 at 10:20 am
Schedule for every tuesday.
step 1 validate that this is the correct tuesday.
If it's correct update a column somewhere. Then in step 2 1st check that column value...
May 16, 2011 at 10:16 am
JOB, STEP, VB script
DTS and SSIS should be able to handle that as well.
May 16, 2011 at 10:14 am
GilaMonster (5/16/2011)
Ninja's_RGR'us (5/16/2011)
GilaMonster (5/16/2011)
rowversion = timestamp, just different names for the same data type. Timestamp is deprecated, but SSMS still uses it (go figure)
Does MS know about this too??? ...
May 16, 2011 at 10:03 am
simflex-897410 (5/16/2011)
it's quite interesting as to what sometimes seems quite simple often isn't.The GrumpyOldDBA, you are soo right, LOL
As a side question. Why do you want that column...
May 16, 2011 at 9:38 am
GilaMonster (5/16/2011)
rowversion = timestamp, just different names for the same data type. Timestamp is deprecated, but SSMS still uses it (go figure)
Does MS know about this too??? Is there...
May 16, 2011 at 9:35 am
simflex-897410 (5/16/2011)
If I try this:
INSERT INTO maintenance(maintid, maintName) values(1, '12345')
It doesn't insert - the constraint violation error is raised.
The INSERT statement conflicted with...
May 16, 2011 at 9:33 am
colin.Leversuch-Roberts (5/16/2011)
it's quite interesting as to what sometimes seems quite simple often isn't.
Yup... and I'm blanking out now... only remember the only digits functions and yet I'm feeling it can't...
May 16, 2011 at 9:20 am
colin.Leversuch-Roberts (5/16/2011)
ah .. but have you tried to use rowversion?
:w00t::hehe::-D
May 16, 2011 at 9:18 am
Viewing 15 posts - 6,061 through 6,075 (of 18,926 total)