I've granted access to the path C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA and finally the service is running.

Thanks.

I've ready check startup parameters, they are right on its place, they are:

-dC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf;
-eC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG;
-lC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

I've Run as...

Thanks for the sugesstions, I'l try to move my non clustered index to a new filegroup.

Thanks

Once a week on weekend, I have a task maintenance task that rebuid index, defrag, update statistics and other things.

Actually my mdf and log file are on different disks, indexs...

hi, I've implemented this.

IF EXISTS (SELECT name FROM sysobjects

      WHERE name = 'NOT_FOR_INSERT' AND type = 'TR')

   DROP TRIGGER NOT_FOR_INSERT

CREATE TRIGGER NOT_FOR_INSERT

ON SERVICE_REQUEST

FOR INSERT

AS RAISERROR (50009, 16, 10)

ROLLBACK TRANSACTION

GO

Finally,I need to update status column when my Request_Date value is the same that getdate value, the time value is not the same, in my column I have 2005-06-06 00:00:00.000 and getdate has...

Excelent It's working.

Thanks guys.

Finally, It's working.

I'm using DTS, I've created my source(xls), my destiny (SQL), Execute Slq Task and I'ts working.

Thanks everyone  for your advices.

Actually I'm working with DTS but I need to call this functionality from an asp page, in other words, I have an application that needs to load data from an excel file and...

the problem is when the character is not allways in the same position, it could be D00A, OR D000000A, the data stored at the column has different lenght.

Thank for the...

Thanks, I got sql compare software to compare my databases.

Tanks everyone.

I using two different ways to move my databases, one is Import or Export a database and the other to restore in a new location my databse using a backup....

The Oracle Database is on Windows.

I need to run the stored procedure in Sql Server and It's going to be called by Oracle, Oracle has the data.

I wrote these:

CREATE PROCEDURE SP_SIAB_INS_UPD (

 @NO_BIEN AS INT,

 @DESCRIPCION AS VARCHAR(1250),

 @CANTIDAD as int,

 @DEL_ADMON...