Forum Replies Created

Viewing 15 posts - 26,236 through 26,250 (of 39,793 total)

  • RE: error updating table

    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...

  • RE: Create audit tables

    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...

  • RE: Finished my MCITP on Friday

    Congrats!

  • RE: Data synchronization

    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...

  • RE: Data warehouse SQL config

    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...

  • RE: SQL 2008 Express on compressed volume?

    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.

  • RE: SSMS NULL vs 'NULL' in grid

    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.

  • RE: Select statement using Chinese characters in the where clause returns null

    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...

  • RE: Reg. Secondary Datafile

    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...

  • RE: Event 832 error

    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...

  • RE: Are the posted questions getting worse?

    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...

  • RE: sql database recovery

    Please stop and post a question that we can understand. You have written a bunch of phrases that make no sense.

  • RE: GP & Database Mirroring

    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...

  • RE: Password policies checked by CHECK_POLICY

    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.

  • RE: Schema copy

    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...

Viewing 15 posts - 26,236 through 26,250 (of 39,793 total)