Is this going to be an ongoing process or is it just a one-off?

arooj300 (5/15/2013)

---

Hi,

I am new in SQL Server. I have a database whose size is almost 25 GB, there log size 18 GB and mdf file is 6.30 GB, and everyday...

You may find that the Intellisense that comes with SQL 2008 ain't that great.

ApexSQL do a free Intellisense AddIn for SSMS. One to try, if you like.

Apples and Oranges is right as they are indeed different but don't let that stop you picking it up if you'd like to as it is pretty much "data access"...

Your code run as a batch should work.

I think what you are probably doing is highlighting and running the statements individually which would reproduce the error you are getting.

Marcus Farrugia (5/1/2013)

---

Thanks Lynne!

if there were multiple columns...

Krishna1 (4/30/2013)

---

Hi

I am uisng following code. How do create a table for insert into when 2 resul sets are differnt? Please advice.

CREATE procedure PROC1 as

begin

Select 'aaa',1

select 1,2.22,'xxx'

end

go

DROP PROCEDURE PROC2

go

Create procedure...

Krishna1 (4/30/2013)

---

Dear All

I have one procedure PROC1 wich resturn multiple result sets. No of coulmn and Datatype of the result set are not same.

I want to access the result of...

Just something else you can also do if joining that many tables is all new to you.

You can join say the first two tables then check the output and then...

ssmith 29602 (3/28/2013)

---

Hi,

I've got a SQL Server 2008 job which ran ok yesterday but has fail today with an error message ' Error authenticating proxy'. The only thing that has...

TheGlossBoss (3/27/2013)

---

I need to create a query that will execute for 20 minutes or more so that connectivity and redundancy can be tested on the SAN. Any suggestions will...

denis.gendera (3/20/2013)

---

All,

I'm having strange issue trying to do the following which I thought was just going to be straight forward

select top 5 machine.name, machine.model, machine.scantime

'INSERT INTO [SMS_000].[dbo].[BMCMachines] ([ComputerName],[MachineModel],[stime])...

mberman (3/19/2013)

---

Thank you for your replies. The information was right on.

I created a scratch table in the database (orders_del) that is just being used to hold the order#'s to...

This made me laugh 🙂 Very funny.

Just to clarify I meant the OLE DB Sql Command is run for every qualifying row not every row

I would add that the times I have seen the OLE DB...