vamsi.341

Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

RE: Not able to pass the variable into the Query...Trying to pass the user information into the code to remove the dependencies and drop the users

Thank you Luis for the help..i tweaked the query, now it is working fine.

November 3, 2015 at 4:17 pm

#1837499
RE: Not able to pass the variable into the Query...Trying to pass the user information into the code to remove the dependencies and drop the users

Thanks Luis for your help..
But how do we pass the variables dynamically. can you please help me in rewriting the below code
/****** Object: StoredProcedure [dbo].[sp_delete_user_v1] Script Date: 11/02/2015 16:07:36 ******/
SET...

November 3, 2015 at 12:44 pm

#1837469
RE: Not able to pass the variable into the Query...Trying to pass the user information into the code to remove the dependencies and drop the users

Thank you Luis,
Can you please let me know how to send the parameter dynamically.

November 3, 2015 at 11:20 am

#1837448
RE: Not able to pass the variable into the Query...Trying to pass the user information into the code to remove the dependencies and drop the users

Hi Luis,
If you see the storedprocedure parameters, i am passing the USER as a parameter to the storedprocedure..
I tried using cursor instead of SP_MSForeachDB, same issue it's not accepting the...

November 3, 2015 at 7:56 am

#1837370
RE: Not able to pass the variable into the Query...Trying to pass the user information into the code to remove the dependencies and drop the users

I am trying to implement on SQL 2008, The code is not accepting the variable so was trying different options, it was accepting if i was running against single db...

November 2, 2015 at 2:37 pm

#1837220
RE: Not able to pass the variable into the Query...Trying to pass the user information into the code to remove the dependencies and drop the users

This is what i was trying to do
GO
/****** Object: StoredProcedure [dbo].[sp_delete_user_v1] Script Date: 11/02/2015 16:07:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:<Author,,Name>
-- Create date: <Create Date,,>
--...

November 2, 2015 at 2:08 pm

#1837209
RE: Not able to pass the variable into the Query...Trying to pass the user information into the code to remove the dependencies and drop the users

i have tried passing this variable using a stored procedure, as it didn't work i have manually passed the variable once i declared the variable.
Either way it's not recognizing...

November 2, 2015 at 1:16 pm

#1837195
RE: Can we restore SQL 2000 master db to sql 2005 mster db

as far as i understand now,
The build of server 2005 is different from sql 2000.
that is the reason for we can't copy master db.
Another Reason: sql 2005 has a new...

February 13, 2011 at 3:05 am

#1286120
RE: Can we restore SQL 2000 master db to sql 2005 mster db

Thanks all for replies
why can't we restore Sql 2000 Master db to sql 2005 db?
is it because sql 2000 architecture different from sql 2005.
can i know the reason why we...

February 13, 2011 at 1:58 am

#1286118

Viewing 9 posts - 1 through 9 (of 9 total)