Hello Oberion,

You can use

sp_helptext 'ur procedure name'

Thanks and have a great day!!!

Hello Tom,

Please go through the Books Online for this topic

linked servers, security

Thanks and have a nice day!!!

Hello IanR,

You can create DML triggers at the server/database levels. Please go through the following URL

http://msdn2.microsoft.com/en-us/library/ms189799.aspx

Thanks and have a great day!!!

Hello Bill,

You can check up through this query

Select crdate as DateCreated

From dbo.sysobjects

where name = 'your_proc_name'

This has been detailed in today's editorial

SQL 2000 to SQL 2005: Where...

Hello Ishaan,

I took a test backup with data through SQL Litespeed and restored back successfully. I have used the normal restore syntax and executed in QA.

restore database [Test1]

from DISK=...

Carol,

You mean that 2 jobs scheduled to run -- one for every 2 hrs starting at 2AM running until 5 AM and the other at 4AM. If so, then the...

Hello,

Decimal Data

Decimal data consists of data that is stored to the least significant digit. Decimal data is stored using decimal or numeric data types in SQL Server. The number of...

what the DTSStep_DTSExecuteSQLTask_3 is doing?

Hello Frances,

dtsrun /U --> Username /P --> Password /V -->Package Version GUID String /N --> Package Name /M --> Package Password

You can refere to the Books Online -- dtstun utility for...

Hello Anthony,

The default in SQL Server are as follows:

Field PostDate default value is: Date()

which equals Getdate()

and

Field EffectiveDate default value: is Date()-(DatePart("d",Date()))

which equals Getdate()-(DatePart(d, Getdate()))

Thanks and have a great day!!!

Hello Jones,

Change these lines

from inmast inner Join rcitem

on inmast.fpartno + inmast.frev = rcitem.fpartno + rcitem.fpartrev

join rcmast on rcitem.freceiver = rcmast.freceiver

join rcinsp on rcitem.freceiver...

Hello Paul,

Have you checked the error logs? any information you found.

try to take a manual backup of the said attached database. if it works, then try to create a new...

Hello Enrico,

Can you check up the default date format for your Windows OS? It might be of the format "dd-mm-yy".

Thanks and have a nice day!!!

Hello Chris,

Please go through this link

http://msdn2.microsoft.com/en-us/library/ms155917.aspx

Thanks and have a great day!!!

Hello Papillon,

Does the second sever has remote access to the backup file of the first server?

If so, on the Restore option from Enterprise Manager you need to give the backup...