asm1212 (5/26/2011)

---

Im not worried about the schema...The schema's are pretty much the same on both servers...there is just dummy data in test and he wants the real data from...

sounds like the...

Gopal Singh (5/26/2011)

---

Hello,

When I create table as per code data is inserted in first successfully as ENG_REF value Engg0000000000 but when i insert in second row it showing an error...

Gopal Singh (5/26/2011)

---

but i need this value can gone upto 4-5 million times, so can take datatype varchar(50) to varchar(max), then might it will allow me to enter increased the...

based on what David showed, i'd just make the column calculated based on the identity instead of using a trigger:

I don't know if you want preceedig zeros, or if Engg4592...

kr.nithin (5/26/2011)

---

Hi,

I have an issue . The issue is that I need to retrieve data such that Travel Date should be greater than the current date. But my problem is...

blocked at my job too....

uhh..no.

intellisense as well as syntax highlighting are contained in a DLL called from the client app of...

lots and lots of script contributions here on the site:

http://www.sqlservercentral.com/search/?q=script+roles

also search fro "script permissions", lots of nice examples of that as well.

the OP asked in a PM how I had done my stored proc i referenced; I'm posting it here to add fuel to the fire; others might have some ideas...

I've created a stored procedure featuring EXECUTE AS that allows an end user to Create a Database, which then adds roles to that database, and finally adds the calling user...

opc.three (5/25/2011)

---

Just eyeballing your code so forgive me if this is a rabbit hole but I think if client_net_address is NULL then you end up with something that will anger...

huh?

maybe a copy/paste error?

EVERY statement you posted is making the Question1 field equal to a count of the persons name?

it looks like the sub query gets a total, and has...

ok, following up here, i created a server trigger, and a user with the same name as the OP for testing.

I'm gathering info based on this snippet to get the...

the columns in the table and the columns in the BULK insert must match exactly, with no extra or missing columns....unless you use a format file.

you can use OPENROWSET to...