Update Trigger - Keep Old value unchanged for a column - using UPDATED and DELETED temp tables, how can I override the new value and keep the old value for a...
How to Move MS SQL Cluster to Standalone - Hi We need to move MS SQL Cluster to Standalone SQL Server, what are the steps we need to follow & how...
Default constraints OR INSERT trigger for Audit columns (create date time/user) - Which is the best practice to implement in audit columns for create datetime and create user, INSERT trigger or default...
sp_send_dbmail - Error when passing @query parameter. - Hi All, When I send mail using "sp_send_dbmail" it works fine. But it fails when I set "@query" paramerter, fails with below...
Multiple DataFiles on SAN disks? - In the past, an i/o performance enhancing option was/is to split up your database into multiple datafiles and put each...
Is this possible - Here's what I'm trying to accomplish....I'm pulling week to date sales data (ex. if I were to run it tomorrow...
Replicas, indexes and different SQL versions - Hi all We're upgrading on of our servers from SQL2005 to SQL2012. On the 2005 box, we have mirroring set up to...
Dealing with large tables (Financial transactions) - Hi, We have in our production database a large table that is storing financial transactions, currently the table has about 90mlns...
Unable to start SQLAgent - MSDB is Read-Only - I am unable to start the SQLAgent service. It is reporting that MSDB is read-only. I have checked in SQL...
Copy image from one folder to another with sql server except duplicate image - Hello, I am planning to implement a script to copy image from one folder to another with sql server script. But...
Add two columns to make one total - okay guys, I am stuck. I have two columns that I need to add and make one total for a...
Getting the error "Maximum stored procedure, function, trigger, or view nesting level exceeded" - I have a SSRS report when generated, getting the error Server: Msg 217, Level 16, State 1, Line 1 Maximum stored procedure,...
How do I add a text qualifier to a bcp command - I need to export the results of a stored procedure in a pipe delimited, text qualified .txt file. I have...
Memory recommendation - I was told that the memory needs to be atleast 30% of the largest database size. Is there a document...
subtracting a case statement result from a Convert(char(8) result - Hello, I am struggling to get a case statement result to be subtracted from another result in the same format.I want...
logical and physical file names of all databases - Is there a query or sp that I can pull all databases on the server along with their logical file...
0 is equal to zero length string. Can someone explain how this can be? - --I know this has to do with an implicit conversion of the varchar to int, --but why does the zero...
How many IP address include in 2 node active -passive cluster - Hi, How many IP address include in 2 node active -passive cluster ..... i answered Five ........2 for private network 2 for...
SSIS package creation with txt file having multiple select statements - Hi, I have a TXT File with 20 Select statements. Requirement is Execute each Select statement and Email the output in CSV...
Previous week date range - Right, this is prooving to be a right headache, as many date related things in SQL seem to be for...
