Not being stupid right to raise your concern but them accounts are created for the service regaurdless of the account which runs them. It does this so that you...

Bhuvnesh (11/20/2012)

---

anthony.green (11/20/2012)

---

Bhuvnesh (11/20/2012)

---

tonyarp05 61903 (11/20/2012)

---

We are developing one tool(Backend : SQL server), that tool should be search the string from entire database.

But i have some codes,which takes min 30...

Any it does not matter as it will execute the procedure in every database you have in sys.databases unless you specifically exlcude it in the exclusions list.

Uncomment the SELECT @sql...

Use my code, the only thing you need to do is to replace the the text schema.procedure with the name of your procedure eg. dbo.thisismyprocedure

Then remove the spaces between the...

Bhuvnesh (11/20/2012)

---

tonyarp05 61903 (11/20/2012)

---

We are developing one tool(Backend : SQL server), that tool should be search the string from entire database.

But i have some codes,which takes min 30 to 45mins.

Even...

Another way would be to use the following code

DECLARE @sql NVARCHAR(MAX)

SELECT @sql =

REPLACE(

CAST(

(

SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +

'EXECUTE schema.procedure;'+CHAR(13)+CHAR(10)

FROM sys.databases WHERE name NOT IN...

No, as I have said what you are wanting to to is very costly in performance as it uses so many resources to look through each table and each column...

There is no way to enforce a naming convention when your typing code but you can enforce object names where you have to create a table using a prefix for...

Not a problem, happy to help.

Does the same procedure exist in all 20 databases and does it need any special paramateres to run?

TARFU

I am guessing the login once existed and you set it to remember the username and password? If so you need to remove the following file and then restart...

bommaka.nagarjun (11/19/2012)

---

Hi ,

If i set my Txn log backup frequency for 15 mins, what is the worse data loss? Is it for 14 mins 59 Secs? (Assuming disaster happens immediately...

First off why do your users have access to backup the database? I would strongly recommend reviewing your permissions and working from the ground up on least amount of...

IgorMi (11/20/2012)

---

Except the collation, your code...