fernandolopez_fjlf (10/20/2008)

---

Hi everyone!!

I´ve scheduled a DTS Package using SQL Server Agent.

This package basically truncates a few tables (about 15), imports data from an Oracle server into these tables and then...

Use this query

SET IDENTITY_INSERT yourdatabasename.dbo.table1 ON

insert into table1 (col1, col2, col3, col4)

select col1, col2, col3, col4 from table2

SET IDENTITY_INSERT yourdatabasename.dbo.table1 OFF

But the best alternative is to...

But by using BCP you can also export the data to an external file at once.

EXEC master..xp_cmdshell 'bcp "select * from Databasename.dbo.tablename" queryout "c:\text.txt" -c -T -x'

might be this link...

Do the following:

1. change the result mode to "Results to File [CTRL + SHIFT + F]".

2. Execute the query in the SQL query window.

3. It will ask the file name...

Why do you export data from sql to Excel.

you should create an excel file with the template you required:

and by using the option "Import External Data" from the Tools...

As per the requirement what i understood, here is the code: you need to manipulate it somewhat as per your convinience:

Declare @count INT

DECLARE @finalOutput VARCHAR(30)

DECLARE @dotCount INT

DECLARE @result VARCHAR(40)

SET @dotCount...

It is not advisable to use NOLOCK as it returns the uncommited rows that may affects the final output

you want to copy a file, a database, a table or some records??? Pls specify for the solution

you can follow the following path

http://msdn.microsoft.com/en-us/library/ms188783.aspx

Dropping of any dB object is not advisable until you have the complete backup. you can rename the sp's till the next next backup.

System sp's are advisable not to...

To make SQL changes from the different machines to the central server. Create an Insert trigger on the frontend data sources tables that will insert the currently updated row into...

jaggity

Just write the query in the sp and after that type the command return.

this will return all the required data

sometimes it becomes slow due to processing.

consider this link

http://www.microsoft.com/downloads/details.aspx?familyid=3D5E96D9-0074-46C4-BD4F-C3EB2ABF4B66&displaylang=en#QuickInfoContainer

There is no Agent job monitor in SQL Express.

Here are some ways that can work as an alternatives::

1. Create ur own service(especially window service), that will take care of...

The answers are :

I have a bunch of questions:

* Why would I be seeing such a dramatic difference in the retrieval times?

Ans: As usual, HTTP first performs his...