Can you describe the setup/scenario a bit more?

When you check the file properties on said mdf and ldf files, are they marked read-only?

SQL Server is going to automatically lock down permissions as tight as possible (the whole secure by default mentality) for the data files, which is why you're seeing the behavior...

Before removing this account, verify that the following are not true (you can do all through services.msc or the Configuration Manager):

• The SQL Server service isn't logging in as localsystem
• The SQL...

The easiest way is to build a script to write the script for you. You can simply query the schema and table name from INFORMATION_SCHEMA.TABLES and then built your ALTER...

Agreed, this should be a configuration issue. What error(s) are you getting? Have you tried just using the standard ODBC tool just to see if you can make a connection...

I'm going to have to piggy-back on Colin:

what caused your problem

That's a really important question as it helps determine the right answer. Also, if you haven't solved the problem (i.e....

Have you thought about fleshing this out a bit more, including some of the issues you faced, and submitting as an article? We see this question every so often in...

Another option, if you have backups going back far enough, is to restore a backup of when you know all the objects were present. But restore it to a different...

*scratches head*

When in doubt, check the terms and conditions... this is a good policy for any site, especially any e-commerce sites. I guess I'm not surprised that folks didn't check...

Lee,

I can understand the discouragement you feel due to some of the comments to your bitmasking article, but I hope you'll continue to participate in this community. SSC has been a...

Then again, in hindsight, it is an article... so we can always find it quickly.

Aye, but if you sticky it, we know where to find it if we find someone not following the rules of conduct and we can refer them to it.

I'll get into indexing and prioritizing (that one mentioned earlier as well) in the next segment...that is if anyone actually wants the next segment.

Hang in there, Lee, and write...

Joe, you're missing the point of what I said with respect to the IP address. While I agree with you that the four columns made more sense, it's a 3rd...