it is clustered 3 node .. I am running the below within proc on the node where currently MSDTC is running (SQL2k8 sp1 64bit). Question 1. Why is it...
Hi Guys,I am doing the production to QA refresh to debug a specific issue. I need two script1. before db refresh: script the existing...
Hi, I want to modify the user permission at the DR database on log shipping with standby ead only mode. it does not let me modify because the...
Hi Guys may be it is just a very basis question. say if the certain carrier does not exists i need to show the error "carrier does not exists" and...
Hi, I am at SQL 2005 . we have a table that stores pdf files along with file id. it is of data type of image. we are in the process of archieving the...
I am trying to set up the linked server i get the error Cannot initiialize the data source object for OLE DB Provider "SQLDMLOLEDB.40" FOR LINKED...
Hi Guyz I am setting up automatic monitoring of SQL 2005 on WIN2K3 R2 does anyone have the scripts or pointers i can use it as a reference or make...
Hi , Need data refresh production to development including objects like tables, stored procedures , views etc. we DONT need complete database...
Hi I am using SQL2K5 I have SSIS Package1 and Configfile1 SSIS Package2 and Configfile2 and so on... Currently i am running it manually one by one on...
Table structure as follows Employee Empno empname salary commission I want to have an other...
here i am trying to get the count of both match ((substring(aecprda_1.upc_1,1,11) = substring(z.upc,1,11) + (AECPRDA_1.product_id =...
Hi Folks I am at SQL2005 64bit enterprise. I want to restore the production database to development environment but I wanted to keep development...
Hello folks I am on SQL2K5 enterprise edition. I want to refresh staging database with production. Before I do that I want to script out the users...
Here is the original scriptselect count(*) FROM (select * from aecprda where AECPRDA.sales_cat_cd in ('02','10') and...
Hi guru's i am on sql 2000 sp4 1. First Scenario ... I have a DB1 with only primary filegroup. I have a DB2 with primary and 1 secondary...
the users want to move the all the objects (tables , procs) pertaining to reports to reportserver database. is that a good idea ? According to us...
hi guyz database size is growing to terrabyte. we need to change our backup strategy as we cannot afford to backup the whole database . here is my...
Hi Gurus We are on sql 2000 sp 4 . We have a marketing database of size around 100 gig size. Now we expecting a data load shortly and database size...
I have a scheduled DTS package that saves a query from a specific table. I need to send this as an attachment, and I don#%92t have an outlook client...
Hi folks we are at sql2000 sp4 database running the reporting services on windows 2003 server. while we remove the user from reporting manager it...
Separate names with a comma.
