Hi macphil

This is a huge undertaking to upgrade both the version and the architecture (32 -> 64) at the same time as well as windows.

If I were you and I...

I did find why !!! ($%?%&$)

I don't recall anyone saying this on any post. (Or maybe I read them too fast :Whistling: )

On the file system task, the property "DelayValidation"...

I'm not sure about this if it could be your problem specifically but do you have the appropriate privileges to do modifications?

What I mean by that is, upon reboot, some...

Of course!

Here they are! I hope these will help you help me 🙂

Forgot to add: Expressions tabs are always empty therefore I did not include any screenshot of those

I know this post is old but I would like to add what was the cause of

Error: 3041, Severity: 16, State: 1.

BACKUP failed to complete the command BACKUP DATABASE XYZ....

That feature does not exist built-in SSMS

What you can do is set proper database permissions at the login level. The user who connect through SSMS will see all the...

When you buy the book, a softcopy comes along (a PDF file) but I don't know if you can buy it without buying the hard one.

Hi

It depends on how far you want to administer / know a SQL Server box.

For a well rounded tour of SQL this book will do it well:

http://www.microsoft.com/learning/en/us/Books/9364.aspx

One way to do Agent tasks similar to other SQL edition would be to use windows scheduled task using the sqlcmd executable. Not very pretty but that does the job.

Thank you for the answer.

Do you happen to know what windows do under the cover with memory management for both option?

Most of the server are 32 bits and they should not run anything else beside SQL. No IA64 for sure at the moment.

Most of the servers will only host the...

You won't if you don't use special version feature like the ONLINE keyword in 2k5 which is available in enterprise and developer only. I do suspect that there's might be...

Ok I've found something

Two-Phase Commit

Committing a distributed transaction occurs in two phases: prepare and commit. When a marked transaction is committed, the commit log record for each database in the...

I did encounter this issue not a long time ago.

The backup is done via Veritas software (netbackup I believe) 10d which is a old software (they are up to version...

Each time you post on the forum you get a point, could be the reason.

Or it also could be to let a positive feedback for the author. Always feel good...