Viewing 15 posts - 1 through 15 (of 20 total)
the format file "\r" is slash r slash n
1 SQLCHAR 0 5 "" 2 GroupCode ""
2 SQLCHAR 0 1 "" 0 Star ""
3 SQLCHAR 0 9 ""...
June 9, 2010 at 12:06 pm
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.
September 11, 2009 at 1:46 pm
i find that post during my search
i have the same problem
is there a way to connect to remote ssis from within BIDS
i should i install ssis on every BIDS machine,...
September 8, 2009 at 6:30 pm
finally, Microsoft SQL Server 2005 Service Pack 3 is available now.
you can download from
be sure to download readme files to know list of bugs , installation procedures
December 21, 2008 at 3:08 am
Read What's New in SQL Server 2005 SP3 to know the list of bugs resolved before installing in production server
read carefully: Microsoft SQL Server 2005 SP3 Release...
December 21, 2008 at 2:56 am
steve smith (8/22/2008)And, if you break the vendor's application by changing the collation, who has to fix it? You or the vendor?
steve smith (8/22/2008)
why not to ask the vendor frankly to...
August 22, 2008 at 9:36 am
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...
August 22, 2008 at 6:31 am
madhu.arda (8/21/2008)1. can I need to log into sqldba1 and goto controlpanel->add/remove programs->sql server2005(mssql server)->remove->select the instance that i need to uninstall? or
yes , you can
August 22, 2008 at 2:00 am
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...
August 19, 2008 at 5:09 pm
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...
August 18, 2008 at 6:05 am
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...
August 18, 2008 at 4:13 am
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...
August 13, 2008 at 6:02 am
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...
August 13, 2008 at 3:36 am
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)
where tt.[col3] =''
August 13, 2008 at 2:17 am
review the errors in sql log error , event viewer and cluster log for related errors.
can you post the error message.
August 13, 2008 at 1:25 am