Just an aside, you can also setup RoboCopy to act as a service and automatically move the files to another location when the backup has completed. I did this...

Eric M Russell (9/20/2012)

---

Lynn Pettis (9/19/2012)

---

Eric M Russell (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

Two year old thread, and no, I don't...

Lynn Pettis (9/20/2012)

---

Care to show...

Care to show us a...

I don't think anyone really cares, except maybe you and your pet mouse.

Lokesh Vij (9/19/2012)

---

There is a requirement, details as below:

1) Copy data from transaction table (around million records inserted daily) into a archival table

2) Delete data from transaction table

3) Step (1)...

sqlguy-736318 (9/19/2012)

---

I think it's unfortunate that MS doesn't provide an automated tool to review a SS database for standards compliance. The nice thing about FXCop is that it's somewhat...

Bump. Have you tried my latest change? You know, not including the [ ] around the server name and instance name with the -S parameter to bcp?

dwilliscp (9/19/2012)

---

Why is the following statement not deleting the backup files?

EXECUTE master.dbo.xp_delete_file 0,N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\master',N'.bak',N'2012-09-12T16:25:36',1

It finishes without error, in a second, but there are still files with...

Also, don't name your procedures with "sp_" as you may run afoul of a Microsoft system stored procedure of the same name.

sqlguy-736318 (9/19/2012)

---

Based on my initial scan of the threads the threads don't appear to reference any official MS standards.

MS provides an automated tool named FXCop to check a .NET/C# codebase...

amar_kaur16 (9/19/2012)

---

Hi,

I am using avg() function to get the average values for 3 questions.

q1, q2 and q3.

The actual average is 1.0857 for q1 but getting 1 for q1

actual avearge is...

kavern (9/19/2012)

---

That is assuming i know all the products and i can type one at a time. I was just giving an example on how the table data will look...

Lowell (9/19/2012)

---

cidr (9/19/2012)

---

Thanks for responding Lowell,

The only issue with this technique is that there are literally 10s of thousands of parts so I'm not sure if this technique would work;...

Brandie Tarvin (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

Brandie Tarvin (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

Do you ever feel that no matter how many times you tell someone what the problem may be that they just aren't...