Search Results

Search found 94317 results on 3773 pages for 'server info'.

Page 523/3773 | < Previous Page | 519 520 521 522 523 524 525 526 527 528 529 530  | Next Page >

• SSIS 2008 - How to read from SQL Server Compact Edition file?

  - by Gustavo Cavalcanti

  I can see "SQL Server Compact Destination" under Data Flow Destinations, but I am looking for its source counterpart. If I choose ADO.Net source and create a new connection, there's no provider for SQL CE. What am I missing? Thanks! Update: I am able to create a "Data Source" (under "Data Sources" folder in my SSIS project") that connects to an existing Sql CE file. But how can I use this Data Source in my data flow?

  Read the article

• Problem with insert Thai Language data to SQL Server 2008 field datatype text and show ????

  - by embarus

  Hello everyone I created MVC ASP.Net Web application and tried insert Thai language data to SQL Server 2008 database to field with data type text and then database store ?????? which is incorrect. For Html Page I user charset utf-8 However I tried to Encode string before insert data to database and change database field collation. These do not solve problem. I'm looking forward to your reply. Thanks, embarus

  Read the article

• How to formulate a SQL Server indexed view that aggregates distinct values?

  - by Jeremy Lew

  I have a schema that includes tables like the following (pseudo schema): TABLE ItemCollection { ItemCollectionId ...etc... } TABLE Item { ItemId, ItemCollectionId, ContributorId } I need to aggregate the number of distinct contributors per ItemCollectionId. This is possible with a query like: SELECT ItemCollectionId, COUNT(DISTINCT ContributorId) FROM Item GROUP BY ItemCollectionId I further want to pre-calculate this aggregation using an indexed (materialized) view. The DISTINCT prevents an index being placed on this view. Is there any way to reformulate this which will not violate SQL Server's indexed view constraints?

  Read the article

• What is best tool to compare two SQL Server databases (schema and data)?

  - by tomaszs

  I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do this?

  Read the article

• Is there any SQL Server studio managment and redgate sqlcompare/datacompare like tools for MySQL?

  - by Jack

  I'm looking for SQL Server studio management-like and redgate sqlcompare/datacompare-like tools for MySQL. What have you used that is as close to these tools or better for MySQL?

  Read the article

• can't insert xml dml expression as a string

  - by 81967

  Here is the code below that would explain you the problem... I create a table below with an xml column and declare a variable, initialize it and Insert the Value into the xml column, create table CustomerInfo (XmlConfigInfo xml) declare @StrTemp nvarchar(2000) set @StrTemp = '<Test></Test>' insert into [CustomerInfo](XmlConfigInfo) values (@StrTemp) Then comes the part of the question,, if I write this... update [CustomerInfo] set XmlConfigInfo.modify('insert <Info></Info> into (//Test)[1]') -- Works Fine!!! but when I try this, set @StrTemp = 'insert <Info></Info> into (//Test)[1]' update [CustomerInfo] set XmlConfigInfo.modify(@StrTemp) -- Doesn't Work!!! and throws an error The argument 1 of the xml data type method "modify" must be a string literal. is there a way around for this one? I tried this, but it is not working :(

  Read the article

• Are there any utilities to extract binary data from SQL Server?

  - by Sean Taylor

  Are there any utilities available that allow you to bulk extract binary data from a SQL Server table? For example, I have a number of Word documents stored in a table and I would like to extract all of these documents into files. I know could do this by writing some .NET code, but I only need to do it once.

  Read the article

• Is there a Mac client for Microsoft team foundation server?

  - by Donald Hughes

  Does a Mac client exist for Microsoft's Team Foundation Server so that I can access the code repository from my mac? Edit: I'm really looking for something free (or close to it) since I would have a hard time convincing independent collaborators to spend $200 on a source control product.

  Read the article

• Change the location of the Auto Recovery information in SQL Server Management Studio.

  - by Scott Chamberlain

  Our local IT has our My Documents folder on a network path. This causes a problem from MSQL Server management studio as it saves it auto recovery information every 10 min it will lock up as its doing its save. I found where VS2008 saved its setting but I can not find out how to change it out of My Documents for this. Does anyone know where that setting is located?

  Read the article

• Is DB2 Connect neccessary if I'm using Zend Server for i5/OS?

  - by tiraeth

  I have Zend Server for i5/OS and want to connect (in PHP) to local DB2 Instance. Do I need DB2 Connect product to call any program on i5/OS? If I can use ODBC Driver, can somebody - please - give me an url to some place where I can download it (OpenSource?) ? Another question: Is there any PDO_ODBC or ODBC adapter for Zend Framework's Zend_Db?

  Read the article

• Are products like SQL Server and Oracle are "ORDBMS"?

  - by n10i

  According to wikipedia! http://en.wikipedia.org/wiki/ORDBMS IBM's DB2, Oracle database, and Microsoft SQL Server, make claims to support this technology and do so with varying degrees of success So, are these products true "ORDBMS" like PostgreSQL? or they are they are long way from it? can someone plz! point me to any link where i can read about the features still to be implemented by these RDBMS to become true ORDBMS!

  Read the article

