We just moved our SQL 2000 databases to a new SQL 2008 box. After the move, we bound the IP address of the SQL 2000 box to the new SQL 2008 box. This works, except in a VB6 application running on a Windows 2000 SP4 box where we are getting the error: "Query cannot be updated because the FROM clause is not a single simple table name" ...
I have a text file with 5 columns and a variable amount of rows. What would be the easiest way to grab the first row of the text file and set 5 different variables in SSIS to the values of the 5 columns in the first row? ...
Hello Everyone, I am wondering how can I create Cross Tabs queries with SQL Server 2008. I have fields for Job Numbers and Employees and I want to show that how many hours an Employee has worked on the specific job. For sample, this is what I want. link text I tried PIVOT but that didn't work for. Later I want to export this data to EX...
Hi, I am trying to learn SQL on SQL Server and several functions/SPs require parameters. For example, when I enter "exec sys.fn", the intellisense brings up various functions/SPs and some have brackets which describe parameters. How do I pass the parameter in? Although I saw some examples, they were for custom SPs so I couldn't quite a...
Say, I have two users (U1, U2) mapped to two resource pools (R1, R2) and with max values as 20% and 80%. U1 executes a time consuming query that runs for say 15 minutes. When it started execution it was the only process and hence SQL server allocates full resources to this query. 5 minutes later U2 executes another query. Will Resource G...
I've recently been assigned the task of updating a "legacy" database (previously managed by an ex-coworker who left the company a while ago). The new database has the exact same structure as the previous one; the only difference is in the content itself, as this database now has more recent data. The problem is that the old database ha...
Hi guys I have a problem with a FTS on SQL Server 2008. First I am not an expert in that field. The problem is as following. I have a row with column value 'This is it aka Michael Jacksons's This is it'. When user enters in a search box term "This is it" following query returns 0 results. SELECT column_list FROM tabla_name...
Hi, I'm trying to restrict access to a database on my server to only allow users from a specific Windows group. I have enabled Windows authentication for the server, but it seems as if I can only allow access to specific users, not specific groups... is there any way I can do this? Most of the resources I've found contain SQL Server 2...
Hi, I'm trying to debug a deadlock with SQL Server Profiler 2008. I know how to get a graph of the deadlock in the profiler, but when I hover over one of the two statements in shown in the graph, the "Statement" tooltip that appears only contains the query with parameter names, not values. In other words I get tooltips like this: DE...
Our database is currently at 64 Gb and one of our apps started to fail with the following error: System.Data.SqlClient.SqlException: Could not allocate space for object 'cnv.LoggedUnpreparedSpos'.'PK_LoggedUnpreparedSpos' in database 'travelgateway' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files...
HI, I've got Windows XP Mode running on Wndows 7 Professional x64. I have an instance of SQL 2008 running on Windows 7 which I would like my copy of VS2010b2 Pro running inside WinXPMode to see. However, I cannot figure out the right combination of networking and firewall adjustments to make. Below is what I've done so far. Can som...
Hi, I'm trying to analyze a deadlock in SQL Server 2008 profiler. I know how to find the offending sql queries, but the collected queries do not include parameter values. I other words I can see something like this: DELETE FROM users WHERE id = @id But what I would like to see is this: DELETE FROM users WHERE id = 12345 I guess...
I am trying to connect to a SQL Server 2008 instance from a Windows Azure worker role (it's not SQL Azure, but a remotely hosted SQL Server 2008 Standard Edition), but I get the following error message System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server....
I develop news search engine with C# and SQL Server 2008 i using SQL Full text search for search and it's ok until some week ago. currently i have more than 100 million record, that daily added about 1 million article. but i see sometimes when user search, one of 8 CPU become 100% and take some minutes. after repopulate catalog, it's o...
Hai guys, I installed sql server 2008 and i cant view table data .. When i rightclick on the table it shows select top 1000 rows,edit top 200 rows... How to view all the rows of my table... ...
Hello, I have installed SQL Server 2008 Developer on Windows 7 64 bit. In Management Studio I cannot register the default instance MSSQLSERVER, it cannot find it although the service is running. I get the message: Cannot connect to PHOENIX\MSSQLSERVER. A network-related or instance-specific error occurred while establishing a connecti...
Hi, I'm looking for sample database including spatial data. That can be also oracle-equivalent,convertable to sql server 2008 Related : http://stackoverflow.com/questions/57068/good-databases-with-sample-data ...
i have a table with columns A and B which are correlated in the following meaning: A == 1 => B == 3 A == 2 => B == 0 A == 3 => B == 7 with => meaning implies with high probability. I want to query like this: where A = 2 and B = 3 --very few rows should match so i have created statistics on (A, B). however the query optimizer comple...
Hello, I need help with this scalar-valued function. What I want to do is to return the value I get in MaxValue on the line max(Value) AS MaxValue. The query works and will only return 1 value if ItemId and ListPropertyId exists, but I am not able to create a function of it. CREATE FUNCTION GetLpivMax ( -- Add the parameters for ...
I'm developing an application in C# that will use and store geographic locations using the data type "Geography" in SQL Server 2008. I was planning to use the Entity Framework but soon discovered it lacks support for spatial data. Does anyone have experience with or know of other OR mappers with spatial support? The system will have few...