pcq0125 (2/20/2008)

---

Hi,

I am on SQL 2000 and I an having problem with the square parenthesis error on the GROUP BY,. Can sombody help? Thanks.

select [Employee_ID] = EmpID from dbo.Employee group...

sree (2/19/2008)

---

Hi,

I started the refresh of my test database(SQL 2005) with prod using restoration script.I just started restoration script app developer asked me to stop restoration as he made...

Hello Jon,

This is what he...

Shiv (2/19/2008)

---

It wold be of great help if some body can tell me the syntax or the way that i shlould write my select query in bcp command.

Create Procedure BCP_Text_File

(...

Angelindiego (2/18/2008)

---

ok, it posted without my ok...and I wasn't finished...LOL

anyhow, you get the idea...

when I try to set the variables, SQL tells me that I cannot do this. I...

fred (2/18/2008)

---

Thanks for the response, but there is no Visual Studio thats the problem there seems to be no shortcut or executable to run. I have Microsoft SQL Server...

vmavoodu (2/18/2008)

---

HI

i have several sql files (table ,stored procedure files scripts )

etc , i maintain this in vss

i have only one dump of restored databse and i want to...

ezzell.diane (2/14/2008)

---

I am new to the Visual Web Developer and Visual Studio applications. I have a couple of great reports done in Business Intelligence in the Visual Studio, but...

Subba Rao (2/14/2008)

---

Hello All,

I have created few reports and deployed the reports ot Report Server. When i tried to create new subscription(to schedule the report) for the report, i...

Leo Nosovsky (2/14/2008)

---

Does anyone know how to populate a table with the results of RESTORE FILELISTONLY for subsequent querying? Specifically, I need logical file names and their types from a...

Hello Asif,

I'm getting error even though I'm logged in.

The website declined to show this webpage

HTTP 403...

Microsoft...

ross (2/14/2008)

---

Hi All

trust your having a good day.

Quick question, what is the best way to store hours and minutes in a table, not in a time sense, but in a...

riga1966 (2/14/2008)

---

There is a procedure in SQL 2000 that returns two datasets.

I need to insert the output from the second dataset in a table.

How do I jump to the second...

John P Wood (2/14/2008)

---

I have a 'Test' instance which keeps reporting "BACKUP failed to complete the command BACKUP LOG DBxxxxxxx. Check the backup application log for detailed messages." However, the...