the format file "\r" is slash r slash n

8.0

7

1 SQLCHAR 0 5 "" 2 GroupCode ""

2 SQLCHAR 0 1 "" 0 Star ""

3 SQLCHAR 0 9 ""...

i want to design SSIS package using BIDS using remote SSIS server.

so, how can i configure BIDS to design SSIS package.

sure, as you said, i can deploy SSIS package remotely.

from...

i find that post during my search

i have the same problem

is there a way to connect to remote ssis from within BIDS

or

i should i install ssis on every BIDS machine,...

finally, Microsoft SQL Server 2005 Service Pack 3 is available now.

you can download from

http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

be sure to download readme files to know list of bugs , installation procedures

Read What's New in SQL Server 2005 SP3 to know the list of bugs resolved before installing in production server

review:

http://msdn.microsoft.com/en-us/library/dd353312(SQL.90).aspx

read carefully: Microsoft SQL Server 2005 SP3 Release...

why not to ask the vendor frankly to...

That colation change will impact sort order of the data, because:

SQL_Latin1_General_CP850_BIN: is binary sort , on Code Page 850

SQL_Latin1_General_CP1_CI_AS: is Dictionary sort , case-insensitive , on Code Page...

yes , you can

review:

http://technet.microsoft.com/en-us/library/ms190438(SQL.90).aspx

for...

One of the most specs for SAN is Disk speed.

you get SAN with 16 x 500GB, 7.2KSATA

For OLTP , it is preferred to use SAS with 15K RPM (or...

it is preferred to do the following post upgrade tasks to avoid performance problems after upgrading:

- rebuild all indexes , that also lead to rebuild all statistics

- recompile all...

bhuvnesh.dogra (8/18/2008)

Actually whenever we resotr the master database into server ,it always refers/look the default location od master's ldf anf mdf files...so please make sure that your mdf...

for desktop application it is a direct way to use database file name in the connection string , and disconnected when application closed.

you need not to write script for attach...

i think these problems are related to security permissions , may be login user expire.

Be sure that the srvice account for node1 is not expired , and it is a...

i tested your case using import/export wizard and find the same results you find

select * from tt

where tt.[col3] is null

-- returns (0 row(s) affected)

select * from tt

where tt.[col3] =''

--returns...

review the errors in sql log error , event viewer and cluster log for related errors.

can you post the error message.