Hi everyone,

we've had the same issue on a 2-node cluster. On 1 node everything runs fine but as soon as everything fails to the other node we encounter this issue...

Oops sorry Ruan, I assumed that tempdb had grown to that size. Sounds like the initial size for the data file is set to 9GB. Also, it sounds like there...

Hi Ruan,

tempdb gets rebuilt everytime the SQL Server service starts up, meaning that it will reset the file to the initial size it was set up for. The problem with...

Sorry Richard, I misunderstood.

You're quite right, by adding components you don't necessarily have to re-apply the Service Pack to the Database Engine instance, although you still need to apply the...

Only a pleasure mate! Let me know if it works with the foreign key!

The error sounds like the query can't be parsed. If you run the query in Query Analyzer does it return results? If so, please script the table and post it...

Ouch, your database has inconsistency errors and you'll more than likely find that some of your data is corrupt. Have you got backups of the DB that you can restore?

Hi Babu,

yes there is a way to programmatically do this. Have a look at the DTSPackage Object Library - the DTS.Package object has a collection property for connections.

HTH 🙂

Hi Phillip,

would it not be better to replace the trigger with a foreign key reference to tblInProductLine? Is there a specific reason for having the trigger rather than a FK?

Hi Vishnu,

There are numerous ways and products available to assist with archiving data (even on Express Edition). The most important thing to remember though is that there isn't one product/technology...

Sounds like your DB is not in an online state... Have you looked at the SQL Server error logs? Do you have working backups of your DBs?

Run this select [name],...

Hi,

is the Oracle instance you are querying running on Windows? If so, the default in Windows Server 2003 R2 + is to disable support for remote transactions. See http://support.microsoft.com/kb/817064 for...

Hi,

the list of servers returned by sqlcmd -L isn't guaranteed to be the same every time it's run (refer to BOL...).

Are you running this command on the same server where...

Hi Kim,

Although it is possible to setup an SMTP relay server using IIS, the issue is that the SMTP server will have to relay to your Exchange server again (adding...

Hi Mirde,

you are correct - run the SQL Server setup and add SSRS. Once that is done you can install SP2, that should automatically detect which of the components haven't...