Using MS SQL Server

DBCC TRACEON did not capture info on deadlocking
Hello, I tried to troubleshoot a deadlocking issue with the ETL jobs. And I enabled tracing through DBCC TRACEON (1222, 1204, -1). I can see that it is on when I do DBCC TRACESTATUS. But it captured NO deadlock information. Why it did not trap any info? And is there any other alternatives I have in capturing t... 5 Aug 2010 18:01

100% without investment online part time jobs..(adsense,datawork,neobux..more jobs)
100% without investment….no registration fee…no need money… Online part time jobs…(googleadsense, dataentry…etc)all type of jobs… work from home..daily 2-3 hours…earn more money without any risk.. Full details at http://adsensejobworkfulldetails.co.cc/ More adsense tips,secrets,increasing money ,seo..a... 5 Aug 2010 01:35

linked servers between different sql versions??
Can a SQL Server 2008 server have a linked server that is SQL Server 2008 R2?? We presently use a SQL Server 2008 for reporting which links to a SQL 2005 server that will be replaced by a SQL 2008 R2 server, we need to link to a SQL Server 2008 R2 database from a SQL 2008 server. Note: The linked server is onl... 4 Aug 2010 15:47

Java/J2EE - Sr Developer, SFO
Java/J2EE - Sr Developer Location: SFO Duration: 3 Months + JDK 1.5, JSP, Servlet, Struts 2.0 or above, Oracle 10g, PL SQL, please send your updated resume to jobs(a)mapleresource.net ... 3 Aug 2010 12:31

SQL Server Full Text Search Indexed View
Hi everyone, I want to use the Full Text Search feature of Microsoft SQL Server. If I have a table Client which refers other tables like City, Country, Department, etc. is it better to create a separate table that would hold de-normalized data, which would then be full text indexed, or is it better to create a... 3 Aug 2010 09:13

Cheap Wholesale Soccer Shoes (paypal payment)
Cheap Wholesale Dior Shoes (paypal payment) (http://www.24hours-buy.com/ ) Cheap Wholesale Coach Boots (paypal payment) Cheap Wholesale Gucci Shoes (paypal payment) (http://www.24hours-buy.com/ ) Cheap Wholesale GUCCI Boots Cheap Wholesale Lacoste Shoes Cheap Wholesale LV Shoes ... 3 Aug 2010 01:39

SQL server messed up after installing Foxpro 9
I have some software that uses SQL 2008 on my Win Vista Enterprise machine. This morning I loaded Foxpro 9.. which was upgrading 8. Now as I try to connect to the sql server it renders a timeout expired error. When I get in query anaylizer I changed the timeout to >5 seconds. It will now connect after approx 30... 3 Aug 2010 02:44

Extracting Image datatype content with SQL2005?
I am cross posting this request for help in both the C#,NET and the SQLServer newsgroups in he hope that some reader of one these newsgroups can offer some help. I am well aware that the image datatype (as well as others) are being phased out in some future version of SQL Server. For that reason, in all of my pe... 1 Aug 2010 15:54

Simple (?) SQL problem
G'day, I've got a feeling this is a dead-simple problem and I'm going to be embarrassed by the answer, but here goes... I have a table "tblDocumentVersion" which has these fields: * "VersionID" which is the primary key * "DocID" which is a foreign key pointing to tblDocument * "Version" which is a textual ... 31 Jul 2010 09:37

Creating a New Project
Dear All: I am using SQL Express 2008 and working through the tutorials. So far, I have been able to do everything although occasionally, the system and the tutorial do not quite match. I am stumped now though. "Using Script Projects and Solutions To create a script project and solution 1. Open Mana... 31 Jul 2010 05:20