In SQL Server 2008 R2 Reporting Services, we are developing our own custom data processing extension, using IDbConnection and friends, and we plan to add our own custom query designer, using IQueryDesigner. That all works fine, so far. However, we want to enable the use of the connection string "Edit..." button on the Data Source and S...
I would like to make a CLR user-defined type in SQL Server 2005 that has the same performance benefits as hierarchyid to model hierarchies. Does anyone have any ideas/pointers? ...
Hi, Within our system we have a linked server to our Active Directory server and a sql script which uses an LDAP query to retrieve users and groups in order to populate tables within an application. This script worked without issue on the original set up (SQL 2005, Win Server '03 32 bit). The script now will initially succeed (after t...
The year is 2010. SQL Server licenses are not cheap. And yet, this error still does not indicate the row or the column or the value that produced the problem. Hell, it can't even tell you whether it was "string" or "binary" data. Am I missing something? ...
Is there a way to downgrade a database, that has been created on SQL Server 2008 R2, to work on an older version of SQL Server 2008 (RTM/SP1). ...
I would like join two tables into 1 table that has one common column and I need to try and avoid all duplicates. ...
Hi, I developed an Asp.net application that uses Entity framework to connect to a Sql Server 2008(not R2) database. The client run the db script against a Sql server 2008 R2 database and it executed successfully. When the application is executed an exception is thrown: 'Sysutcdatetime' is not recognized as a built in function. After chec...
I have two tables. In the one table I have a list of dorm rooms with maximum occupancy like so: dorm_building | dorm_room | max_occupancy Then I have a list of students and the room they are assigned to like this: people_id | people_name | dorm_building | dorm_room I want to create a table that has a row for each potential occupant...
I am trying to copy all the tables and views from a database on SQL Server 2005 to a database on SQL Server 2008 using the Import data wizard, but after running for some time it just copied 230 tables from 570 tables and views and gave the following warning. Warning 0x80019002: Data Flow Task 46: SSIS Warning Code DTS_W_MAXIMUMERRORC...
Suppose we have a DAL method public void BuyProduct(int productId, int quantity, int buyerId); Within that method we need to call 2 stored procedures: EXEC tblOrders_CreateNewOrder EXEC tblProducts_RecalculateStock Is it a good practice to create 2 SqlCommands - one per stored procedure and to use a single SqlConnection to execute...
I don't have a problem with building the category structure. I have a problem trying to figure out how they included similar or other categories similar to a given one. For example, if you choose the "computers / software" category you will see a category for consumer information, games, sports, home etc. These categories don't belong di...
Hello, I have table in a SQL Server database with only 900 record with 4 column. I am using Linq-to-SQL. Now I am trying retrieve data from that table for this I have written a select query. Its not querying data from database and its showing time out error. Please give me idea for this. First how can I increase time and second how c...
Hello everyone, I am using SQL Server 2008 Enterprise on Windows Server 2008 Enterprise. In a stored procedure, we can execute a SELECT statement directly. And it could also be executed in this new way, I am wondering which method is better, and why? New method, declare @teststatement varchar(500) set @teststatement = 'SELECT * from ...
Hi Guys, I have one table in that they are four coumns like startdate varchar(15), enddate varchar(15), starttime varchar(15), endtime varchar(15) Here I need to get the time in hours between these two dates (ex: 6/7/2010,6/12/2010) if i pass these days as inputs regards, ravi ...
In SQL Server 2005/2008, is there some significance to tables that have two leading underscore characters in their name? For example, a tool we use to manage our database creates a table named dbo.__RefactorLog, if it currently doesn't exist. I cannot see this table in SSMS, and Red-Gate SQL Compare doesn't seem to see it either. Thanks...
Hello everyone, I am using SQL Server 2008 Enterprise on Windows Server 2008 Enterprise. In the stored procedure, I need to pass parameter to a select-where-like statement. For example, @department is store procedure input parameter, its type is varchar(20), select * from sometable where somecolumn LIKE '%@department%' but seems m...
Hi, Is it possible to log the events of ssis package execution called from c# Application app = new Application(); Package package = app.LoadPackage("<package_path>", null); package.ImportConfigurationFile("<configuration_path>"); DTSExecResult result = package.Execute(); I need to log the messages generated during the package exe...
I have installed SQL Server 2008 Developer edition. In visual studio, when I want to add new data connection in server explorer (sql database file) I'm getting the following error message: I don't get errors when I chose Microsoft SQL Server as DataSource. SQL Server allows remote connections. ...
I am trying to update my current table by drawing data from another table. My database (dbo_finance) column - test The other database is assestsc and I am going to pull the data from column issuename1, however I only want to pull the issuename1 when the field [MinSecClass] is = 9. This is what I wrote UPDATE dbo_finance SET [dbo_finan...
I am getting the following error when I am trying to copy database and it's getting stopped at this point. Error 0xc0047008: Data Flow Task 46: The package contains two objects with the duplicate name of "output column "ErrorCode" (720)" and "output column "ErrorCode" (737)". Warning 0x80019002: Data Flow Task 46: SSIS Warning Code DTS...