Adi Cohn-120898 (2/18/2010)

---

This is a very problematic script to write. I think that at best you can write a SQL statement that will bring you closer. For example:

Select...

I was reading through the SS 2008 System View poster this morning (I know - I should get out more) when I caught sight of the table 'sys.identity_columns', and had...

The starting point I use for finding references to a field is:

select distinct object_name(object_id)

from sys.sql_modules where definition like '%fieldname%'

BrainDonor

One way of setting the values of the columns is using the CASE function. Have a look in BOL (Books On Line).

BrainDonor

http://www.microsoft.com/windowsazure/sqlazure/

The beauty of Google...

BrainDonor

GilaMonster (2/10/2010)

---

No it does not. The log file records changes since the last log backup (in full/bulk-logged...

You have to have a Full Backup in order to restore - the Log file only records any changes made since the last database backup.

Piecing together a database from the...

If your date formats are consistant across your servers and databases then why bother formatting them? I've had to do it in the past to remove the time element, or...

I had a similair question some time ago - http://www.sqlservercentral.com/Forums/Topic731245-338-1.aspx

BrainDonor

Duplicate Post - refer to http://www.sqlservercentral.com/Forums/Topic862962-146-1.aspx

Instructions on how to use the tags would be nice, possibly emailed as part of the initial registration or as a pop-up within the Post Reply screen.

It took me a...

Unfortunately not. I may be just having a bad Monday, but I'm still puzzled by your reference to a Primary Key, when you have duplicated IDs in this.

Show me the...

suneel-210238 (2/8/2010)

---

Hi,

We have a table where we store versions of data and mark with some version indicator. Typically we are having around 50 columns in this table.

We got a requiremnt...

You have to use dynamic SQL, an example is here: http://www.sqlservercentral.com/Forums/Topic769832-338-1.aspx

Other examples are scattered throughout SSC.

BrainDonor

Gail,

How do you find them?

Do you use divining rods? I admire your determination.

BrainDonor