jpmathew10 (7/28/2011)

---

I have created and scheduled the job in SQL server 2008 R2 SP1 server.

But i found that the job is not run as per the schedule.It often run after...

forsqlserver (7/28/2011)

---

How to remove the shared tools like business inteligence developemnt studio,client tools connectivity,clients tools sdk.

Actually its checks are coming as disable and I want to remove this?

I have selected...

Yes I am sure. I asked you about sql version because SQL 2008 R2 standard and enterprise versions have a capability to compress...

forsqlserver (7/28/2011)

---

My primary database in logshipping is more than 500 GB.I need to restore the database on secondary server.

Sites are quite far and also not the eligible WAN link for...

Roy is correct here. Enterprise manager will refuse to connect to sql 2008 version but keep pesturing it till it gives up and says' Do you still want to register...

I am sure it resembles either Brandie, Ninja ,Lowell or Gila...

You had mentione that the developer is sysadmin on sql server so i find it strange that something is stopping him.I...

are you on a 32-bit server or 64 bit. I am sure that i used to configure 32-bit DSNs for connecting...

ramyours2003 (7/27/2011)

---

is it possible to configure replication from sql 2000 to sql 2008 ?

if yes , what changes do we ...

Lowell (7/27/2011)

---

based on this ms doc, where changing the server collation requires a rebuild:

http://msdn.microsoft.com/en-us/library/ms179254.aspx,

i'm guessing that the server collation is actually the collation of the resource database, regardless of...

I tried it on my...

There is an entry for collation in HKLM\Software\Microsoft\Microsoft SQL Server\<Instance ID>\Setup.

the original entry was SQL_Latin1_General_CP1_CI_AS. I changed it to 'chandan' and rebooted the server.

after reboot, the registry entry...

I ran 'sp_helptext'SERVERPROPERTY' in master database and it gave me following results:

Msg 15009,...

I can't agree more with you:-D . Her name is Gail...

If your answer is 'YES' to my question above, then I can recall that system DSN can be used by everyone who is a user of that system. When you...