durai nagarajan (3/1/2012)

---

use this to fetch DB Names

Select name from sys.databases

where name like 'xx%'

and run your view or procedures using "use DBNAME and query".

can we know what are you trying...

DECLARE @grantExecute varchar(8000)

select @grantExecute = 'IF ''?'' NOT IN(''master'', ''model'', ''msdb'', ''tempdb'') BEGIN USE [?]

GRANT EXECUTE ON [dbo].[Storedprocedurename]...

Ivan Mohapatra (2/27/2012)

---

anthony.green (2/27/2012)

---

take a look at an undocumented function called sp_msforeachdb, this will allow you to execute the same query in all databases including master model msdb and tempdb...

anthony.green (2/27/2012)

---

take a look at an undocumented function called sp_msforeachdb, this will allow you to execute the same query in all databases including master model msdb and tempdb so you...

anthony.green (2/27/2012)

---

you will need to build in a link to the system catalogs for schemas and users as they will be different in each do and then pass the values...

anthony.green (2/27/2012)

---

you just need to grant execute on the schema in question

so if everything is in the DBO schema you would do

GRANT EXECUTE ON SCHEMA::dbo TO ixxxxxx

you could also create...

Welsh Corgi (1/12/2012)

---

I'm moving a Database Server to a new Machine.

The machine has SQL Server 2005 SP3 Standard Edition

They do not want to go to a new SP

The product version...

THANKS

(michael.kaufmann & jnuqui) After modifying the final script which i have tested in a small DB it work fine and still yet to be tested in big...

michael.kaufmann (1/12/2012)

---

Ivan Mohapatra (1/12/2012)

---

Steve Jones - SSC Editor (1/9/2012)

---

Use a script like this: http://www.sqlservercentral.com/scripts/Miscellaneous/65769/

Change the where from a "column like @value" to "datalength(column) = 9"

If you want 9 digit values....

Steve Jones - SSC Editor (1/9/2012)

---

Use a script like this: http://www.sqlservercentral.com/scripts/Miscellaneous/65769/

Change the where from a "column like @value" to "datalength(column) = 9"

If you want 9 digit values.

You think you're...

Dev (1/10/2012)

---

Ivan Mohapatra (1/9/2012)

---

Dev (1/9/2012)

---

Agree with Sean. It’s not like regular requirements that we get from management. For instance, if a table has 2 rows and...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROC [dbo].[SearchAllTablesAllColumns]

(

@SearchStr nvarchar(100)

)

AS

BEGIN

CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(255),...

Sean Lange (1/9/2012)

---

OK we are now 20 posts into your request and the details of what you want is still changing with each post. We can't see over your shoulder,...

Steve Jones - SSC Editor (1/9/2012)

---

Ivan Mohapatra (1/9/2012)

---

Well the point of discussion is to have a script by which i can get all the column name and table name in...

Dev (1/9/2012)

---

Agree with Sean. It’s not like regular requirements that we get from management. For instance, if a table has 2 rows and one of the columns have...