It's possible. Ensure you install SSIS (Integration Services) and BIDS (Business Intelligence Development Studio) in SQL Server setup. You can find the limitations of the editions of SQL Server from the following site: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx -...more >>

How can I install SQL Server 2005 Business Intelligence on windows XP, is it possible or not. I want to design all my resports through BI, need guidance. ...more >>

Answered in .sqlserver.xml. Please don't post the same message multiple times in different groups, put all group names you want the message to go to in the message at once. This helps prevent people wasting time answering questions that have already been answered in other groups. "DR" <so...more >>

Fastest way to move XML document into and back out of CLR function In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass an xml data type variable into a C# CLR function and retrieve it back out of the C# CLR function when the C# CLR function is done modifying it? I tr...more >>

How is fastest way to construct an XML node then a bunch of slow xquery modify statements? This SQL Server 2005 logic is rather slow to simply add a new item to an xml document. Any way to do this all in one statement and faster for creating a new node without having to re-select to set the...more >>

Is there any way to add our standard System DSN or equiv, ODBC connections on XP clients via scipt or GPO? THis cannot be the first time this question has been asked but I cannot find a satisfactory answer. Thanks in advance!...more >>

Hello, If a file has been damaged because of disk problems, copying it to somewhere else will not fix the file. You have a couple of strategies you can try. 1 - If it is only the log file that has been corrupted, you can try creating a new log file and replacing the existing one. This fo...more >>

Hi All Is there any tools to fix log file my H.D.D have bad sector and that on SQL server directory on my database login file(x_db_login.idf) so I copy from there by tools but it's not work other file for(x_db_data) what I do? I creat database by same name(x) and i copy SQL(x_data /x_log) fr...more >>

Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to run a SQL Server Project with a CLR stored Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I simply create a new SQL Ser...more >>

DR wrote: > How to create a CLR DLL for Sql Server 2005? Is it just any .net > class library that you can load into Sql Server 2005 or is there some > special project type that I need to start with? See the following chapter in Books Online: http://msdn2.microsoft.com/en-us/library/ms131046...more >>

How to create a CLR DLL for Sql Server 2005? Is it just any .net class library that you can load into Sql Server 2005 or is there some special project type that I need to start with? ...more >>

You already have answers from other groups. Please do not post your question one more than a group. -- Ekrem Önsoy http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT "dr" <softwareengineer98037@yahoo.com> wrote in ...more >>

I'm trying to use SQL Server 2005 Compact Edition (3.1) with the Enterprise Library data access block (3.1) . I want to be able to use the DatabaseFactory.CreateDatabase method so it's all handled by the configuration in app.config. When I do I get an exception. "Failed to find or load the...more >>

I'm trying to use SQL Server 2005 Compact Edition (3.1) with the Enterprise Library data access block (3.1) . I want to be able to use the DatabaseFactory.CreateDatabase method so it's all handled by the configuration in app.config. When I do I get an exception. "Failed to find or load the...more >>

what is the best way to store passwords and credit card information in SQL Server 2005? ...more >>

Ekrem Önsoy wrote: > x64 Means 64Bit Architecture. If your server system is 64Bit, then > you are gonna choose x64. > > If your server system is Itanium, then you'll stick with it. > > If your system is 32Bit then you'r gonna need to select x86. > > You also have right to install x86 on x...more >>

Hi, I installed SQLServer with a instance using the following cmd: /qn INSTANCENAME=MYINSTANCE ADDLOCAL=All SQLCOLLATION=Latin1_General_CI_AI =Latin1_General_CI_AI PIDKEY=ABCDE12345FGHIJ67890KLMNO SECURITYMODE=SQL SAPWD=Pass SQLAUTOSTART=1 DISABLENETWORKPROTOCOLS=0 When I try to connect...more >>

Hello Tony! x64 Means 64Bit Architecture. If your server system is 64Bit, then you are gonna choose x64. If your server system is Itanium, then you'll stick with it. If your system is 32Bit then you'r gonna need to select x86. You also have right to install x86 on x64, however this i...more >>

Hello! The OS I use in windows 2000 professional. I'm going to install SQL Server 2005 and there are three different versions. These are SQL Sever Itanium, SQL Server x64, and SQL Server x86 I just wonder what is the difference between these and which one is the best to use in my case? ...more >>

I have been using this computer program for a couple weeks now and i am very pleased with the results so far. its a software fatloss program, if your looking for a diet/weightloss plan i reccomend you check this place out first: http://fatloss9.50webs.com ...more >>

Hello there, just a small question: is the SQL Server 2008 CTP July compatible with the second Visual Studio 2008 BETA? And are these two compatible with the Windows Server 2008 RC0? Thank you...more >>

Hi, I have an unused HP Pavilion with the fallowing specs: # Processor: AMD Athlon 64 X2 4000+ (2.1GHz, 2000MT/s System Bus) # Memory: 2048MB PC2-5300 DDR2 SDRAM memory (2x1GB) (expandable to 8 GB (4 x 2 GB) (64-bit OS)/ 4 GB (4 x 1 GB) (32-bit OS)) # Hard Drive:320GB 7200RPM SATA 3G (3.0 Gb/s...more >>

To answer your other question about how to find out ports being used: You may use: Netstat -a to list all the ports currently being used. Thank you, Saleem Hakani HTTP://WWW.SQLCOMMUNITY.COM SQLTips, SQL Radio, SQL Forums, SQL Articles, SQL Tips, SQL Events, SQL Blogs, SQL Clinic. It's a S...more >>

To answer your other question about how to find out ports being used: You may use: Netstat -a to list all the ports currently being used. Thank you, Saleem Hakani HTTP://WWW.SQLCOMMUNITY.COM SQLTips, SQL Radio, SQL Forums, SQL Articles, SQL Tips, SQL Events, SQL Blogs, SQL Clinic. It's a S...more >>

If you have a multi instance machine the port 1433 can only be available for one of the instances of SQL server. Usually the default instance is assigned 1433. -Allen > >I have a Multi instance >"Allen Kinsel" <allen.kinsel@nospam.anico.com> wrote in message >news:fc7768cd70134ae2aa3be64980...more >>

On separate servers yes, but on a multi instance server no. Only 1 application can be bound to a port at a time -Allen > >Can I use same port for SQL server 2000 & 2005, i.e 1433? > > > > > Posted by NewsLook (Trial Licence) from http://www.ghytred.com/NewsLook/about.aspx ...more >>

You can use it but 88 is commonly used to run kerberos. To avoid any conflicts you'll probably want to choose a port well above 1000 possibly in the 2000 range. -Allen > >Can I use port 88 for SQL Server 2005, just wanted to confirm is it in >used by another application, or any tool where I ...more >>

Can I use port 88 for SQL Server 2005, just wanted to confirm is it in used by another application, or any tool where I can findout this? ...more >>

I have a Multi instance "Allen Kinsel" <allen.kinsel@nospam.anico.com> wrote in message news:fc7768cd70134ae2aa3be649804664f8@ghytred.com... > On separate servers yes, but on a multi instance server no. > Only 1 application can be bound to a port at a time > > -Allen > >> >>Can I use same ...more >>

Can I use same port for SQL server 2000 & 2005, i.e 1433? ...more >>