I am working on a Flex application that is connecting via Flash Remoting to ColdFusion 8 with a SQL Server 2005 database. Most of the time, everything runs fine. However, from time to time, it will take an exceptionally long time for SQL Server to return data from a stored procedure call to ColdFusion; returning data from CF to Flex is v...
Hi! I'm configuring a simple service broker implementation. Locally, we use SQL Server 2008 Express and everything works fine. Once the code runs on our production server (SQL SERVER 2005), messages are stuck in the receiver queue. The followind code is incomplete but states how queues and services are basically configured: -- Create m...
Hello, It's my impression that schemas are mainly for organizing the tables, view, stored procedures, etc... in a SQL Server database. Do schemas play a bigger role (perhaps in database security, storage, etc)? Some clarification: I'm referring to "object" schemas. Sorry for the confusion. Thank you. ...
I have a trigger in SQL Server, but I need to pass arguments to the CLR code, i.e., information not provided in the trigger context. Is something like this even possible? CREATE TRIGGER MyTrigger ON MyTable FOR INSERT AS EXTERNAL NAME MyAssembly.MyNamespace.MyTriggerHandler("Foo", "Bar") These arguments would be static, of course. ...
The company I work for has decided to join the 21st century and upgrade our main database cluster from SQL Server 7 to SQL Server 2005. As a web developer what new whiz-bang features of SQL Server 2005 should I get excited about or get to know? Currently I'm mainly writing CRUD style queries, pretty much exclusively using Stored Procdur...
Suddenly I'm getting the following error on all web applications using dotNET 1.1 and trying to access MS SQL 2005. The applications and SQL server run on the same machine. System.Data.SqlClient.SqlException Message: General network error. Check your network documentation. I have googled the following and tried all suggested solution...
Hi all, I am just confused with the execution sequence of sql query when we use GROUP BY..HAVING with WHERE clause. Which one get executed first?? Please help me. ...
Hi, I am using the following query select SS.sightseeingId, SS.SightseeingName, SS.displayPrice, SST.fromDate from tblSightseeings SS inner join tblSightseeingTours SST on SS.sightseeingId = SST.sightseeingId where SS.isActive = 1 and SS.isDisplayOnMainPage = 1 and getting result like this 2 Dinner Cruise Bat...
Hi, I'm not sure how to word this correctly but I'm very (very) new to XML in Sql Server. I have an XML Column defined in a table and I want to retrieve the id of the record if the data in the Xml Column matches elements in a predefined list. The data looks a bit like this: <Parameters> <Parameter> <Name>Param1</Name> ...
I'm trying to use the Xml Source to shred an XML source file however I do not want the entire document shredded into tables. Rather I want to import the xml Nodes into rows of Xml. a simplified example would be to import the document below into a table called "people" with a column called "person" of type "xml". When looking at the Xm...
Hello Our original database has called first, middle, last for names of people. We have now created fields called firstname, middlename, and lastname. While we are going through this transition I have created a trigger to copy data from first to firstname, middle to middlename, and last to lastname anytime one the previous fields receiv...
Hi, I need to have ability in my application to be able to export some data using the SQL Server BCP utitility. The machines where this utility would run would not have SQL Native Client installed on it, so BCP.exe won't be present by default. Can I put a version of BCP in the installation package. What are licensing implications? I ...
I have an SSIS package that needs to be deployed to SQL Server agent. It has 2 external dependencies (2 assemblies, both installed in the GAC) Now the package runs just fine under a File System Deployment but when we deploy to SQL Server agent it fails with 'Object reference not set to an instance of an object' within the task that re...
I'm bumping into somenull fields in a SQL2005 db. Some report Null and others have values like 1.00 or 713.00. I'd like a bullet proof way to convert the 'Null's to 0 and the '1.00' and '713.00' values into Money types. ...
Some of our reports aren't displaying properly in Firefox - the first column lacks any css. After investigating, I'm finding: <tr> <td style="HEIGHT:6.93mm" style="...">1st Column</td> <td style="...">2nd Column</td> <td style="...">3rd Column</td> </tr> When I remove the style="HEIGHT:6.93mm", it renders properly in Firefox. ...
Is it possible to parse & load an xml file with optional elements/attributes using SQL Server Integration Service 2005? Any examples/pointers would be appreciated. ...
I have recently be running into many different areas of sql server that I normally don't mess with. One of them that has me confused is the area of Logins and Users. Seems like it should be a pretty simple topic... It appears that each login can only have 1 user and each user can only have 1 login. A login can be associated to multipl...
I'm using VS2008, writing a C# .NET app. I have an SQL Server 2005 database server with a database which contains several stored procedures. I want to show the stored procedure data in a report. So, as a test I created a brand new VS2008 C# project based on the "Reporting -> Reports Application" project type. I went through the wizard,...
I have an existing application that transfers a Database from a source server to a target server via SMO "Transfer". We transfer only the data. Both SQL-Servers are 2005. Now we upgrade the target server to SQL-Server 2008. Will the transfer via SMO still work? ...
Hi, I'm using a SqlCommand to execute a sql statement on a SqlServer2005 db. ( I also tried DbCommand.) If I execute this sql in SQL Server Management Studio, I can send the "Results to Text". I would like to capture this text in my C# code. This and this are related questions, but not the same: My sql contains, next to print stateme...