Viewing 15 posts - 31 through 45 (of 97 total)
errors:
1. The process could not execute 'sp_replcmds' on 'domain\2k8'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
2· Cannot execute as the database principal because the principal "dbo" does...
March 11, 2010 at 2:35 pm
i think no. we must give some permissions to master database to the remote user on remote server. before giving the permission to master database i.e. RsExecRole etc., i...
March 5, 2010 at 5:42 am
hello lmu92,
i have wasted lot of time and struggled for this logic. finally i got the solution which was same as you said. but i didn't mention like...
March 4, 2010 at 9:54 am
i tried with CTE. it works. but, is it a good idea to keep this in a sp which is used by a Big application. because the below query(CTE) will...
March 4, 2010 at 4:55 am
ramesh thanks for the reply
select ( case
when CHARINDEX('%',permissionval)<>0 then SUBSTRING(permissionval,1,CHARINDEX('%',permissionval)-1)
...
March 4, 2010 at 4:06 am
using the below query
select adminpermission from appadmin where addId=1
i will get two or more unique values and i need to use all these values.
how can i handle now?
Thanks
Rock..
March 4, 2010 at 12:15 am
after changing to [Sheet1$] also i am getting the same error
for ex: select * from test.[Sheet1$];
SQL Error: ORA-00942: table or view does not exist
March 1, 2010 at 1:55 am
here is the scenario, i have many child tables with one common field called userid
And one parent table i.e user table.
here i will create a foreign keys in child...
December 31, 2009 at 3:06 am
hi sturner,
Thank you. one more thing,What happens when first update statement succeed,second one fails and...
December 21, 2009 at 7:14 am
Thank you very much Jack Corbett.
November 10, 2009 at 9:52 am
i resolved the error.
can you tell me the reason,why it is not working properly with convert of datetime to a mmddyyyy, is there any specific reason for that?
Thanks
Rock...
November 9, 2009 at 11:22 pm
hi Jack Corbett
you are correct.
select * from a where col>='2008-01-01'and col<'2008-10-10'
it is working fine. getting values as per the requirement.
can you tell me the reason,why it is not...
November 9, 2009 at 11:07 pm
sorry, i didn't get your point
can you give me an example..
Thanks
Rock...
November 6, 2009 at 5:22 am
actually i need to use two procedures
procedure-1:
ALTER PROC TESTPROC
(@VAR NVARCHAR(max) OUTPUT)
AS
BEGIN
declare @tab table( data nvarchar(max)
insert into @tab SELECT empno from emp where sal >10000;
select @VAR=...
November 6, 2009 at 3:58 am
how can i pass multiple values into a variable
ex:
ALTER PROC TESTPROC
(@VAR NVARCHAR(max) OUTPUT)
AS
BEGIN
SELECT @VAR= empname from emp where sal >10000;
END
/*declare @VAR NVARCHAR(MAX)
execute TESTPROC @VAR output
*/
November 6, 2009 at 1:43 am
Viewing 15 posts - 31 through 45 (of 97 total)