hello, I have CLR which references Web service, into CLR i have one method with calling one of Web services method. What i need is, to make this CLR method return me information and show it in Result tab (in SQL server) . I printed result in SQL tab Messages with SqlContext.Pipe.Send. How can I do the same in Result tab, like it's sampl...
Hey guys, I want to ping a url over http from a sql server 2008 stored procedure. What is the best and easiest way to do this? UPDATE: To make it more clear, I just want to call an aspx page from a stored procedure to notify my aspx page that data has been modified and aspx needs to refresh the cache. I know that I can do this via sql...
Hi, Let's say I have the following string stored in a column which has full-text: xx 3 555 7 4 My question is why a search using FREETEXT for the word '555' would not return anything ...
So i bet i got you curious with that title. =) Here's the scenario - simplified for the cause. Website: ASP.NET 4 Web Forms. Database: SQL Server 2008. DAL: LINQ-SQL. In the DB, we have two tables: Foo and Bar. Relationship is 1-1, and Bar has a foreign key constraint to Foo. In other words, you need to create Foo first, then use t...
Hi All, I have a table with 24 columns of varchar(1000) and 1 column with varchar(8000), my source is of same data lengths of text files. Would I get any problems in the processing due to data lenghs in performance or over size of the sql limit page size. thanks prav ...
Excel has a Get External Data ribbon bar in the Data tab where we can choose to import tables from SQL databases. This process worked out nicely for me. But my question is, is there any way to save this data back into SQL? Does Excel provide some API that facilitates the coding of such a function without parsing everything and doing it f...
I know that the question sounds like this is going to be an easy question, but let me explain. I have a result set where I get Count Team Score Team2 Score ----------------------------------------- 10 TeamA 1 TeamB 2 7 TeamB 2 TeamA 1 Now, because I have the same result, but the...
Hi All, I know that the only stupid question is the one that you don't ask ... but even so this could be borderline :) Is it possible to install SSRS 2008 [stand alone] on a site that has SQL server 2005 installed. I know that you can store the SSRS 2008 Report and Temp databases on SQL Server 2005 [With some restrictions based on th...
Can anybody tell me why is this query not working? Select temp.CompanyName from ( SELECT c.CompanyName, o.OrderID, YEAR(o.OrderDate) As YEAR, Sum(od.UnitPrice * od.Quantity) from Orders o INNER JOIN [Order Details] od ON o.OrderID = od.OrderID INNER JOIN Customers c ...
Time-out occurred while waiting for buffer latch type 2 for page (1:1535865), database ID 6. This is an error message I got for five times while trying to create an index CREATE NONCLUSTERED INDEX YearIndx ON dbo.Papers ( PublicationYear ) the papers table is about 20,000,000 records and 175 GB Thank you in advance. ...
Hello, I have an data transformation query which takes a long time to run on my development machine (Core i7 920 running at 3.9GHz, and with 12GB of RAM under Windows Server 2003 x86 and with 2 Velociraptors 300GB iN RAID0). When I look at the task manager, the CPU stays around 26%, with the third (out of 4) core being the most active....
Let's say I have a table like this: Task Type Variable Hours Duration One A X 10 5 One A Y 40 15 One B X 100 29 Two A X 5 2 Two B X 15 9 Two A Y 60 17 Three A Y 18 5 W...
I have two columns in a SQL table, fooId (int) and fooName (varchar). Is there a way to select them both as one column with a space between them? select fooId + ' ' + fooName as fooEntity from mytable They're different types so I'm getting an error. This field will be databound directly in a control in the web app. SQL Server 200...
Say I have the following table: id|myId|Name ------------- 1 | 3 |Bob 2 | 3 |Chet 3 | 3 |Dave 4 | 4 |Jim 5 | 4 |Jose ------------- Is it possible to use a recursive CTE to generate the following output: 3 | Bob, Chet, Date 4 | Jim, Jose I've played around with it a bit but haven't been able to get it working. Would I be bett...
Is it possible to assign a DB role to a DB user in Sql Server 2008 using t-sql? If so, how? ...
Hey, I am in the following situation: I have been requested to write an application for managing where we have customers - this must flag up when we try to add a customer too close to another one, so must be able to calculate distances based on post codes. I have chosen to use ASP.Net VB because I am fairly good at that and I like tha...
Okay so i've got a stored proc which does a bunch of things (not important). Now, the stored proc is quite verbose, it prints out a lot of things (progress, rowcounts, etc). As you all know, using PRINT with variables is extremely painful (requiring you to have a CAST party). So, ive used RAISERROR to print these friendly messages (ev...
We are planning on using the new auditing feature in SQL Server 2008. Is there a way to configure the auditing component to insert audit data to a separate database? ...
In SQL 2000 / Query Analyser, i used to be able to drag-n-drop T-SQL script files from Windows Explorer onto Query Analyser. Cannot do the same in SQL 2008 / Management Studio ? I can obviously do: File / Open / File... Navigate to the file Then Open it. But someone please tell me there is an easier way just like in 2000 ! EDIT 16/7...
My ASP.NET host only allows 3 database users per db other than the dbo. I have one for the web app that only runs stored procs and has limited selects to tables. One for ASP.NET membership/roles. One for SQL cache dependency/notification. One for logging - ELMAH / log4net. How would you consolidate the 4 users into 3? How do you ...