I have to admit being lax about security as far as developers go. Of course part of this comes from the fact that I have always worked in small...

sys.database_files has the data you are looking for.

It depends on the your design. If you have no FK's defined you can just do sp_msforeachtable 'truncate table ?' or sp_msforeachtable 'delete from ?', but if you have...

Lynn Pettis (8/11/2008)

---

Not always true. Had a player get fouled, blew the whistle and called the foul...

Lynn Pettis (8/11/2008)

---

Most games I do are DSC, not dual whistle (or like we do at the High School varsity level (JV does dual whistle) here in Colorado, Double Dual...

Lynn Pettis (8/11/2008)

---

That is sad. Did you guys keep refing after that? My older two are/were refs, and both have quit because of nasty coaches/parents. The money...

Hey, experience shouldn't...

Not bad. If you are doing something like this often, or just want to be able to migrate schema changes it is...

Since you had figured it out I didn't take a look.

There is no way that I am aware to use header/footer information in the main body of a report. At least not something like the Pages and PageNumber. ...

steveb (8/11/2008)

---

You can have a look at 'Schema Changes History' Report for that database using SSMS.

from this you should be able to see when the last schema change was for...

You could try setting the KeepTogether property on the table to True

We actually chose NOT to use SQL Server to encrypt/decrypt this data, but to put the encryption/decryption in the business layer because using SQL Server encryption means that the data...

Check out this article: http://www.sqlservercentral.com/articles/tamestrings6/263/

In SSMS right-click on the database and select All Tasks - Generate Scripts. First you should go to Tools -> Options -> Scripting and make sure all the pieces...