1) use DTS

2) use linked server make linked server using following query.

EXEC master.dbo.sp_addlinkedserver @server = N'EXCEL', @srvproduct=N'E', @provider=N'Microsoft.Jet.OLEDB.4.0', @datasrc=N'c:\Employee.xls', @provstr=N'Excel 8.0'

/* For security reasons the...

server admin can log in windows but sys admin log only sql server.

Sys admin require person on files of server but server can do operation shared files.

DINESH\TEST3=> servername

dba =>username

######## => Password

then create linked server.

EXEC master.dbo.sp_addlinkedserver @server = N'DINESH\TEST3', @srvproduct=N'SQL Server'

EXEC...

Can you check any job schedule on Instance=>Management=>any Job schedule ??

reatart Sql Aget and see.

Any problem,Let me know.

you can hide system databases => tools -options->open object Exlporer then click on Hide system objects in object Exlorer. resart instance.

You give user acess to each database by mapping...

Every thing is fine just take backup in COMPRESSION mode.

hi,

I had check following query it is working,

select * from OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=c:\Employee.xls;',

'SELECT * FROM [Sheet1$]')

If any problem ,Let me know.

Regards,

Dinesh

1)Make that database to simple recovery mode.

2) shrink log file

3)increase growth percentage

Hi,

server name='DINESH\TESTMSSQL'

loginname='test'

loginpassword='########'

replace in following script and use it..

EXEC master.dbo.sp_addlinkedserver @server = N'DINESH\TESTMSSQL', @srvproduct=N'SQL Server'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DINESH\TESTMSSQL',@useself=N'False',@locallogin=NULL,@rmtuser=N'test',@rmtpassword='########'

GO

EXEC master.dbo.sp_serveroption @server=N'DINESH\TESTMSSQL', @optname=N'collation compatible', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'DINESH\TESTMSSQL',...

You check server start time and only sys admin can start or stop server.Better way give minimum right to user.

if there is login exist then delete and add login to corresponding user.

1) Create login to user.

USE [master]

GO

CREATE LOGIN [mailuser] WITH PASSWORD=N'mailuser',

DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO

2)create addmember for databseMailuser

USE [msdb]

GO

ALTER USER [mailuser] WITH DEFAULT_SCHEMA=[dbo]

GO

3)login with mailuser in SSMS

USE [msdb]

GO

EXEC sp_addrolemember N'DatabaseMailUserRole', N'mailuser'

GO

select...

1) Check IIS pool is full or not if is make iis restart.

2) check CPu utilization on server

3) check all process on ssql server

4) check error log.

5) if required check...

When you are tracing event on database name ,you see all details like select and all opration on profiler.