Table report : how to hide null values ?

Hi We have a report showing the customers with outstanding invoices. But he's showing all customers…

One of my servers crashed due to power fluctuations. I have the full and Differential backup files …

backup n restore commands using Redgate

hi, We are using redgate n litespeed tools for backup n restores. could you please give me the scri…

Replication without snapshot

DB Experts, Need help on something. We have Transactional replication setup at my organization that…

Table name

Hi there My hosting provider has created a table name starting with numbers if u do normal query it…

Error control and transaction handling (please correct me)

Hi Everyone I have a code here which for some reason branches to the GOTO statement, I think there …

SQL Query Analyzer Output Result to nul:

In "SQL Query Analyzer" any version, Results in Grid How to get make any [SELECT] not to display i…

Aliasing parameters in SSIS

[font="Tahoma"]I am using an OLE DB command in SSIS for which the SQL command looks like this: [/fo…

SSIS Script component, Script Task and project References

Hello everyone, I have some functions in VB.net that I always use in my packages, So i need to cre…

How to track all error in the trigger then save those error in a table

Hi Everyone, Just a quick question hope you can share some light on it. How can i track all error i…

Union query not giving correct resultset

I’ve a question. I’m trying to execute a union query in Oracle10g. I was able to run the query but,…

SSIS T-SQL task connection manager not available

In SQL 2005 SSIS. when i try to create t-SQL task, connection manager is not available , even i hav…

Color changes on export to pdf

I have a report in SQL Server 2005 Reporting Services which is using custom colors for company bran…

Startup Parameters -m -c -T3608

I get the following error when I try to detach the model database. System databases master, model, …

Re-keying Encrypted Column

Our industry requires rekeying encrypted data once a year. When the server / database was built, t…