select * from db.document does not work. strange.

when i ran the following query - Select * from sysobjects where name like '%document%' and Xtype = 'U' - i do see...

Sorry the error what i get is as follows:

Source: ODSOLE Extended Procedure

Description: Class not registered

The box has 22 GB and 18 GB is configured to SQL Instance (FIXED) When i looked at the memory utilization - SQL is using all the 18 GB allocated...

The backup code isnt changing the database restriction. It's a regular full backup running with init option. thats it.

Additionally users are able to connect to the database but reported the...

Thanks for the contribution.

Say if i have to rebuild the indexes offline - do i need to put the database in single user mode? My initial question was - what...

Thanks for the contribution.

So what happens when i execute the following code:

ALTER INDEX ALL ON Product REBUILD??? I dont see online rebuild option is specified here with the command. But...

Thanks for the contribution Steve.

I am running the Export process physically from the Production server. It's strange as to why i cant have this simple process run sucesfully?

Jack thanks for the post.

I looked at the provided URL and unfortunately it was not very helpful. Yes my environment is 64-bit and all i what i am doing is...

Yes installed SP2 on both of them.

Thank you Ola.

Thanks for your reply.

I am looking for something like this: ALTER INDEX ALL ON Customer REBUILD WITH(ONLINE = ON). Is there a way i can generate Alter index for all...

Well SA password is different and in the security connection syntax i am giving connect using SA login and providing the right SA password. weird dont know - whats going...

Yes i changed the query to use prod.master.dbo.syslogins. I dont see the connection. all what i see is - its executing the query.

I.E - when I execute the query...

Unfortunately no error... it's weird. its runing for like 15 minutes now without any errors.