Thanks for the reply,

this table has the column page path, this column navigates the application for the required selection on the page. Not for all the users - the selection...

Try this,

Follow the Link Might be helpful : http://www.mssqltips.com/tip.asp?tip=1433

EXEC sp_addlinkedserver

@server = 'Server Name'

, @srvproduct = ''

, @provider= 'SQLOLEDB'

, @datasrc= 'IP Address'

GO

sp_addlinkedsrvlogin @rmtsrvname = 'Server Name'

,@useself = 'FALSE'

,@locallogin...

Try this,

Might be helpful : http://www.mssqltips.com/tip.asp?tip=1433

EXEC sp_addlinkedserver

@server = ''

, @srvproduct = ''

, @provider= 'SQLOLEDB'

, @datasrc= ''

GO

sp_addlinkedsrvlogin @rmtsrvname = 'Server Name'

,@useself...

Resoved... Closing this..

Try to identify the Costliest Queries, processes. I also suffered alot because of this CPU - 100%.

Fine tune the queries and procedures for better performance as per SQL ANSI.

I did...

Try to uninstall the SQL Server completely, reboot,re-install and reboot and then try to connect. This should resolve the problem.As your installation is not done perfectly or Corrupt.

Let SQL Server...

Use Micrsoft Excel as a Data Source for Importing the data from Excel, give the location of the file path and try.

Check if the file is not opened or used...

Thanks Gail for reply.

I always prefer smart way. So i asked for the same. NOt the easier way, nothing is easier to get...

Any more help..

Rgds,

Win..

Is there any way to see the stored procedure statistics ??

How many times stored procedure used, so we can remove some of unused stored procedure.

I need to identify...

Thanks a lot for all.

Let me try and update you the same soon.

Rgds,

Win

Thanks Lowell for your Quick response ..

do all 520 tables have the DateCreated column with a default of getdate(), so that the tables can be queried individually to archive off...

Any ideas reg tools, utilities....??

Any one to suggest or help ...??

Thanks Amit,

I have seen the same in one of the sites.... But my query is to transfer data from one server to another server with same database name and after...

Thanks for the replies.

can any one suggest me to proceed further, am not that much great into code writing other than DBA concepts...

Please do the needful..