Mike Levan (1/9/2009)

---

I trying to gain more space on my disks on different servers. I observed that there are many database files which are not used anymore on different drives,...

kiransuram19 (1/9/2009)

---

In the job you mentionted output file as c:\test_outputfile.txt..,and job will run successfully for the first time only ...after that job(2nd attempt) will fail with error.. file already exists...

iqtedar (1/9/2009)

---

hello,

i migrated the dbs from 2000-2005..we also copied DTS to DTS(not SSIS)..packages are still in legacy components(dnt ask why not SSIS..long story)...migrated the jobs to 2005..now for a...

chmod260 (3/28/2006)

---

Hello, this message was previously posted in the General Discussion and got no answer. Perhaps this is the correct place...

I was trying to install Visual Studio Team Foundation Server...

raj acharya (1/9/2009)

---

hi,

as per paresh told just create linked server and after that you can interact with there server

do u know how to linked server if you don't know then...

John (1/8/2009)

---

I want to know if there's any reliable way to determine if a server is a linked server on both SQL Server 2000 and SQL Server 2005. I...

metro17 (12/11/2008)

---

How do I trace a role(StoredProcExecuter) in sql server 2005 ? I am trying using the trace facility in sql profiler. I was wondering if there are any easier...

abhi777_aiwa (1/8/2009)

---

Hi,

I am very amature in this perticular topic, please help me out.

I want to write procedure on one database server, which have to select data from...

sqlserverdba76 (1/8/2009)

---

Hi all,,

well i have some issues with data replication in sql server 2005.

i have two DB server A and B.i am replicating database temp from server A to server...

use below :

DBCC MEMORYSTATUS

------------------

--Host wise

select hostname,count(spid) as Total_Connection,sum(isnull(memusage,0)) as MemUsage from sys.sysprocesses

group by...

kiransuram19 (1/8/2009)

---

Hi Guys,

I have a query and which gives some results and I want to automate this query using sql job(to run everyday) and I want the results of...

sqlservercentral (1/6/2009)

---

We have a table which will be subject to large volumes of INSERTs from web transactions - e.g. several per second at busy periods of the day. We need...

----------------------Row...

ishaan99 (1/7/2009)

---

I am trying to restore a backup on sql 2005 server by accessing the .bak file from a share folder residing on another server. I get an error as...

Erin (1/7/2009)

---

I have a group that is the support and administration for a major business application that is SQL based. This group is not trained in SQL, but do...