Thank you for the reply. I can change the destination manager value ok but can you please let me know how I would...

Hello, I have read your replies and looked at the link so hopefully I have the cause of the SEEK / SCAN action clear???

When passing in a NVarchar to be...

thanks for the reply, for my own reference I am trying to understand how this would make any difference in the way the index is seeked or scanned.

thanks for the help. Even after doing this job for a while I am still learning simple things.

For anybody else, as was suggested by the previous poster this works fine.

Takes a second to run.

thanks for the reply. From your experience this is safe to use and has not caused any issues that you know of?

thanks for the reply -- SQL 2008 -- therefore I was incorrect in suggesting the licensing has changed for this edition of SQL

Thank you, so obvious!!!

I was in Master and was trying the following to get my renaming to work:

ALTER DATABASE [MyDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

ALTER DATABASE oldName MODIFY NAME =...

yes, that is correct. A process blew the log file out and the database was big so I could not just change it to Simple model or truncate the log...

I have run the code below on the temp db.

SELECT * FROM sys.dm_io_virtual_file_stats(DB_ID(N'tempdb'),null);

The output shows it has had activity on both tempdb datafiles (ID 1 & 3)

Do you know if...

and this round robin pattern is for both TempDB data files and also the log files (if their were multiple log files of course).

I already have two tempdb data files set up on the main server. Each on a separate disk and each the same size.

I have my doubts as to how...

Hello, thank you for all the replies.

I have found the issue and like a lot of problems the answer is simple and obvious.

The cause of the difference between running the...

it should be and was "Select C1.[CUSTOMER_ID]" -- a typo on my behalf here.

The last line on the ad-hoc statement (code inside the view run from SSMS) would normally be "where c1.deleted = 0 and C1.CUSTOMER_ID = 123" and when running the VIEW...