You could import the Access db periodically and look for changes.

Either in Access or SS, I'd be wary of "real time" alerts. You often find that you didn't mean to...

Good to see that many people build their own "mini-mes" to help them out.

And some interesting solutions. I might look to modify some of our systems based on what's in...

Just use the concatenation operator, +

declare @i int, @j-2 int

select @i = 0, @j-2 = 0

select

case when @i = 1 then 'Test'

else 'Live'

end

...

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

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

Congrats!

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

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

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.

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.

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

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

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

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

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