If I left the secondary database in Standby - can I make backups from the secondary database?

Yes, there is a reason. All the options, log shipping, mirroring, etc., leave the database in a non-usable (standby) state. I need a database copy that I can...

Craig,

You are correct. The real function would not print the average cost. It will be turned into a user defined function that would return the weighted cost....

Ok... I am still a little confused. Would I be safe in doing the following:

1) Checkpoint

2) Backup Log File

3) DBCC Shrinkfile ( log file), 0, Truncateonly

4) Full Backup

5)...

Craig Farrell (2/3/2011)

---

Mike, are there more senior DBAs on staff, or did you get volunteered to the position because noone else will do it? The reason I ask is...

So ColdCoffee's solution would get me one record per name with up to 3 colors listed in 3 columns?

Yes, there is an identity column.

I understand the APPLY much better than the other solution. It works!

Now, using the same data, I was asked if there was an easy way to flatten...

Ok, now what if there is not a rank. What if the color is ordered by the way it is entered. How could I get the 1st 10...

Yep, I meant log shipping. I am looking for a solution that I can easily implement and maintain. It needs to allow me to do local backups against...

Mark-101232 (12/15/2010)

---

INSERT INTO hdr(id,pk,notes)

SELECT ROW_NUMBER() OVER(ORDER BY a.fk),

a.fk,

STUFF((SELECT ' / ' + RTRIM(b.dtl_note) AS "text()"

...

For a PK, it is a...

I am trying to prevent having to handle a duplicate pk insert.

Here is the structure of the table:

gpk - Table Name

gpk_currentnumber - last PK used

There are 200 records...

I am using this as a PK for other tables. I am choosing not to use an identity column.

Ok...

This:

use xyz

EXEC sp_grantdbaccess @loginame = 'sv2'

gets me 'public' database access to xyz for user sv2. How do I programatically get the db_owner set for the same...