Hi All, I want to delete recrods from the tables which are linked with foreign key constraint, I have already used "On Delete Cascade ". When i...
Hi, I am creating a package which transfers the data from paradox tables to a SQL server 2005 database and then from this databse it will transfer...
Hi all, I have 2 instances of SQL server 2005, one is with name comp40 and another is Comp35. When I try to register either of the server on other...
Hi All, Does anyone know how to debug a stored procedure in SQL 2000. I have a procedure which adds recrods in a table and I want to check the...
Hi All I am creating a package to transfer the data from approx 200 Excel files to a Table, all these files are on d:Excelfiles. This path is...
Hi all, I have SQL Server 2005 installed on my PC, When I installed it, i was having SQL 2000 , so the instance name for 2005 was given as Comp50....
Hi All, I am creating a package which imports the data from Paradox (.db) tables to SQL server 2005 databse . The source tables which do not have...
Hi, In my application i want to import the tables and data from the paradox .db tables to SQL server 2005. I have done this in SQL 2000 using the...
Hi there, I have around 90 tables, and Company table is the main table which is related to almost 70 tables in the databased(directely or...
Hello everyone, I want to know which one among the following will be faster. I am using linked server with name 'ReServer' and databse 'Rdb' 1....
Hello everyone, I am working with a database. Till yeasterday it was working fine and when i came back today i found the database marked as suspect....
Hello everyone<br /><br />I want to write a query with exists<br /><br />1.Select * from Cities<br />2.Select * from CDS.H34.Dbo.Cities<br />3.Select...
Hello everyone, I have 200 excel files in a folder C:Company and i want these filenames to be in a table. So as to do this task, I used a batch...
Hi I have created a DTS package as Say ParentPackage. In that i have 4 tasks 1. Execute batch file, copytables.bat(execute processtask) 2. Create...
Hello everyone<br /><br />I have created a package called TransferPackage. This package does the following things<br />1. Execute Process task to...
Hi, I have to create a report in a pdf file. but all the data for that file is in db. I have already wirtten a procedure to fetch that data, the...
Hi I am writing a stored procedure in which i want to get the count of records in the table. the tables names are stored in another Table as...
Hello I have written a sotred procedure, which transfters the data from one Database to another database. The source databse has approx 2 lac...
hello I want to know can we write a query where we give the column name as variable. for eg. table1( id , name, value) Set @var = 'name' Select...
Hello <br /><br />we want to create a DTS package which will transfer all the contents of excel file to a table in SQL server.<br /><br />There are...
Separate names with a comma.
