It's not clear what you mean. Are you getting an error or deadlock? Can you explain more what you are trying to determine or what the problem is?

If the service account is expired, you might not have an issue until the SQL service restarts. It is running and like a live user, it doesn't necessarily get kicked...

You need to better define requirements. If the user can change the fields or determines them, how do you determine uniqueness? You can use a GUID to guarentee uniqueness,...

I've had issues with the wizards as well. Use a backup / restore or a detach attach to move databases.

Full Text searching is for searching large values of text for some data, similar to what you get with Google, Live Search, etc.

If you have queries that you are using...

Not sure if this is possible, but you might ping Steve Lasker. He worked on the Compact team.

http://blogs.msdn.com/sqlservercompact/

Looks good to me!

Be aware that I've seen in SS2K jobs change to a new owner if they're edited, so keep this around. Not sure if that's a problem in...

Are you sure you're connecting to the same machine? Are you going with Windows name, IP, FQDN? I'd suspect you're connecting to two different machines somehow or two instances for...

That does seem high. Do you have some type of auditing turned on?

Interesting. I wonder if there is anything about the discounts being for students only. If so, I wouldn't expect you to get one.

Good luck on the exams, and watch for...

I'm not sure the SQL binaries come into play. It's separating the various spindles used in databases that give you performance boosts.

If tempdb is heavily used, then this can help...

I wasn't aware of this, do you have a URL where this is?

First of all you shouldn't shrink databases. It moves things around and causes fragmentation and can slow down index response and increase query times. Shrinking should only be done if...

You are there to make things better, drive the use and efficiency of SQL Server forward. Training someone to bring up the rear so when you're gone things still move...

tables, views, etc are NOT files. They are objects within a database file. You can have multiple database files per database, but those do not determine the tables, etc.

You script...