So basically all I need to do is,

CREATE INDEX IX_vw_Test ON dbo.vw_Test

Thanks Matt.

Y'll input is much appreciated.

Thanks Matt.

No I don't have any CLR functions and yes they all are scalar functions. None of them are database dependent.

e.g. I have a function called LCD which calculates a...

I normally use the following and it works well.

USE [DatabaseName]

GO

DBCC SHRINKFILE (N'LogFileLogicalName' , 0, TRUNCATEONLY)

GO

So let me get this right.

I create a function called Blah in the master database and rather than calling that function if it was in the same database like dbo.Blah(),...

TA MATE 🙂

Yes it's possible.

I am not sure what were the errors but I had some problems after installation about starting the server and browsing the databases.

If I remember correctly I setup...

Thanks Matt,

Only thing confused me was your reply

I assume you mean if I add them to Model...

Cool thanks Jason.

I will start adding them to the Model database.

As for the changes I will have to write some sort of script to propagate them to all the databases.

And...

As Sameer explained it's not possible but in future (also suggested) you should have Auditing fields in each table.

I normally have 4 fields in each table.

[UserCreated] [varchar](16) NOT NULL

[DateCreated] [datetime]...

$sanjayattray (3/18/2008)

---

Use master

declare @DBName varchar(35),

@STR varchar (255)

declare DBRecoveryModelGenerator_cursor cursor for

select name from sysdatabases

where...

Greg Charles (3/18/2008)

---

I've been using this query:

select recovery_model_desc from sys.databases where name = 'master'

The sys.databases view is in every database.

I guess you could post your statement in the "Scripts" section....

Thanks both.

No I don't need to run the same query all the time.

Basically user gets a combobox selection of what kind of data to download and then when...

Thanks for the quick reply Jeff. Here is it.

SELECT A.PersonId, A.Name, A.Address1, A.Address2, B.TotalOrders FROM Person A LEFT JOIN qry_PersonOrders B ON A.PersonID = B.PersonId

OK with minor changes it's working now.

DECLARE @WebPageName VARCHAR(100)
DECLARE @ParentPageId INT
DECLARE @WebPageId INT
--
SET @WebPageName = 'aus_young_matildas_news_feat_news_item'
SET @ParentPageId = 0
SET @WebPageId = 0
--
SELECT @WebPageId = Webpageid FROM WebPage WHERE Name =...