temitaio (8/15/2011)

---

I need help with this check constraint, I get the following error message: "Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '='."

ALTER TABLE <TableName> ADD CONSTRAINT <NameOfConstraint>...

"I get very...

sunny.tjk (8/10/2011)

---

Michael Valentine Jones (8/10/2011)

---

Is it possible that your database is actually a database snapshot?

http://msdn.microsoft.com/en-us/library/ms189940.aspx

"A SELECT statement that is executed on a database snapshot must not specify a FILESTREAM column;...

Is it possible that your database is actually a database snapshot?

http://msdn.microsoft.com/en-us/library/ms189940.aspx

"A SELECT statement that is executed on a database snapshot must not specify a FILESTREAM column; otherwise, the following error...

srinath.vanama (8/9/2011)

---

IN SQL Server 2008.

1) Backup encryption is possible.

2) Data compression and Resource governor.

3) Installation improvements. Disk images and service pack uninstall options.

4) TDE(transparent Data Encryption) Ability to encrypt entire...

Check the history in your source control system?

I would only go that way if I was absolutly sure that a single shared database at one site would not be practical.

I think an index on that column would be fairly worthless, since it is in MM/DD/YYYY format. The only thing it would be any use for is a direct...

I have had people on my team that are full time work from home for the last 10 years, and I am happy with the situation.

We are considering and probably...

Great Circle Distance Function - Haversine Formula

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81360

We use SQL Server as our database platform, but still have other RDMS in use because they came embedded in software packages.

I know we have Oracle, SYBASE, MySQL, Informix, and...

##temp tables are created in tempdb, just like #temp tables.

I recommend that you avoid ##temp tables whenever you can, and only create them when there is no other way to...

I am not a fan of direct-to-tape database backups using Backup Exec, ArcServe or other SQL Server backup agents for several reasons:

1. The tape drive is usually a shared resource,...

This will tell you the space used inside all database files, and much more.

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

Why is the memory usage a problem?