ssk0507 (8/19/2010)

---

how will we come to know that backup is failed ? recently i had attend one interview they were asked like this

i searched in google but i didnt find...

danny yun (8/19/2010)

---

Hi Guys,

We have an application (confirmit) that dynamically create, activate and deactivate databases. There are over 7000 databases in a single...

MAK-1128556 (8/17/2010)

---

we are running SQL 2005,

I create a transactional replication.

when I restore the publisher db “A” into the subscriber server with different name “B” all the publisher that I have...

gmamata7 (8/17/2010)

---

Hi,

We have a SQL job running every 5 mins and sometimes it's displaying the below message when we view job history and at the same time the application is...

krish.sett (8/17/2010)

---

Hi Folks,

In my current project i need to clean the tables before i run Packages on it.

However because of Foreign key relation its not allowing to use TRUNCATE...

Yes u r !

Update to system tables should not be done in any way.

Gail...

yonision (7/23/2010)

---

Hello,

I have a bunch of servers, one of which performs replications really slow. After few days of trying to do whatever I can to enhance its speed, I tried...

Bill Gates-870674 (6/24/2010)

---

ello,

"SQL Server 2005 64Bit with latest SP"

Already Synchronizing some subscriber with this publication. Created a cooy of Exisiting DB and added as a new subscriber. Subscription created successfully....

striker-baba (7/15/2010)

---

Hi all,

We recently migrated our sql 2005 windows 32 bit to sql2005 windoes 64 bit.

I have one linked server related to sybase.

Inorder to configure I need either odbc driver...

thinknight (7/12/2010)

---

Hi All,

How do i get a result like this

set @qString = 'xp cmdshell ''rename '+@file1+' '+@file2+''' '

declare @result int

exec @result = @qString

It fails how i correct this? and...

digdave7 (6/24/2010)

---

I was using

ALTER DATABASE [XXXX] MODIFY FILE ( NAME = N'VSD2', SIZE = NumberBiggerThatbeforeKB )

Technically they are in filegroups, right now we can't even open the database properties...

pujain (6/23/2010)

---

Hi All,

I am having a testing server(16 GB memory) 14 GB for SQL SERVER on which USER complaining about the slowness.

can anybody suggest me a path how to go...

keyun (6/23/2010)

---

Hi All,

I am using SQL Server 2005 where I have created SP to export out data into CSV file. I am using BCP utility to export out my...

kiransuram19 (6/23/2010)

---

Hi All,

Today one of our deveploers updated 600000 records on the publisher database and the update took around 10 minutes to finish but the issue with subscriber its taking...

Hello,

Can you let us know what are you trying to achieve by growing db ? What TSQL are you executing?

There is an option for growing your db in chuncks of...