Viewing 15 posts - 7,516 through 7,530 (of 13,469 total)
asm1212 (5/26/2011)
May 26, 2011 at 2:03 pm
asm1212 (5/26/2011)
I have done that however, he doesnt want to copy over the sp's and other objects, he just wants the data...also our backups are only on tape...
sounds like the...
May 26, 2011 at 1:06 pm
Gopal Singh (5/26/2011)
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...
May 26, 2011 at 11:11 am
Gopal Singh (5/26/2011)
May 26, 2011 at 9:35 am
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...
May 26, 2011 at 9:21 am
kr.nithin (5/26/2011)
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...
May 26, 2011 at 7:24 am
sqlzealot-81 (5/26/2011)
Not many organizations support picassa...Sorry...
blocked at my job too....
May 26, 2011 at 6:33 am
Sumanta Roy (5/26/2011)
Please restart your sql server and check if it works.
uhh..no.
intellisense as well as syntax highlighting are contained in a DLL called from the client app of...
May 26, 2011 at 5:10 am
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.
May 26, 2011 at 5:03 am
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...
May 25, 2011 at 4:48 pm
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...
May 25, 2011 at 2:18 pm
opc.three (5/25/2011)
May 25, 2011 at 1:33 pm
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...
May 25, 2011 at 1:12 pm
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...
May 25, 2011 at 12:12 pm
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...
May 25, 2011 at 9:57 am
Viewing 15 posts - 7,516 through 7,530 (of 13,469 total)