Viewing 15 posts - 34,951 through 34,965 (of 39,723 total)
Booksonline has some basic information. The best place I've seen on the web is http://www.google.com/microsoft
April 29, 2004 at 11:41 am
Not that I'm aware of. AFAIK, a restore should put everything back as expected. If it was a different server default, perhaps it changed. An interesting thing to look at.
April 29, 2004 at 11:40 am
I don't think there is any way to change this. You could have them script changes and then run them through someone who does own the table.
April 29, 2004 at 11:39 am
You can do what I do. I have a script that checks the flat files as well as the jobs and generates an HTML file that is stored on the...
April 29, 2004 at 10:53 am
A few things to consider. Allocations are in extents, so you will always use space according in extent lengths. Similar for pages.
Indexes are separate (nonclustered) and have some small overhead,...
April 29, 2004 at 10:35 am
Haven't seen it, but have you tried the patch in the article? When you say you couldn't get MS support, what does that mean? did you call the PSS hotline?...
April 29, 2004 at 10:30 am
Have you tried using the "WITH MOVE" option to set the log file to a different name?
April 29, 2004 at 10:28 am
I'm sure there is, but I'm not sure what it is? What type of step is this and how many lines? If it's T-SQL, perhaps you should create a stored...
April 28, 2004 at 4:15 pm
It can be slightly flaky, especially if SQL is not running as a user account (as local system). Did you click and set a breakpoint and see the red dot?
April 27, 2004 at 11:32 am
Sorry, too busy to do much in the forums yesterday. ![]()
Glad you came up with the answer.
April 27, 2004 at 11:21 am
Have you recompiled anything? Perhaps reindex? Is this sp performance or query or both?
April 27, 2004 at 11:19 am
You can also get this from VBScript using the FileSystemObject.
April 27, 2004 at 11:14 am
Wow, that's a tough one. How many people will use this? Larger numbers of users should mean more calls. Of which, some more should be escalataed to the DBAs.
How stable...
April 26, 2004 at 11:04 am
There are any number of solutions. I do the backups with TSQL and the file deletions with VBScript in an ActiveX task. Both are contained in a DTS package which...
April 26, 2004 at 10:28 am
Viewing 15 posts - 34,951 through 34,965 (of 39,723 total)