Are you running the command with Tab Lock?

If TABLOCK is specified it will impose lock to have consistency.

Otherwise DBCC CHECKDB uses an internal database snapshot for the transactional consistency to...

Open SQL Server Configuration manager

Right click and start the SQL Server Agent.

If the SQL Service is stopped it will automatically kick start the service.

If you get issue with logins open...

Yes. You can have it side by side.

You can schedule a stored proc that will run at certain interval and load the data in another table.

Keep monitoring the table for the largest wait time.

It its too long...

This may occur due to temporary network glitch while taking backup.

Try the following T-SQL

select * from sys.sysprocesses where blocked > 0

I have SQL server 2000 in the web server and when i tried to connect to the SQL 2000 instance from Enterprise manager I am able to connect to the...

With telnet I am able to connect to the SQL port in the database server from web server.

Now how can I make sure that SQL also connects?

When I connect from...

Thanks Sanz

I will check that tomorrow

For information we do not have any common credentials.

Visual studio is running on a credential of Domain A and SQL server is running on credential of Domain B.

I are trying...

Thanks for your reply.

i have tried to connect using both IP address and servername.

I have also verified the credentials.

Still I am unable to login.

Database server is using default SQL port.

I...

Thanks Gail and Ninja.

The information is really helpful.

Thanks Ninja.

But the stakeholders are only interested about the only the fragmented tables.

So I was trying to find out a shortcut of identifying the tables using DMVs since I have...

Thanks for your quick reply,

I have used the following query and pulled the result from SQL Server 2008 DB

select

--s.name AS [Database],

t.name AS [Table], i.name AS [Index],

c.name AS...

Can anybody at least share some experience regarding this?