Viewing 15 posts - 106 through 120 (of 137 total)
Oh, now I see. You must only be shipping your user defined database. You will have to ship the master database in order for the user names...
April 14, 2003 at 12:14 pm
I'm guessing you have this setup as a database maintenance plan? I'm guessing you log ship on a schedule. One possible solution would be to schedule a job...
April 14, 2003 at 12:01 pm
Thanks for the response pbirch. Did you take any of the classes or mainly self study? I'm supposed to take another class in a couple weeks, but I'm...
April 14, 2003 at 11:42 am
I would recommend maybe a product component table. This would be a 1 to many relationship that can tie additional components to a given product. This table could...
April 13, 2003 at 2:12 pm
I see the grouping as something that would benefit scripts or programs that access the result set. The grouping column in the example would allow you to format a...
April 12, 2003 at 11:46 am
That's strange. I don't have any other ideas. It just seems security related but not if it was created under db owner account. Did you try viewing...
April 12, 2003 at 11:25 am
I would contact the software vendor and tell them the list of stored procedures that are taking over 2 seconds. Unless these are massive procs they shouldn't be taking...
April 12, 2003 at 11:21 am
I got this to work by using a transform VB Script function. Click on the transform button in the DTS import wizard and use the following script. ...
April 12, 2003 at 11:14 am
Do you not get any rows or just the function field that is empty? Does the customer always have a note? You could try an outer join to...
April 12, 2003 at 11:08 am
Where the stored procedures created using dbo user? That's the only thing I can think of is that they were created under a user name that doesn't have access...
April 12, 2003 at 10:44 am
If you set your recovery mode to "Bulk-Logged Recovery" then select into statements as well as BCPs will be minimally logged compared to Full recovery. This would minimize your...
April 11, 2003 at 3:45 pm
Did you try using DTS by defining a source that is a cubed query?
Darren
April 11, 2003 at 2:57 pm
Is this VB app something you are developing? If so send me the code that displays this error. I've seen this error when it's trying to execute a...
April 11, 2003 at 2:47 pm
Go to Enterprise Manager and look at the Jobs currently scheduled. You must have a Maintenance Plan job that is running these backups. Is your SQLServerAgent service runing?...
April 11, 2003 at 2:44 pm
The other way to wait in VB is to loop using a timer. You should be able to find examples in help. You loop while a certain time...
April 11, 2003 at 6:35 am
Viewing 15 posts - 106 through 120 (of 137 total)