Viewing 15 posts - 26,236 through 26,250 (of 39,793 total)
Are you running an update or did you change the table properties in SSMS?
Please give more details about what happened and what you did. Also, how are you making this...
November 24, 2008 at 8:57 am
I'm not sure I understand the requirements here.
Searching for matching fields and non matching fields are conflicting issues. It sounds like you are trying to do both at once.
Can you...
November 24, 2008 at 8:54 am
My first thought was replication, but you have to meet the requirements (PKs, GUID, non changing subscriber, etc.) for that. You can get around some of them, but it gets...
November 24, 2008 at 8:51 am
First, for DR, you want to separate the data from the backups.
Doesn't make sense to separate either LUN into mutliple partitions as they're going to the same physical disks, you're...
November 24, 2008 at 8:48 am
Compression makes sense to save space, but if you're that tight on space, the read/write from a DB will be problematic. If you can spare the space, I'd uncompress.
November 24, 2008 at 8:45 am
I found this: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=243826
I don't see a setting specifically for NULL, but I bet it's somewhere in the XML file for SSMS.
November 24, 2008 at 8:44 am
I did some testing with SS2K8 and didn't change anything on my side, had Chinese and Japanese stored in a column and it worked fine.
Are you cut/pasting this in SSMS...
November 24, 2008 at 8:37 am
Removed the post that are irrelevant.
The data files get written to in a round robin fashion if they are in the same filegroup. Current objects stay in their own files.
Are...
November 24, 2008 at 8:32 am
It's what it says. it usually indicates some hardware issue.
You can try rebooting, but if you got this again, I'd call Microsoft and have them help diagnose this. There aren't...
November 24, 2008 at 8:19 am
It's not that the questions are bad in that they shouldn't be asked. It's that the posters don't take a few minutes to properly frame a question or do any...
November 24, 2008 at 8:18 am
Please stop and post a question that we can understand. You have written a bunch of phrases that make no sense.
November 24, 2008 at 8:16 am
What is GP10?
What client are you using to connect? If you are not using the SNAC client, which comes with SS2KL5 and later, it will not automatically connect. The previous...
November 24, 2008 at 8:15 am
Vista should exceed W2K3 in what is support, if I remember correctly. I don't have a W2K3 server to check on at the moment, but I'll try to later.
November 24, 2008 at 8:12 am
DTS will script this, which should handle constraints. Or you can just do the scripting, move the structure of the tables and use DTS without the drop/create.
You said you are...
November 24, 2008 at 8:11 am
Viewing 15 posts - 26,236 through 26,250 (of 39,793 total)