Is that all of the error information that you have?

I'm not too clear what what you have done and why.

Here is a thread where someone got a similar error. I...

I keep asking you for a little information but you don't provide and you keep comming back with questions.

Are you pulling my leg?:w00t:

http://www.sqlservercentral.com/articles/Best+Practices/61537

vultar (5/20/2011)

---

Say for example, you have 10 dbs spread across 10 servers (1 on each). A consolidated server could mean all 10 of these dbs sit on the same server....

All that is required is to create a Julian Date Function:

http://www.sqlservercentral.com/Forums/Topic438807-8-1.aspx

Sounds like a permissions issue.

When "connecting to any of our SQL instances via name in SSMS" What credentials is she using?

Have you checked her login and user account for the...

You tell me, you know your business.

prashantcomp90 (5/10/2011)

---

please give me solution for this problem. How I can...

Welsh Corgi (5/19/2011)

---

How did you come up with that?

I guess you have it...

How did you come up with that?

I guess you have it all figured...

Yes but I need...

king_emperor_in (5/19/2011)

---

Well I can only move TEMPDB database point to a different drive only if i am on a single user mode right?

The instance on which i want to perform...

No I don't think that is what...

prashantcomp90 (5/19/2011)

---

Thanks for information.

table

create table group

(

id numeric(25),

accnm varchar(100),

grpnm varchar(100),

supergrp varchar(100),

debitamt numeric(20),

creditamt numeric(20)

)

insert into group(id,accnm,grpnm,supergrp,debitamt,creditamt)

select 1,'abc','cash','Assets',10,10

select 2,'pqr','bank','Assets',20,20

select 3,'xyz','ss','Liability',30,30

select 4,'qq','loan','Liability', 40,40

now, i want to group by supergrp column to sort...

king_emperor_in (5/19/2011)

---

Thanks for the reply, but i am able to do that, sqlcmd works fine for me.

does this mean that i have to type "sqlservr.exe -m" after i type in...

thbaig1 (5/19/2011)

---

Welsh Corgi (5/19/2011)

---

thbaig1 (5/19/2011)

---

Hi ,

@col_name= column name coming rom cursor

@ColValue= will store column value

select @ColValue=@col_name

from dbo.tblBlo

WHERE Customer_no = @CustomerNumber

...

prashantcomp90 (5/19/2011)

---

see forget about my last posts

I tell u from beginning.

I have one table name as ledger

in that column names are :

id,accnm, grpnm,supergrp,debitamt,creditamt.

now when i save data in ledger...