We are using reporting services for our reports and are currently using the Report Manager application to allow users to run reports. The report manager application can be accessed from outside our firewall, so we have configured reporting services so that the report manager web application is on a separate server than the report server ...
Let's say that we have we have a table with the classic 'manager id' recursive relationship: Users user_id int manager_id int (refers to user_id) If you randomly select 2 rows in the table- or 2 nodes- how do you find the lowest level, common ancestor? My platform is SQL Server 2005 (Transact-SQL) but any ANSI compliant SQL will ...
I'm currently developing an application that needs to store data in it's on database, I'm currently using SQL Server Express 2005 with Advanced Services (because we need full text search capabilities). Local company lore says there have been all sorts of strange problems some years ago when two products used MS SQL Server with the defau...
Is there a good way to tell who created a stored procedure in SQL Server 2005 (that also works in 2008)? In SQL Management Studio I can right mouse/properties on a proc to get the created date/time but how do I discover the creator? ...
What is VIA protocol in SQL Server Client Protocols? more precisely what does VIA stands for? Is it for chip-maker VIA? ...
I have an ASP.NET application, built over DotNetNuke, used in my university for student management. Any now and then, when generating some long-running report, the application throws an error like this: "DataBinding: 'System.Data.DataRowView' does not contain a property with the name XXXX" where XXX may be different. I have to emphasiz...
Does SQL Server 2005 create one thread per connection? or How does it manage connections? ...
I am updating the sql server 2005 database using batch update, as shown below cmd = new SqlCommand("update Table1 set column1 = @column1 where EmpNo = @EmpNo", con); cmd.Parameters.Add(new SqlParameter("@column1", SqlDbType.VarChar)); cmd.Parameters["@column1"].SourceVersion = DataRowVersion.Current; ...
I exported a table to a server but I can't find the table. Maybe I didn't put the right destination database. How can I find this table if my server has multiple databases, without opening each one of them? I use MS Sql Server Management Studio 2008. ...
I've got a Windows SBS 2008 64 bit Box with SQL 2005 64bit on it. SQL itself runs amazingly well - nice and fast. SSRS though is giving me headaches. I ran the install as normal, configured the windows service to run under its own account and the web service to run as NT Authority\Network Service. When I try to run the reports though...
I have two Microsoft SQL 2005 databases setup in a fail over scenario. The application connection strings have the "Failover Partner" specified in the connection string. When the currently live database fails over to the slave database, there is a small time period that a user can obtain a SqlClient.SqlException with the message "An ex...
I have an application which potentially does thousands of inserts to a SQL Server 2005 database. If an insert fails for any reason (foreign key constraint, field length, etc.) the application is designed to log the insert error and continue. Each insert is independent of the others so transactions aren't needed for database integrity. H...
I'd like to setup an SQL Auth user in MS SQL 2005 that can restore some, but not all, databases in a particular instance. I'm not sure if I should use Server Roles for this, since they would seem to apply to all databases, but Database Role membership doesn't seem right either (I don't want the SQL user to potentially 'lose' their resto...
If I have a table containing schedule information that implies particular dates, is there a SQL statement that can be written to convert that information into actual rows, using some sort of CROSS JOIN, perhaps? Consider a payment schedule table with these columns: StartDate - the date the schedule begins (1st payment is due on this d...
I have two identical servers with SQL Server 2005 and my application. Hard requirements: I must be able to update data at either server. I must be able to unplug either server without having to reconfigure anything in the database. When a server is plugged back in, it must automatically sync up with the other server. Notes: I pref...
We have 2 databases, say DB1 and DB2. DB1 contains all the stored procedures which access also data in DB2. DB1 uses synonyms to access the tables in DB2. (Using synonyms is a requirement in our situation) This works perfectly fine in all situations with SQL Server 2005 Developer Edition. However in the Express Edition, we get an excep...
[edit] I should note that I need to do this on a live production server. The MS SQL Server is already attached to our website and supports a 3rd party ERP package. I want to set up a separate database that I can code against for some auxiliary pages and internal-use apps) which will be completely independent (mostly for security, but a...
I've got an Access MDB I use for reporting that has linked table views from SQL Server 2005. I built a query that retrieves information off of a PO table and categorizes the line item depending on information from another table. I'm relatively certain the query was fine until approximately a month ago when we shifted from compatibility...
I've got the following T-SQL code below that's working from inside of SQL Server 2005. I'm looking to add a "reply-to" header so that any reply will go to the "reply-to" address, NOT the FROM address. Yes, I know about setting this up in Database Mail, but I'm looking to just add some code to my existing solution. I don't want to use ...
I have 2 batch programs, 1 is a program that sends email and another one sends fax. They both access a table named QUEUE. In the email sender program, this is what happens in relation to QUEUE. For each record in QUEUE that satisfies criteria: Locks record 1 in QUEUE table: select 1 from QUEUE with (UPDLOCK) where id = 1 Process s...