Hi SQL Server 2008 Enterprise Edition : This error pops up once in few months and goes away.There is a sproc which inserts/updates data on a...
Hi Gurus I created a DDL trigger to audit all the DDL_DATABASE_LEVEL_EVENTS events on the database .These chages are then inserted into a table so...
Hi All I have SQL Server 2005 in a clustered environment and the databases are replicated. I have a little complex scenario.I need to reindex all the...
Hi I have to create a job where i bcp data from a table.Everytime i do a bcp i have to append the file name with the getdate().I was able to write...
Hi All I have a indexed view which I am calling from a sp.To treat this view as a table I am using the with (noexpand) hint in the T-Sql.This view...
Hi <br />I have installed SQl2005 on my desktop.I did not have any sql instances installed before.<br />After installing when i tried to login uning...
I am unable to update the txt field in a table using a stored procedure.<br />In my case i can use a WriteText function which replaces the row rather...
Goto my latest post for the main error : When i am trying to alter this sp and give the run cmmnd in query analyzer this never stops.I have to stop...
In the following code i tried to combine the cursors into 1 cursor but the results are different.The cursors are...
I have a sample code that might help you to replace Cursors with table variable. This one is good if the number of records are not too many(in...
I have a job that is DTSRUN utility,i need to identify which DTS package its running.Because this is in production i cannot run it for test purpose....
When I run my DTS through a job on a daily basis i want to save the query results to a new .csv file or excel file.The files can be named as daily...
In the following query i want to get the orders for previous day and not the current day. I am unable to frame the date range for this, so i am...
This one is for the Gurus. I have a Stored Proc which has nested Sp's.Is there a way that i can write this in one sp in a transaction Block.As per...
I know that Replacing Cursors with temp tables is effective .How can i replace the following cursor with a temp table and would it be really...
Can i consolidate the following code.Does passing too many params to the sp effect performance.The if block can be consised usin for or between but...
This sp is taking over 5 to 6 seconds .Is further optimization possible in it. The timespan of this sp is causing timeouts for other requests in the...
I had a question on how to move or copy a DTS package from one db to another one. Thanks
Can somebody tell me the best way to work with, requirements which are not clear and have strict deadlines. If you have been shown a requirement from...
Here is the scenario I have two or more tables : Person and subscription. For 1 personid from person table there can be multiple subscriptionid's in...
Separate names with a comma.
