I believe Prakash is talking about C2 auditing, which can be enabled using sp_configure.  I'd check it out in BOL first and I'd advise caution before using it because it...

Hi,

Your best bet will be something like Lumigent's Log Explorer or SQL Log Rescue by Red Gate.  There are similar products out there on the market.

All of these products depend...

What command are you using to copy the file?

The return code can be the return code of the command you're running even though it states in BOL that valid return...

The operation seems to be ok.

Just to confirm:  Is [MVG T003 - Eliminate outliers from T001] a table or table alias, and [CurMileage] is a column?

Is it...

Hi Dave,

Try this:

select distinct G1, G2, G3, G4

from table

Hope that helps,

Hmm,

The two numbers are different. 2.850349609E+11 is 285034960900.

The question is, what are you doing to arrive at these figures?  Is it a mathematical operation of some sort?

Try this:

SELECT CONVERT(CHAR(10),GETDATE(),105)

Hi Melissa,

When you perform the role change and you execute the procedure sp_change_primary_role you should specify a value of 2 for the @final_state parameter. This will put the primary...

Hi Rama,

Try this for your @whereand parameter:

@whereand = N'and XTYPE = ''U'' and UID = 5 and NAME like ''TMP%'''

To test it, use the following for your @command1 parameter:

@command1 =...

Hi Roger,

You'll need to use the extended procedure sp_sqlagent_enum_jobs, like so:

exec master..xp_sqlagent_enum_jobs 1,''

The running column will tell you whether a job is currently running. It only provides the job_id...

Hi Mike,

This sounds like an interesting problem. Unfortunately it's going to be difficult to offer you a definitive answer because so many things depend on what model of replication...

Hi Darren,

In the past, when doing this kind of thing I skip the part where you detach the databases. When I shutdown the SQL Servers I copy the system...

Hi,

you need to use decimals otherwise SQL Server will assume you're trying to divide integers.

Try this:

select 6.0/30.0

Hi Chris,

There is a distinction between shrinking a database and shrinking a transaction log.

As you noted, shrinking a database fragments the indexes. This however does not apply to shrinking...

Hi Rama,

You need to include your other filters. Also, if you have a case-sensitive database, make sure the column names are the proper case.

Try this. Note the debug...