Thanks Todd,

I've had a quick look and should be able to get what I'm after. Naturally though the server's started behaving itself so i might never get to the...

I'm really lucky in that our company has a good policy on training and we generally have quite a healthy budget. The only difficulty I have is when I...

But aren't you trying to convert it to an integer in the code you supplied rather than a numeric data type?

Granted you'll still get the error but if you run...

Have you got PAE (physical address extension) enabled in the boot.ini file? I'm assuming this is a 32-bit server.

MichaelJasson (7/8/2009)

---

... Take a scenario where we have 8 GB memory. My OS is 32 bit and sql server application is also 32 bit.

Sql server application will be able...

What you need to determine is what operating system you're running. If you're running a 64-bit OS then that will be able to address all of the 16GB of...

I'm going to echo what Jeffrey said. We've run into this problem ourselves on numerous occassions and it's because the linked server is configured to use the "login's current...

Security considerations. Time after time I get databases come to me with instructions on how to deliver the various database objects, but no consideration on how users are actually...

You can reassign the dbo user to another login or your choice using the sp_changedbowner stored procedure. This should then remove the "eu\genetica" user from the database. Make...

You can create aliases for your SQL Server instances. This is done through the SQL Server Configuration Manager so if you wanted you could create an alias called SQLSVR2005...

I've only ever backed up to a single file when taking short-term baselines of environments.

But as a general rule it's back up each of my databases to their own individual...

It does sound permission related. Check the properties of the backup directory on your server and make sure the SYSTEM account has at least write permissions.

Also make sure you're...

Brilliant article! I'm due to configure kerberos authentication early next year on one of our servers to shore up security, and this helps clear up a few queries I...

It depends on your requirements. If you need to ensure that there is minimal latency between the time that your publication database is updated to the subscription database receiving...

In which case you need to establish whether it needs to be in full recovery mode, and if so then set up some transaction log backups on a regular basis.