Select profiler and you can run new trace from there...

OR

DBCC TRACEON (trace_flag_no,-1)

Restart the service to take effect of changes

OR

You can enable trace flag using command prompt.

net stop mssqlserver

net start mssqlserver -Tflag_no

Thanks Again 😀

Thanks JWOL,

The problem now is the column datatype...

Deepak thanks for replying..

The problem is that the issue occured 3 days back and i checked the error logs and server logs but didnt find anything unusual.

My finding when...

Its a java application which fetches the data from MS ACCESS and imports to SQL server database.

Using XP_FIXEDDRIVES you can get the free disk space in all drives:D

Hi Sugesh,

Think Mirroring has to be removed.

If downtime is ok for you then and am with Deepak ,Go ahead with detach and attach.:)

Think you cant back to the state you want.A full backup now will give you all datas as of now and a differential contains changes since the last backup only.

Hope...

Use "sp_attach_db" for attaching and "sp_detach_db" for detaching the database files.

Check these links

http://msdn.microsoft.com/en-us/library/aa259611(SQL.80).aspx

http://msdn.microsoft.com/en-us/library/aa933267(SQL.80).aspx

😀

Use "sp_attach_db" for attaching and "sp_detach_db" for detaching the database files.

Check these links

http://msdn.microsoft.com/en-us/library/aa259611(SQL.80).aspx

http://msdn.microsoft.com/en-us/library/aa933267(SQL.80).aspx

Can you please be specific and more clear on your requirement:).

Create trigger for the same..:D

Kumar ..u got connect or still the same problem persists ???