Thanks much. It helped 🙂

[/quote]Do you want that whenever ANY try block get failed due to any reason , the stmt in catch get fired ? i dont think so. Why can't you use...

Evil Kraig F (10/10/2012)

---

Out of curiousity, what drove this question? If you're trying to cure an issue and it led you to that question, I'd recommend you describe that...

I quickly made an example.. seems like its true..

However, was looking for any MSDN link..?

CREATE TABLE #Employee

(

EmpId int identity(1,1)

,EmpFirstName varchar(100)

,EmpLastName varchar(100)

,Empdept varchar(50)

)

INSERT...

Thanks.

Was just checking the script and the select gives desired output..

But to delete them again a dynaminc SQL?

yea, this script works perfect in my env. ...

But the only glitch is to delete users from all db (in all we have 20 db each server and 200 servers!!!)...

I have made script that deletes all the users, roles from a single DB.

The current script itself uses loop to delete users/roles. When i loop for DB name all i...

HowardW (5/21/2012)

---

It's not to do with permissions. In modern versions of Windows, you can't interact with the UI associated with the SQL Server Service Process - remember that XP_CMDSHELL is...

Eugene Elutin (5/21/2012)

---

khushbu (5/21/2012)

---

Eugene Elutin (5/21/2012)

---

khushbu (5/21/2012)

---

I already tried this .. strangely nothing happens and query...

Eugene Elutin (5/21/2012)

---

khushbu (5/21/2012)

---

I already tried this .. strangely nothing happens and query keep on executing...

I already tried this .. strangely nothing happens and query keep on executing .. and after...

ALZDBA (5/9/2012)

---

did you try to execute your package from Powershell_ISE , PowerGUI or PowerSE (which are all free tools)

Which version of powershell / SQLserver are you using ?

Apparently you didn't...

Yeah have tried all of these method but none of them is clear...

Yea.. Indexes is something my next problem is now..

There are few columns that are part of index, how can i calculate (even approx) space for them?

How about using DATALENGTH?

Do you think it should be more good than stats DMV?

declare @v1 varchar(10),@v2 nvarchar (10)

set @v1= '885'

set @v2= '885'

select DATALENGTH (@v1) as varchar1

select DATALENGTH (@v2) as nvarchar1

select...