Viewing 15 posts - 8,236 through 8,250 (of 9,725 total)
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
I'm not sure I understand the problem. Are you saying you want to load nulls but can't or that the data doesn't appear to be loading at all?
October 21, 2009 at 4:12 am
ucbus 92278 (10/20/2009)I have tried to use "FOR XML" tag by creating a view of the data, However this resulted in multiple rows in a FLAT structure. To get the...
October 21, 2009 at 4:11 am
Have you tried googling for XML escape characters?
How are you importing the XML into SQL Server? Via SSIS or another method?
October 21, 2009 at 4:05 am
Sunil,
In the future, please start a new topic with your question rather than piggy-backing off another thread.
SSIS is the best way to load an XML file into SQL server in...
October 21, 2009 at 4:03 am
If there's a way to do that, yes.
But if another of the SQL Tools does Gantt Charts (besides Project), I'd like to do that too.
October 19, 2009 at 11:20 am
Viewing 15 posts - 8,236 through 8,250 (of 9,725 total)