Viewing 15 posts - 2,146 through 2,160 (of 3,366 total)
I think you just need to use the support article and the code and instructions in the link below. The reason is you need to create the Backup devices...
February 26, 2009 at 9:44 am
A skilled person can convert Excel workbook into rows that insert into SQL Server so you need to run SELECT * from any table with Excel and click show results...
February 26, 2009 at 9:05 am
Go in SAC(surface area configuration) tool and enable both remote and local, then TCP/IP and Named Pipes and turn on the Browser Service. Then enable all in COnfiguration manager...
February 26, 2009 at 8:09 am
Remove xp_cmdshell use use an Agent proxy account the Agent must be admin in SQL Server and on the network and in some cases the owner of the package must...
February 26, 2009 at 7:55 am
Collation in SQL Server from 2000 can be applied at the column level but it was not easy but 2005 comes with collation used with DML as I posted in...
February 26, 2009 at 7:41 am
Your problems are not related to 64bits but rather source and destination of your package which you have not posted. There is no 64bits driver for Excel but where...
February 26, 2009 at 7:23 am
What do you mean SQL Remote Mode and Local Mode? i.e Remote Mode and Local Mode is already included in SQL Server when you buy it from Microsoft, isn't it?
Hi...
February 26, 2009 at 6:46 am
The level of .NET framework above 2.0 is not really relevant to the trial version that is the reason it installs even in XP home. And I know system...
February 26, 2009 at 6:38 am
if I understand it correctly, yet we have a discussion about collation. WTF?
Actually collation is used to render any language correctly in any application if started with translated text. ...
February 26, 2009 at 6:26 am
I don't understand what you mean by how SQL Server stores Excel objects because SQL Server stores Excel data as tabular data from Excel XP and up because it uses...
February 25, 2009 at 7:31 pm
You need to make sure IIS is installed before you run the installer or it is disable the SSRS as an option in your choose components. So check control...
February 25, 2009 at 3:24 pm
What I am telling you is ANSI SQL definition Microsoft and other RDBMS implementation takes versions to be compliant. That is the reason code migration is not simple what...
February 25, 2009 at 3:13 pm
This should be ok since a change to table A would cascade to table B and to Table C independently.
That is not OK because only one foreign key qualifies for...
February 25, 2009 at 2:48 pm
You do that with the ReportViewer control in Local mode which means you just use ADO.NET dataset using queries with all RDBMS and even text files. You can also...
February 25, 2009 at 1:33 pm
I don't know what you are doing but the error is not wrong because SQL Server being RDBMS can only Cascade to one child table because DRI means if A...
February 25, 2009 at 1:24 pm
Viewing 15 posts - 2,146 through 2,160 (of 3,366 total)