Using MS SQL Server

Secure Auditor, 30 security tools at the price of one.
Hi folks, Go and get a copy of Secure Auditor which is a unified digital risk management solution and provides 30 tools in 1 package. It performs scan and audit windows, oracle, Cisco router and MSSQL from single console. It helps you to identify the weakest link in your network and enforce compliance, penetr... 14 Apr 2008 03:06

Secure Auditor, 30 security tools at the price of one.
Hi folks, Go and get a copy of Secure Auditor which is a unified digital risk management solution and provides 30 tools in 1 package. It performs scan and audit windows, oracle, Cisco router and MSSQL from single console. It helps you to identify the weakest link in your network and enforce compliance, penetr... 14 Apr 2008 03:06

Connection String on shared server- Almost there but need a little help
Using asp and SQLserver2005 on shared server and with connection string: <connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=HYDROGEN;Initial Catalog=dbred;Integrated Security=false;User Id=theuser;Password=blahblah;" providerName="System.Data.SqlClient" ... 13 Apr 2008 11:55

Please recommend SQL book with excercises
I have beginner knowledge of SQL (I use MS SQL Server). I recently finished "SQL for dummies" book and now need something more advanced with a lot of exercises writing queries. Can anyone recommend such a book? ... 14 Apr 2008 10:33

Handle Triggers in MS Access 2003 with SQL Server as Back-End
Hi! I have a trigger created for Customer table. My front-end is access. What is the best approach to handle a trigger result when adding a new customer record? Below is the trigger script: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - CREATE TRIGGER ... 19 Apr 2008 04:12

T-SQL Duplicate Record Help
I want to check the data from an invoicing database for possible duplicate invoices. I have created an example script below. I want to return rows where there is a match for both reference_ and value_, so in this example in my SELECT statement I only want to return the two rows that match on both referenc... 12 Apr 2008 23:49

default value wich is not in DDL.
Hello!!!! I trying to put Null default value wich is not in DDL. Because when user not select value from DDL that records not saved in SQL base. I hope You understand what I mean best regards lop ... 12 Apr 2008 22:14

DataServices World program: SOA data modeling, data services architecture, LINQ, ADO.NET, Entity Framework and more
DataServices World is a conference that focuses on service-oriented architecture (SOA), data services and data access. It runs June 24, 2008 and is co-located with SOAWorld 2008 at the Roosevelt Hotel (45th and Madison Avenue) in New York City. The DataServices World faculty includes an ACM Fellow, the lead ar... 11 Apr 2008 03:42

An sql dream - thinking in terms of order AND sets at the same time
How would you like to create sequential lists in a query? Think of the possibilities that this ability brings. You could actually explain and illustrate how queries really work. It's like taking an x-ray of your query! It's working with two types (tables and lists) for the price of one :-) SET-ing your query in ... 13 Apr 2008 06:56

Constipated publisher (SQL 2005)
We have a 2005 Publisher that is publishing to one 2005 subscriber and two 2000 subscribers. It's been fine, but yesterday I had to import some data into one of the tables that is being published. The data isn't huge in terms of number of rows (less than 3,000) but each record contains a lot of data. Since import... 10 Apr 2008 02:05