Viewing 15 posts - 1,096 through 1,110 (of 6,216 total)
Hey, turns out I was further along than I thought. I've added a switch to the profile to allow you to turn off the fancy editor AND I think fixed...
February 26, 2004 at 6:35 pm
I know my friend Jon Winer (columnist) likes CodeSmith, havent had a chance to try it. Code generation is indeed worth doing in places. I use the VB6 stored procedure...
February 26, 2004 at 5:25 pm
I like SQL Data Compare from RedGate, think maybe ApexSQL has a tool that does it too (I know it compares schema, not sure about data). It scripts it over,...
February 26, 2004 at 5:22 pm
We have reviews up of both RedGate and Apex compare tools, plus one from AdeptSQL. Worth looking at. Havent tried the auditing tools.
February 26, 2004 at 5:20 pm
You can also just alias the user directly as dbo, take a look at sp_addalias.
February 26, 2004 at 5:16 pm
The forum software just supports global on/off of the fancy stuff, Im in the middle of making it configurable per user. Get a lot of people that like the stuff,...
February 26, 2004 at 5:13 pm
I like being able to configure stuff like that myself. We'll get there! Planning to add a switch that allows you to turn off the graphical editor here as well,...
February 20, 2004 at 8:04 pm
Did some quick testing, the text you supply in the alter must contain the existing name of the stored proc. This works (used .Net with option strict=false):
Dim
February 18, 2004 at 6:34 pm
Query Analyzer has a debugger, just fire some code that would activate the trigger, then step through it.
February 15, 2004 at 5:41 pm
I think what you're seeing is the auto refresh in Enterprise Manager that updates your replication status. If you right click there is an option not to auto refresh, see...
February 15, 2004 at 5:39 pm
I have not tried to replicate to Oracle, might be worth a post in the newsgroups to get some MS help. I know there is a least one 3rd party...
February 15, 2004 at 5:37 pm
If you've got connectivity then usually it comes down to permissions. You can enable logging using a couple switches on the distribution agent, that will usually pinpoint the problem.
February 15, 2004 at 5:36 pm
It's an ugly problem with no easy answer. In the NT world you have auditing and the concept of ownership - the domain/enterprise admin can be locked out of viewing...
February 15, 2004 at 5:34 pm
Not sure if it qualifies but something that I end up spending time on is deleting and/or archiving data out of various tables. I end up with a whole series...
February 15, 2004 at 5:29 pm
Viewing 15 posts - 1,096 through 1,110 (of 6,216 total)