Hi, I'm working on a knowledge base project using SQL Server 2008 Full Text Search Engine. Project included in articles and files where each article has multiple files.In those articles whole content is pure html. Right now,I successfully created fulltext catalog and index on SQL Server 2008 and my database is version 10 compatible. H...
How we can harden sql server 2008? Is there any detailed article on hardening of sql server 2008? ...
There's an app that starts a transaction on SQL Server 2008 and moves some data around. Then, while the transaction is still not committed, the app prints out some labels. It is very important that the transaction is not committed until printing succeeded; if a printing error occurs, everything is rolled back. Now, the printing engine i...
I have data coming in from datastage that is being put in our SQL Server 2008 database in a table: stg_table_outside_data. The ourside source is putting the data into that table every morning. I want to move the data from stg_table_outside_data to table_outside_data where I keep multiple days worth of data. I created a stored procedu...
The password field in my user table (SQL Server 2008) is encrypted using HASHBYTES on insertion. I have a stored procedure with parameters for the username and plain-text password which does a SELECT using that username and the password sent through HASHBYTES, then returns the user record if it finds a match. The SP is always returning...
I have a deceptively simple SQL Server query that's taking a lot longer than I would expect. SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT COUNT(DISTINCT(guid)) FROM listens WHERE url='http://www.sample.com/' 'guid' is varchar(64) NULL 'url' is varchar(900) NULL There is an index on guid and url. There are over 7 million ...
I have create my code in order to write images in a remote sql server All the details of accessing and writing are fine until now, including the system account right now i'm in the command of: SqlFileStream = New SqlFileStream(filePathName, fileToken, FileAccess.Write) and when i'm trying to execute it the Server returns the error 'A...
In SQL Server 2008, I am using triggers to capture all changes made to a specific table in my database. My goal is to capture the entire change. That is, to capture what data is being inserted, not just that data is being inserted. In the trigger I am using the EventInfo column of the result set returned by DBCC INPUTBUFFER to get the...
would it be possible to upgrade SSAS 2005 to SSAS 2008 only? ...
dear sir, i have table1 in filegroup1 and when i use "select * from table1" Query then error message out The query processor is unable to produce a plan for the table or view 'table1' because the table resides in a filegroup which is not online. What is the solutions ...
Hi there! First off I´m new here, so, I'd say HELLO EVERYONE and thanks for years of helping. I have the following problem: I need create a installation of a C# app that uses SQL Server 2008. I am using InnoSetup Installer because I thought it could be the best choice, but I have no clue how to install SQL Server 2008, and several dat...
I have the following output from a view: xfer_id client_plt_id xfer_doc_no 2255 80016616 KANORANJE1 2270 80016616 ORANJECFC1 2285 80016616 CFCFPT1 2285 80016623 CFCFPT1 2270 80016623 ORANCFC1 2255 80016623 KANORANJE1 2255 80016630 KANORANJE1 2270 80016630 ...
Hi, I have a question about scheduling a rebuild and reorganize of a SQL Server 2008 Full-Text Catalog. When I go to the catalog's Properties then Population Schedule, the wizard seems pretty straight forward except for I don't see a way to specify that I want a rebuild rather than a reorganize. I wanted to schedule a reorganize to be...
Hi everybody, I'm currently working with Microsoft SSIS and SQL server 2008 and I would like to write logs to a file using : Specific log pattern : Formatted Date - Log Level : Log Message Specific log levels Error Codes that are associated to error messages in a configuration file I was wandering on the Web looking for a solution...
Hi, We have migrated our db from sql2000 win server 2k to sql2008 win server 2k8. We have linked server from sql2000 win server 2k. By our opinion the problem is with DTC and we have made a lot of setting that we found as solution for our problem, but still the problem exist. There is no any error or worning or information niether in th...
I'm trying to execute a MERGE statement via a Execute SQL Task, as outlined in this article: http://technet.microsoft.com/en-us/library/cc280522.aspx My MERGE statement is quite simple (see below). I can execute the MERGE statement with no trouble in SSMS, but when I put it into an Execute SQL Task, it fails with this error: "Incorrect...
Hi All, I am facing issues connecting to SQL Server 2008 from WSAD 5.1.2 ( WAS version 1.5.1.1 ). I am using Microsoft SQL Server 2005 JDBC Driver Version 1.2 on JRE 1.4.2 for the same as Driver Version 2.0 for SQL Server 2008 is not compatible on JRE 1.4.2. The database connection is being established but while retrieving the data I ...
Dear Gurus Today I found a strange problem that is I have a Table With a Nullable Column and I tried to use following Query SELECT * Id, MyNCol, FROM dbo.[MyTable] WHERE MyNCol <> 'MyValue' And Expecting it to return all rows not having 'MyValue' value in Field MyNCol. But its not returning all those Rows Containing N...
Hello everyone, I am developing using VSTS 2008 + C# + .Net 3.5 + ASP.Net + SQL Server 2008 Express. I am working on 32-bit platform with Windows Server 2003. The issue I find is simple SQL statement like select/create a simple table is very small from SQL Server Management Studio. BTW: I think it should be machine specific issue since...
I am using SQL Server 2008 Reporting Services and set mode remotely. All is going fine and reports running on my machine. I am not using report viewer control, but switch to browser. Problem is that when I access the report from any other system in browser by providing required url. I m getting the following premission error: Serve...