Ninja's_RGR'us (2/13/2009)

---

bitbucket (2/13/2009)

---

I think I have gained an insight into why some of the users questions appear to be soooooo, well not intelligent. Last evening I attended a SQL...

How does the backup server know what its ID is?

The following will return the last day of the previous month:

dateadd(mm, datediff(mm, 0, getdate()), -1)

Personally, the queries, however, should be coded as a < and use the following:

dateadd(mm, datediff(mm, 0,...

Then scope_identity is returning null. Tried this, select scope_identity(), on my dev server, and it returned null.

I'd put an isnull() with a default value around your call to scope_identity...

littlebeeper110 (2/13/2009)

---

Project:

Setting up transactional replication for a large hospital system. Replication pulls changes from primary server to x-number of facility servers. Replication is setup and working correctly.

Issue:

Each replicated...

what does select @path return?

If @path is null the string returned from the concatenation will be null if SET CONCAT_NULL_YIELDS_NULL in ON.

Maybe this will help.

When you backup your database, HomeDesignDB, the backup file contains the physical location and filenames of the mdf/ndf(if present)/ldf files. For example D:\Databases\HomeDesignDB.mdf, D:\Databases\HomeDesignDB.ldf.

When you restore...

Chris Morris (2/13/2009)

---

Heh yeah I...

Here is a solution, based on the article everyone mentioned and is also listed below in my signature block.

create clustered index IX_RunningBal on #temp (

budget asc,

...

First, I got my degrees to fill in the boxes while looking for work in my chosen career field. Plus I enjoyed going to school and learning.

I will agree,...

Chris Morris (2/13/2009)

---

Lynn Pettis (2/13/2009)

---

Not saying this is true of all PhD's, but many of the ones I have met seemed to have lost one very important thing, common sense....

Why do you think it is only storing 8K of data?

Could be, of course, that common sense isn't all that common.

Not saying this is true of all PhD's, but many of the ones I have met seemed to have lost one very important thing, common sense. Is there a...

Actually, I think we need an emoticon for sarcism. Know of one?