marees.inspire (5/14/2009)

---

Hi Al,

getting the error

"Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for

OLE DB provider "SQLNCLI10" for linked server "LinkedServer".

The provider supports the interface, but returns a failure code...

Can you please explain why..? (bcse it needs to expand it everytime.?). I do shrink log regulerly. Please suggest me a...

Let me know this one ---- Suppose my DB gets corrupted(after taking the backup)? For restoring the database which files i required to have? Is the backup file *.bak is...

It doesn't come in profiler when executed from APPLICATION (Col Fusion). That's the problem.

What about SQL debugger in VS-2005/2008..?

Thanks..

...And once you make a column as identity, no need to supply any value for that column while inserting.....

But this is not what i want. I just want to know all the rights granted to the user like create database or create table, etc when ID/Name is passed....

gaurav (4/29/2009)

---

I had created a table with primary key named 'qId'.

when it was created the identity was 'no' (false).

because of that i am unable to insert any data...

You're doing this in Management Studio? Are you connecting to an instance on your local machine or on a network server? Try looking on the "Network Servers" tab rather than...

I am not sure....still you can try with below query.

Hope GROP BY wont make any diference.

SELECT [Job Date], NextBusinessDay, Branch, [Deliver Time], [Job Type]

, [Company Name], [Site Location]

, Equipment=case

when ...

try the below query...

declare @var1 varcahr(300)

set @var1=tablename from firsttable;

declare @qry nVarchar(500)

Set @qry='select column1'+'_'+'column2 from'+@var1'

exec(@qry)

by the way it's...

Update A

Set A.statutSpecifique=B.dpStatut

From table1 A

Inner Join @tempTableStatutDp B On A.id=B.dpId

You can take the result of first query into a variable (@tbname).

Make dynamic query for the...

Why you want it that way ..?. If you want it for reporting purpose, you can do it in front end application.

Thanks Chirag, this is wot exaclty I wanted.

Cheers.

Thank you somuch Gila. Think this is I what I was looing for.

I will go thru it..