• CF9's Apache Lucene vs SQL Server's full text search?

  - by Henry

  ColdFusion 9's full text search is now based on Apache Lucene. We also use SQL Server. Which one's better? Which one's easier? Thanks!

  Read the article

• How to move data from VistaDB to MS SQL Server?

  - by Samnang

  Currently, I have a blog that is using VistaDB as back-end database, but later I realize that I want to MS SQL Server instead. I was wondering there is any tools that are available for migration data like this problem?

  Read the article

• how to find index of a row in sql server?

  - by NoviceToDotNet

  How can i fetch column names from a tale on index basis, like i want to make a tables whose column name should be the name of last column fields of a result set of a query, but those result sets last columns value may be different at different execution time, so i want to know how can i fetch those index value of that last column to make a temp table with column name of those last columns value of a result set. Is there any way/function in sql server to dynamically form that?

  Read the article

• How do I set up my own proxy server?

  - by NJTechGuy

  This website (abc.com) slowed access from our original IP address. How do I implement my own proxy server to hide my IP while browsing abc.com? Do I need special hardware/software combo to achieve this? If I can generate about 5 proxies and alternate amongst those 5 while browsing abc.com would be awesome. Please suggest. Thanks guys!

  Read the article

• How can I automate the "generate scripts" task in SQL Server Management Studio 2008 ?

  - by Brann

  I'd like to automate the script generation in SQL Server Management Studio 2008. Right now what I do is : Right click on my database, Tasks, "Generate Scripts..." manually select all the export options I need, and hit select all on the "select object" tab Select the export folder Eventually hit the "Finish" button Is there a way to automate this task? Edit : I want to generate creation scripts, not change scripts.

  Read the article

• Is there an SQL Server equivalent to Oracle's RETURNING statement?

  - by Thomas Bratt

  Is there an SQL Server equivalent to Oracle's RETURNING statement? I'm wondering if the OUTPUT clause would help.

  Read the article

• Will performance of a SQL server degrade if the DB can't fit in the memory?

  - by Carl Hörberg

  Will the performance of a SQL server drastically degrade if the database is bigger than the RAM? Or does only the index have to fit in the memory? I know this is complex, but as a rule of thumb?

  Read the article

• How to extract custom tokens in SQL Server NVarChar/VarChar field by using RegEx?

  - by Kthurein

  Is there any way to extract the matched strings by using Regex in T-SQL(SQL Server 2005)? For example: Welcome [CT Name="UserName" /], We hope that you will enjoy our services and your subscription will be expired on [CT Name="ExpiredDate" /]. I would like to extract the custom tokens in tabular format as follows: [CT Name="UserName" /] [CT Name="ExpiredDate" /] Thanks for your suggestion!

  Read the article

• Does MySql have Server Management Objects equivalent to MSSql?

  - by dboarman-FissureStudios

  I am looking for resources and references for a MySql equivalent to MSSql SMO. Also, is SMO the newest technology for programmatic management of Sql server?

  Read the article

• How can I get a JSON object from a SQL Server table?

  - by jlech

  I have a view that I want to be converted into JSON. What is the SQL that I can use to produce on the server the JSON string needed to be returned?

  Read the article

• What is the difference between client side testing versus server side testing when we are execute va

  - by HTMLCSS_noob

  hi all, as per my question, i am wondering what differences are there when we are performing tests for the client side , as compared to performing tests on the client side? For example, testing javascript on the client side versus testing server side code? Best Regards.

  Read the article

• I have VS2010 Ultimate. Shouldn't TFS Server be included?

  - by George

  Dumb question I'm sure, but when I log onto my MSDN subscription account, I don't see Team Foundation Server in the list of available for download software application. I thought it was supposed to come with VS2010 Ultimate, which I could download. Is it a separate download? Could it be that my MSDN account level gives me access to VS2010 but that I am still not entitled to TFS? I'd like to install it instead of using VSS.

  Read the article

• Where does sql server stores the stored procedure code?

  - by NoProblemBabe

  I once needed the lines of the stored procedures, to be able to trace whether i have a reference to some function, procedure or table, or sometimes to try to find something inside of the sp's code. Where does the sql server stores the procedures's code?

  Read the article

• Backspace on Cygwin Screen not working for Windows 2003 Server?

  - by qor72

  I updated a working Cygwin/Screen setup on Windows 2k3 Server to Cygwin v1.7.2 and Screen 4.00.03. After updating, backspace no longer works. I haven't made any changes to my system or configuration. The Cygwin update went fine, and I don't have any custom changes in /etc. Any ideas?

  Read the article

< Previous Page | 519 520 521 522 523 524 525 526 527 528 529 530  | Next Page >