The INFORMATION_SCHEMA views won't give you that information. You need to look at sys.columns to determine if it is an identity column.

Someone with admin rights, that much I can tell you. Not sure of the default trace would capture who, but I'd start there. There is a function in...

May I suggest that you read the first article I have linked in my signature block below? If you follow the guidelines presented in the article when asking for...

Yes, you are welcome also.

I have written enough dynamic sql that I've been bitten by that error many times. I have learned to look for it.

Pretentious aren't we. GSquared pointed you in the direction you need to go, try writing it yourself first. If you have problems, come back with what...

One last change to the code provided by GSquared:

CREATE PROCEDURE sp_GetTasks

@colname nvarchar(50),

@colvalue int

AS

BEGIN

if not exists

(select *

...

Well, with only a description of your problem, you probably won't get many useful responses. Please read the first article I have referenced below in my signature block regarding...

Before anyone starts doing your work for you, would you please show us what you have done so far to meet your requirements? What problems are you having with...

Based solely on your post the following code works:

create table #TestTable(

vai1 int,

vai2 varchar(50)

);

insert into #TestTable

select 1,'1234,578';

select

right(vai2, len(vai2) -...

Looks like you have everything you need. Here is my test code based on your post.

create table #TestTable (

DateStamp nvarchar(50),

HireDate ...

r.hensbergen (1/20/2009)

---

When you want to use a variable in a SQL statement, you need to do this a bit different:

CREATE PROCEDURE sp_GetTasks

@colname nvarchar(50),

...

To do what you are trying to accomplish, you will need to use dynamic sql. Based solely on the code you provided I see it as very dangerous as...

You may want to look into moving tempdb to its own disk drive (or set of disk drives). You can find instructions on moving tempdb in BOL. Shrinking...

Nope, replication has been around for quite awhile. I think I first "played" with it to see how it worked in SQL Server 7.0 but I never went beyond...

tevers (1/19/2009)

---

So that's how outsourcing works!! The project goes to India and someone posts it as a question and then sends the answer back. Although I think they...