Thanks - I thought you could do it in the MOSS 2007 version too..but it appears from the replies it just the 2010 Sharepoint version.

Thanks for the clarification.

Thanks I will look at the script. The Location may not be this word if maybe just Area without Location ..basically I would not know what is after SITE...

The replace command is adding the additional space the later text must be in the same position. If it starts on position 30 and I add an additional...

Worked a treat and replaced it anywhere it found it in the string.

Thank you so much got a hugh update to do.

What does the 1 mean ?

(CHARINDEX('00001', column, 1)

that gives servername i want to make all connections coming in to servera to actual go to servera_realname almost like an alias.

Let me look at the role and see the permissions. Thanks

What system tables is this perhaps i could write a query to see the create table rights

Thanks everyone for your advice..I am going through this long task. I will not delete the log each time as you mentioned as it keeps filling up. ...

Right now I have the following

There are approx 133095 rows per day.

DELETE TOP(100000)

FROM tablename WHERE

startdate >= '2009-12-17' and

startdate <= '2009-12-17'

Then this uses approx 10 GIG of Log space...

The database is in simple mode.

Declare @num int

Set @num = 1 -- force it into loop first time (or could do count of no of records to be deleted...

That is how much trans log it is filling up with each time it deletes the records.

I could try the crawler will it then only do the log...

Thanks I thought once you updated statistics for sql 2005 90 mode database the statistics still be in the system files.

Installed SQL 2008 and moved DB from SQL 2005 which as 80 Mode as not updated to 90. Application itself was clever enough to say can't run on SQL...

Thanks for the example.

declare @filename nvarchar(100)

set @filename = 'c:\test.' + convert(varchar(10),getdate(),102) + '.xls'

print @filename

Then examples of using bcp or rowset

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926