Hi, I'm looking for a way to explain a deadlocking issue. I think I know what is causing it, but I'm not sure of the exact events. We have a long-running view (several seconds). We are updating one of the tables that is used in that view. The updates can also take several seconds. The update statements that are running when the dea...
Hello, I need to duplicate several tables in a single database. Basically we have an old dot net nuke portal that needs to be split and our host limits us to a single database. So we just want to take the existing tables but copy them with an exact duplicate but different table prefix name (e.g. EEPTL_Users to JBPTL_Users). I can use...
Coming from an extensive SQL Server T-SQL background, I'm having trouble finding any specific documentation describing the differences in T-SQL support between SQL CE and full blown SQL Server. What are some of the differences you've run into? Is there a side-by-side T-SQL comparison somewhere? I've seen the MSDN documentation here, b...
I have found my self in quite a pickle. I have tables of only one column (supression or inclusion lists) that are more or less varchar(25) but the thing is I won't have time to index them before using them in the main query and, depending how inportant it is, I won't know how many rows are in each table. The base table at the heart of al...
SQL Server 2008 R2 has a new Master Data Services feature that includes some really nice regular expression matching & extraction functions: http://msdn.microsoft.com/en-us/library/ee633712.aspx I am running 2008 R2, and want to run those functions outside of the MDS database. How can I? Is there a way to extract them and reapply the...
This answer to what looks like the same question: http://stackoverflow.com/questions/703019/sql-query-convert-integer-to-hex-and-hex-to-integer ..does not work for me. I am not able to go to a HEX string to an integer using MS SQL server 2005 CAST or CONVERT. Am I missing something trivial? I have searched extensively, and the best I ...
I have a report that runs a stored procedure that takes about an hour to run. After about 30 minutes I get this error message on the report body: An error has occurred during report processing. Query execution failed for data set 'DEV'. A severe error occurred on the current command. The results, if any, should be discarded. Operation ...
I have a stored procedure that works correctly when I execute the stored procedure from SQL Server Management Studio. Unfortunately, it doesn't behave the the same way on the production server. On an insert statement, it is only inserting some of the values and the rest are NULL. The NULL values are coming from user defined scalar func...
I am trying to insert a file into a database which uses SQL File Streaming. When I try to initialize the SqlFileStream object that I will be inserting with I receive a File Exception stating that the network path could not be found. The code in question is below: using (SqlFileStream sqlStream = new SqlFileStream(filePathName.Value, fi...
I have a simple two field form that stores its data in the database, for some reason it isn't working. I have verified that the connection string works, as it is used in another project I made. I didn't include the beginning of the first class or its page load. Code: protected void btnSubmit_Click(object sender, EventArgs e) { ...
Hi, getting confused here. I'm trying to install a second instance of reporting service sql server 2008 r2. Now does it mean I need to install a second instance of sql server or can i use the existing sql server instance to create anothe reportserver database? ...
Hi, I've created a WIX DB installer. It works on my DEV machine using SQLEXPRESS but not on my test machine using (local). I confirmed that the server is correct in each case, using Orca. The following, is pretty much what I'm using, only with a few more scripts. the scripts are known to work fine, and if I take them out altogether, it ...
One of my program in VC++ uses the MS SQL Server 2000 as the DB and the app was coded in VC++ 6.0. The DB part was governed by the MFCs CRecordset and so on. The data is populated through the sequence as follows CRecordset::AddNew(); Fill all the columnar data of the record CRecordset::Update() The problem now surfaces is, when the a...
I am storing small webpages in html format in a varchar(max) column in MS SQL server 2008. Now I want the gridview to show the column as a button/hyperlink such that when I click it, I will be redirected to a new webpage which will render the html in the table corresponding to that row. I tried using the buttonfield control but there d...
What is the impact of Server collation on databases? We have dev and production environments on different server collations, is there a risk having these different server collations? ...
Hi All, We are working on a website where Google Analytics data matters us a lot. We have already registered with Google analytics & we are getting the result. We are also using Google API for .net to access analytics data on our site. We have decided to store Google analytics data in our database for our further reference, as we are n...
Hi , I have a windows 2008 r2 x64 enterprise edition + sql server 2008 r2 datacenter edition from its local computer I can make connection to the sql server with sqlClient in C# and here is my connection string looks like : using (sqlconnection cn = new sqlconnection("Data Source=myServerIPAddress;Initial Catalog=myDataBase;User Id=myUs...
I have created a new database(development from production DB). These DBs have different names and now insert and update statements in my procedures are prefixed with the production database name. How can i change this rather than doing it mannually. ...
Hello, In SQL Server assuming one has columns that need to have the same data type is it possible to define a check constraint at the table (or database level) and apply that to a column when you define it? As in this (contrived) example: ALTER TABLE dbo.tblAuditTrail ADD CONSTRAINT CK_DecimalNumber CHECK (DecimalColumn LIKE '^\-?\d+\...
Hi, I have a question. I am working on cursors. Each time, after fetching the last records and printing its data’s, the cursor prints an addition line. To understand what I mean please consider the following sample example: I want to print the information about only 10 customers. USE Northwind GO DECLARE myCursor CURSOR FOR SELECT TO...