James

You won't get much response by tagging your question on the end of a year-old thread.  Much better to start a new one.

John

I imagine that it's being interpreted as three values: ABC, 50, and 9.  What error message are you getting?

John

Arthur

Not as far as I know.  Although you could change the view to a stored procedure, and put some conditional logic in that.

John

I take it we're talking about a stored procedure here?  If so, just use sp_recompile.

John

Nadeem

You haven't really provided enough information.  Do you always need the results from the same set of stores, or is it different each time?  If the stores vary, then is...

Dharmendra

Have the stored procedure print the query, then copy and paste it into the query window, and post the query and the estimated execution plan here (please preview your post...

Dharmendra

Please will you add a PRINT @sQuery1 statement to your stored procedure, then run it and post @sQuery and @sQuery1 so that we can have a go at debugging it. ...

Andre

Script out all your views that reference the changed tables, then use the Replace feature in SSMS to search for "procdta." and replace it to "crpdta.". Of course if only...

Mark

Either (a) create a temp table, insert the results for each database into it and then select them all, or (b) qualify the view name thus: MyDB.INFORMATION_SCHEMA.COLUMNS and use UNION...

Steve

You need to enable auditing.  You can audit successful logins, failed logins, or both.  Search for audit logins in Books Online.

If you don't have auditing enabled yet and you need...

You can get the information you're looking for from the INFORMATION_SCHEMA.TABLES view.

John

SELECT [name] FROM sysobjects

WHERE uid = USER_ID('User_to_be_dropped')

This will give you a list of objects owned by that user.  You will then have to decide whether to drop...

Magic!  Ron, you're a genius.  I ran process mon and I noticed that I had an invalid path for sqlagent.out.  I changed that in the registry and it worked.  Thanks...

Thanks for the tip, Ron.  I'll try that and let you know how I get on.

John

Frances

Without an explanation of how the actual result set differs from the anticipated one, never mind any DDL or sample data, it's difficult to help you.  However, I don't think...