Viewing 15 posts - 23,071 through 23,085 (of 39,917 total)
Yes and no. You can call and they will try to help you with SQL 2000. however no QFEs or hotfixes will be built if you have a bug or...
July 23, 2009 at 9:14 pm
I'm with Jeff if you can make this happen. The other thing that happens is a web server, or client browser, can cache images, resulting in better performance. That's if...
July 23, 2009 at 9:11 pm
I recommend detach/attach if you've never done this. You could easily mess up your integrity and miss some data to move if you aren't paying attention with backup/restore.
July 23, 2009 at 3:22 pm
I'll second the Elric series. My son also loved the Artemis Fowl and Pendragon series. More sci-fi, but at 10 he thought they were excellent.
July 23, 2009 at 1:39 pm
skjoldtc (7/23/2009)
I'll let somebody else make a joke about the "shiny bits". 😀
I didn't get a good quote here about shiny bits. I kind of forced it. I'd welcome suggestions...
July 23, 2009 at 9:56 am
Thanks and one minor note. Someone pinged me about me using freedom, as in liberty, when saying that it can be a problem. My use was intended to be freedom...
July 23, 2009 at 9:56 am
Are you talking filegroups?
The objects are all in one location, in the filegroup on disk. Not sure it matters other than trivia. AFAIK, an object cannot cross filegroups, so an...
July 23, 2009 at 9:54 am
you are welcome, and one thing I'd do is document what you do as you go along, and then save copies for yourself (and put it on a blog).
I've carried...
July 23, 2009 at 9:44 am
I work for Red Gate, so I'll mention Response. I wasn't thrilled early on with the way it worked, but I think that's because I was looking for something else....
July 23, 2009 at 9:33 am
Interesting thread, and some good info.
Here's the weird one. What if you have a 32bit VM on a 64bit host. do you want to know the host platform? I'm...
July 23, 2009 at 9:28 am
I don't remember this being a concern for me ever. Other than looking annoying in reports, or being unable to remove the user if they owner a database, but I...
July 23, 2009 at 9:25 am
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
Viewing 15 posts - 23,071 through 23,085 (of 39,917 total)