When in 'sql server configuration manager' I see, under 'sql server services', 2 items that look like sql server's:
sql server (sqlexpress)
sql server (mssqlserver)
Does that mean I have 2 versions installed at the same time? The 'sql server (mssqlserver) is currently stopped).
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
We're getting the error "The user does not have permission to perform this action" during times of heavy load (regularly, when a trim job occurs). The error clears up when the service accessing sql server is restarted, so it's obviously not a real permissions problems.
There's a possibility that the problem is occurring when we're trying to query
dm_tran_active_transactions and sys.dm_tran_session_transactions.
Any ideas of good places to start looking?
thanks for any insights...
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.
in other words, what happens when I enable/disable FrontPage Server Extensions 2002 ?
knowing that I have asp.net web apps using .NET framework 1.1 and 2.0
thanks in advance
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?
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.
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?
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?
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!
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?
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?
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!
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!
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?
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.
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.
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.
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?
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?