You can't really blame SQL server for this,

They make if fairly clear that SQL express does not have the agent, you need to pay for this feature.

Also sql...

It appears the problem is not with the collation, though this is important to have for the correct sorting and comparisions of the data.

The problem would be with the...

Sorry i think i was pointing you in the wrong direction

It seems like the problem is that Sql server does not support the Kannada characters by default.

What service pack are...

Since this is the SQL 2005 forum,

can I assume that you are using SQL 2005 and SSIS rather than DTS?

It really depends on how much down-time you are allowed,

if possible i would go for a full-backup and restore on the new server

How much of the 51gb is free space?

SQL server will hold the free space for re-use unless you shrink the file, if there is space avialable then SQL server...

How did you port the data to SQL server?

when inserting unicode data into SQL server you need to use a leading national 'N' on the query.

http://support.microsoft.com/kb/239530

RGDavis396 (11/30/2009)

---

Searches against string values tend to be slower than those against numerical values and we are looking for ways to speed up searches against commonly used fields such as...

If you want to create dynamic file names in excel the best way is to click on properties of the Excel Connection manager then select expressions and then select ExcelFilePath...

Do you have a clustered index on this table/heap ?

As stated above the problem with speed would most likely be due to the fact that you are using a...

srilu_bannu (11/23/2009)

---

I am sorry to bother you but my server is using the compatibility Sql server 2000(80) which will only run DBCC showcounting...

And also, if i want to rebuild the...

Three are formats to strip out any part of the date by using DATEPART

for the year you would use

SELECT DATEPART(yy,GETDATE())

to build your own custom date formats you...

I am happy to answer questions and point you in the right direction, but as I am at work it would not be fair to my employer to spend...

-In your For Each Loop select to extract the file name

-Click on Variable mappings and map the file name to a variable

then

-Create a Staging table on your Sql Server, ...

You can do this in T-SQL by using cmd_shell to execute the stanard DOS commands for FTP sites (PUT, GET etc..) though you need to be aware that enabling...