Viewing 15 posts - 1 through 15 (of 31 total)
Paul that is so sexy! 😀
NICE WORK and thanks..... I totally didn't think to go the SQLCLR route!
you daman!
February 14, 2013 at 7:13 am
Hi Brandie
1st thanks for reading 🙂
2nd I "simplified" the Schedule table down to 3 columns for the sake of trying not to confuse the goals (mission failed apparently hehehe)
the actual...
February 12, 2013 at 9:34 am
yeah i have cursor code with the column (time remaining), etc just as you suggested and I'm just not a fan of it or it's peformance.
It's an interesting use-case and...
February 12, 2013 at 9:19 am
Thanks Markus but I was able to get an answer from Microsoft on this:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=387050
If the following option is set when you run sp_cdc_enable_db for a database
...
December 15, 2008 at 1:23 pm
So I totally reinstalled SQL 2008 on a new VM
connected to it via SSMS remotely
enabled CDC and got the same problem :w00t: what the f*ck? LOL
BUT when I log...
December 12, 2008 at 11:24 am
Thanks for the test.
I'm starting to think it's something to do with CU2. I'm in the process of building a VM and I'm going to put SQL 2008 RTM...
December 3, 2008 at 7:37 am
bang725 (11/17/2008)
give read-only access to msdb of sql 2000 and then tell user to connect using ssms 2005
hehehe that was my first thought too... but no dice.
TargetServersRole is the answer.
Thanks...
November 17, 2008 at 9:47 am
TargetServersRole in msdb
Interesting choice of name hehehe This seems to of worked (Thanks RK). Developers can now see the jobs but can't add/update/delete.
Thanks
November 17, 2008 at 9:46 am
if you recovery methods only include a nightly full backup then unless the database is being used for log shipping, mirroring, etc I don't see a reason why you couldn't/shouldn't...
October 31, 2008 at 1:32 pm
If you're looking for a "quick fix" look then below is a link to a site that compared 12 different tools for doing this type of comparison.
http://www.sqlserverdirectory.com/sqlserver_product_reviews_SQL_Schema_Compare.htm
Most if not all...
October 27, 2008 at 9:30 am
I think this might be what you're looking for.
(It says it's for SQL 2000 but the same applies for 2005)
http://support.microsoft.com/kb/321247
Security Configuration On Secondary Server For Standby Databases
If you configure the...
October 27, 2008 at 7:37 am
Thanks for the ping back!! 🙂
2. should pretty up the code on HTML
http://extras.sqlservercentral.com/prettifier/prettifier.aspx%5B/quote%5D
Gold Star on that one 😀 I've been looking everywhere for something like that.
Every other comment/suggestion...
October 24, 2008 at 2:32 pm
I believe by default you cannot get this information but in the future I think you can use Trace Flags 3502 which logs a message to the SQL Error log...
October 24, 2008 at 11:59 am
Viewing 15 posts - 1 through 15 (of 31 total)