Viewing 15 posts - 23,101 through 23,115 (of 39,936 total)
Is this production?
As mentioned if you want SSIS, it will be only one version. A couple other services are not instance aware.
Otherwise, same issues as any other multi instance box....
July 23, 2009 at 9:24 am
One small addition. I'd make sure they all use their Windows account, not SA, to make changes. It will help them to be respectful towards each other, and provide a...
July 23, 2009 at 9:22 am
In 2000, if you use the built in mail, you have to use Outlook, or a MAPI complaint system. You can get some SMTP senders, like XPSMTP (http://www.sqldev.net/xp/xpsmtp.htm), but that's...
July 23, 2009 at 9:19 am
This isn't stored in the system tables, AFAIK. There are likely ways to read the IAM, SGAM, pages and relate this back to an object, but I'm not sure. The...
July 23, 2009 at 9:16 am
the error you posted seemed to indicate appends. Definitely check that.
There are some good scripts here on the site for backups that can help if you want to look at...
July 23, 2009 at 9:09 am
Is that the bent, Natural shape keyboard with the two halves separated? I tried those, but since I use my left index for "y", it didn't work for me.
I have...
July 23, 2009 at 9:08 am
there are places for improvement, and the code in the article was updated in an earlier comment. I have updated the article to reflect that.
I think SELECT is a good...
July 23, 2009 at 9:01 am
Are you appending backups to an existing file?
Don't do that. It increases your risk dramatically. If there is a file issue, and there could be as it grows, then you...
July 23, 2009 at 8:21 am
Can you post a link for that?
July 22, 2009 at 1:17 pm
You could kind of get around this with a snapshot and then bcp out data/script schema, but I'm not sure that's what you want.
The standby is the backup, just...
July 22, 2009 at 1:15 pm
You might want to explain a little more what you want as well as the DDL and samples. Show the output samples as well.
If you need a number of days,...
July 22, 2009 at 1:13 pm
a few links: http://msdn.microsoft.com/en-us/library/ms181149.aspx
Log shipping tables in here: http://msdn.microsoft.com/en-us/library/aa260604(SQL.80).aspx
July 22, 2009 at 1:12 pm
Slip in the answer reasoning. Must be according to the reference.
July 22, 2009 at 1:06 pm
sorry to hear about your issues, and glad it's working. It is frustrating and I was cursing Toshiba when mine died, but it was frustration and I know it wasn't...
July 22, 2009 at 1:03 pm
bob, I'd still prefer you ask them to try and solve it, or post some work. However that's not a bad way to ask for them to clean up their...
July 22, 2009 at 10:09 am
Viewing 15 posts - 23,101 through 23,115 (of 39,936 total)