Viewing 15 posts - 1,396 through 1,410 (of 6,216 total)
Do you have text cols? Thought they got excluded from the check, would have to check!
Andy
November 3, 2003 at 5:45 am
Can pass whatever you want into sp_executesql.
Stats you can manage with a job, whether you run your own or use the maint plan. Same for blocking - you'll almost always...
November 1, 2003 at 8:37 am
If all you need is a simple PDF, we had a recent article that showed how to build PDF directly from a stored proc. Not fancy, but sometimes good enough!
Andy
November 1, 2003 at 8:34 am
Havent. We bought an ocx (http://www.epsilon-logic.net/default.asp) that is ok, downside is that as far as I can tell you have to let it write the query to disk and then...
November 1, 2003 at 8:32 am
I dont think (but have not confirmed) that doing a restore changes the dbid. The error looks more like recovery hasnt completed - are you sure the db is online...
November 1, 2003 at 8:19 am
It shrank because there was free space. Typically is and its a good thing, the maintenance wizard defaults to 10% I think. If you don't have free space in the...
November 1, 2003 at 8:16 am
Thought so, its common forum functionality. Forums - love the content, hate the code!
Andy
October 31, 2003 at 2:34 pm
Thats correct. Its the downside of log shipping. If you want to query it (for reporting most commonly), look at using replication instead.
Andy
October 31, 2003 at 2:31 pm
Just stop the agents (or the job, same thing). For transaction you need to stop the distribution agent, the log reader can continue to run, just remember that distribution will...
October 31, 2003 at 2:29 pm
Define the relationships in the db that holds the tables. When you use the views (which is a good solution) the underlying tables enforce the relationships, constraints, etc.
Andy
October 31, 2003 at 2:27 pm
I agree about the cleanup - coding explicit behavior is a good practice to follow.
Andy
October 31, 2003 at 2:24 pm
XP_cmdshell should work. I typically use the solution Jeremy suggests.
Andy
October 31, 2003 at 2:20 pm
Do you get the same results every time? Not much you can do wrong with the method call. Using the SQL2K version of DMO using the '2' objects?
Andy
October 31, 2003 at 2:16 pm
I'll add my vote for it being a bad idea. Whether you need to do it depends on whether you just need access to the data or if you're using...
October 31, 2003 at 2:13 pm
Tried backing up to disk? Does a backup of some junk file work ok? Definitely get some kind of backup done, even if you have to stop the service (keeping...
October 31, 2003 at 2:12 pm
Viewing 15 posts - 1,396 through 1,410 (of 6,216 total)