Viewing 15 posts - 8,221 through 8,235 (of 9,715 total)
I haven't done migration to 2008 yet. However, from what I understand, the engine hasn't changed very much and 2008 supposedly allows a direct upgrade from 2000.
Look into Microsoft's SQL...
October 23, 2009 at 7:27 am
Cool! Glad you figured it out. @=)
October 22, 2009 at 3:50 am
I run into the same problem with SSIS when I have a schema definition mismatch. I'd advise checking that first. Make sure to check not only structure but (if applicable)...
October 22, 2009 at 3:48 am
Thanks for posting your solution. That's a nice document.
So are you going to force the actual xml file to include the those entity references instead of the < and =...
October 21, 2009 at 8:12 am
I'm assuming "flat" means that the XML is all on one line with no pretty carriage returns between each data element. Sort of like:
<column1>2adfad</column1><column2>adfeoue</column2><column3>etouen</column3>
If that's not what the OP means...
October 21, 2009 at 6:50 am
Have you tried right-click to see if a menu with a script option pops up?
SSIS in 2005 supposedly allows for the migration of jobs, logins and maintenance stuff, but I've...
October 21, 2009 at 6:47 am
I have to agree with Ian here. Replication is not meant as a disaster recovery tool. It's meant to keep data synchronized between separate offices such as bookstores or airlines.
Log...
October 21, 2009 at 5:47 am
BTW, have you looked into Data Mirroring? That might stand you in better stead.
What about passive / active clustering with RAID 5 or RAID 10? That is probably the easiest...
October 21, 2009 at 4:51 am
Regarding #1, Server A becomes the backup once it becomes available again. Don't try to transfer. It's too much work. Just re-snapshot the database(s) in question and restart Replication using...
October 21, 2009 at 4:47 am
A few things to remember:
Make a checklist. -- We can't give you a specific one because it depends on how your server is setup. The checklist should include EVERYTHING...
October 21, 2009 at 4:42 am
Ditto, ditto, ditto. Reboots are EVIL (unless your server is totally screwed already or you're doing a software update that requires it).
Ask your hosted team why they've implemented that policy....
October 21, 2009 at 4:31 am
Ah, yes. The great SAN debate.
SANs can be wonderful things. We use them in our environment because we have clustered servers. However, the IO issue is well known and...
October 21, 2009 at 4:29 am
Your question is too vague. Nobody will answer if they don't know exactly what you're looking for. Also, the question makes it sound as if you want people to do...
October 21, 2009 at 4:24 am
I'm pretty sure you can change the default namespace, but you'd have to play with it to be positive.
Why don't you test it out and publish an article on your...
October 21, 2009 at 4:17 am
I don't think so. I'm pretty sure the FOR XML..., ROOT command is brand new with SQL 2005.
Sorry.
October 21, 2009 at 4:16 am
Viewing 15 posts - 8,221 through 8,235 (of 9,715 total)