Hi. I'm having a problem with deadlock on SELECT/UPDATE on SQL Server 2008. I read answers from this thread: http://stackoverflow.com/questions/661908/sql-server-deadlocks-between-select-update-or-multiple-selects but I still don't understand why I get deadlock. I have recreated the situation in the following testcase. I have a table:...
Hi I installed VS 2010 on a plain Vista x64 OS, now I need to install SSMS as well. Based on your experience, what version do I have to install? Thanks in advance! ...
I realize that this question has been asked and has been answered here but I am having problems with the slip stream approach and I'm hoping someone else has run into it. I've tried downloading the newest installation guide but the help file appears to be corrupt as it won't open any of the pages so I'm a bit in the dark here. I rigorou...
hello guys i am new to data migration. My primary goal is to move the data from Microsoft CRM 3.0 to CRM 4.0.2. We are using SQL Server 2008 as our production server. Can anyone advise me on this? ...
I'm designing a database for internal use at my company that will store data that is produced by my team members. While SQL Server will be installed only on a single server machine, my team members will need to be able to access the data and run filter/select queries on it from their own terminals (for instance, search for the product fr...
How to remove a textbox and put the dropdown box in asp.net And the value that is used before in textbox, now it should take from dropdown box ...
I got the following error trying to convert from a varchar to varbinary.. Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query. and this is the alter command that I tried. alter table foo Alter column bar varBINARY(max) So how do I use the convert function...
Hi, I normally set my column size when creating a parameter in ADO.NET But what size do I use if the column is VARCHAR(MAX)? cmd.Parameters.Add("@blah", SqlDbType.VarChar, ?????).Value = blah; ...
I just set up SQLSERVER 2008 Express on a new machine, and on the first database on there I created a Fulltext catalog & index. When I try to use fulltext searching, I get the following error: Msg 30053...Word breaking timed out for the full-text query string. etc. I did some searching around and it turns out it is probably bec...
Hi folks, I'm trying to create the following sql query (as in, this is an example of the final query) :- DECLARE @SearchQuery AS NVARCHAR(100) = 'yellow bird' SELECT Id, Name FROM dbo.FooBars WHERE CONTAINS(Name, N'FORMSOF(Thesaurus, yellow)') AND CONTAINS(Name, N'FORMSOF(Thesaurus, bird)') Notice how i've got two 'CONTAINS' line...
Is there anyway to get in the server and recreate them? ...
Vista just finished one of its many updates. After restarting my computer I try connecting to SqlServer2008 instance with Sql Server Management Studio and I get this error: Error connecting to '...\MSSQLSERVER2008'. Additional information: Login failed for user '...'. Reason: Server is in script upgrade mode. Only administrator can conn...
I have a table with two fields in an sql server database and my asp.net application calls a stored procedure with a '@SearchString' parameter and the stored procedure finds all records where the @Searchstring value is found in the concatenation of two fields in the table, call them 'Field1' and 'Field2' So the logic looks like this(I ha...
I am trying to setup SSRS 2008 on Windows Server 2008. It seems to work as expected when I access the web interface through HTTP, but when using HTTPS the following error is what I get: "The underlying connection was closed: An unexpected error occurred on a send." From a look at the log files, it is revealed that the inner exception is...
My SQL Express database has run out of room so I'm migrating my heavy data from the old "image" blob columns to the new (varbinary) "filestream" columns in SQL Server 2008. I was about to write an application to do it, but I thought there may be a clever way to do it in SQL that I hadn't thought of. Does anyone know of a way to achieve...
Dear All, I already have a table with 3 column (Id bigint, Title nvarchar(450), Description nvarchar(MAX)) in sql 2008 I decide convert Title and Description column into one XML column. but when trying to update get many error like "illegal name character" or "illegal qualified name character" and etc. to solve this problem i just cre...
From what I've read nothing explicitly says you cannot have two FILESTREAM columns in one table, but given that you need a ROWGUIDCOL identifier for the FILESTREAM to work, and you cannot have two of those, is it possible? Can I use the same ROWGUIDCOL but with two different FILESTREAM groups? ...
Hello, I have sever nested subreports that by default are hidden and are only made visible when toggled via an element in the parent report. I want SSRS to not execute the query statements for these subreports untill they are toggled and made visible. The subreports recieve their parameters from their parents, and not from any user inpu...
How can I force my ASP.Net application to connect to a SQL Server using TCP/IP, not Named Pipes? I read somewhere putting "tcp:" in front of the server name in the connectionstring should do the trick, but it does not seem to change anything. Edit1: TCP/IP is enabled on the SQL Server. I tried Network Library=dbmssocn in the connecti...
In a table, I have an ID column, that is an Identity int. How can I make it so that the next row inserted will get identity 10000 (I believe this is called the identity seed) - without dropping and recreating the table? I need to do this because of a uniqueness issue with an external service, the app accesses. ...