I collect the disk space info on each of my SQL Server here at my job reporting this info from a centralized SQL Server.  To get the info to the...

If the original database is present, why not make a backup of that database and then restore it with a different name for the database and the dat files.

Dave

A slightly different approach to handling all of the file manipulation in an Active X Script in the DTS would be to handle it in the stored procedure.  You can...

Max,

I am just going to take a stab in the dark here, but..

Is the name of the production database the same as the database on the testserver? If they...

Keith,

To make sure that the transaction log does not get away in the future, the DBA will have to set up a Full Backup followed by Log backup with truncate....

Keith,

You are correct in that that method will work in transfering the database to the new location, but what about the run away transaction log. How would you clean...

Thanks for the reply.

Are initial planning is for a rolling 2 years worth of data. Our users say that after two years, the data is meaningless for them to...

Gentleman,

How about using the RIGHT() function.

IE...

DECLARE @Number int

SET @Number = 768

SELECT RIGHT('000000' + CONVERT(varchar(6), @Number), 6)

results: 000768

Another option on trying to shrink the transaction log is detaching the database and only attaching the .mdf files after removing or renaming the .ldf file. When you attach...

I would suggest scripting out all the views and stored procedures. Copy the script into Query Analyzer and use the FIND and REPLACE options under the EDIT menu. ...

Here are two sql statements. The first when will return the date as mm/dd/yyyy. The second will return the day of the week such as Monday. 1)...

I have run into the 'computer-savvy' associates at my job also. To limit their damage to the databases, we implemented the following:

The developers of the application have full access...

It depends on what you allow the developers to do. Here, the developers have EM for they do their own DB development with help for the DBA's. Before...

Oops,

In the above post where it says:

CREATE PROCEDURE p_Get_ValidCombos AS

Should say:

CREATE PROCEDURE p_Get_ValidCombos (@A int, @b-2 int, @C int) AS

Dave

Charlie,

If I understand you, you want all the 3 digit combinations that add up to the sum of the three parameters that are passed into the SP. To accomplish...