Jeetendra

I tried once to write a script that would generate scripts for all indexes in a database, but I gave up.  I'm not saying it isn't possible - search the...

Jeetendra

You can either do them one by one in Enterprise Manager (let me know if you need me to explain how), or you can script out all your non-clustered indexes,...

Patrik

As far as I can tell, Logged Value corresponds to ml.MeasurementLogValue.  But what to Calc1 and Calc2 correspond to?

John

What happens if you run the job not at 1am (I assume that's what you mean by 1pm in the morning), but at the same time you try to run...

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