Using MS SQL Server

Documents select
Hi, I store data about documents in a table. The documents belong to company employees, and have two attributes: document type and expiry date. So the table structure: DocID, EmployeeID, DocumentType, ExpDate When a document expires (or will expire soon) a new one is added with a new exp date. So there can b... 2 Apr 2008 08:58

SQL Assistance required
I am trying to obtain some data and I have a way to do it however it appears really longwinded and I'm sure there must be a better way to get this using a join of some type without such a complex statement. tbl1 -------- sid role_id tbl2 --------- sid region_id in tbl1 I have two types of roles What... 13 Apr 2008 22:20

Error History?
Is there a place where SQL Server logs errors? When I run my Access MDB against a SQL 7 back end, I get ODBC errors, which are sometimes a little descriptive, sometimes not at all. I usually have to execute code directly against the back end to find out what's really going on. And that's if I'm able to reproduc... 2 Apr 2008 03:15

Deleting multiple columns from multiple objects
Is there a way to delete from multiple tables/views a column with a specific name? For example, a database has 50 tables and 25 views all have a column named ColumnA. Is it possible to write a simple script that will delete every column named ColumnA from the database? Seems to be it would be possible and I can... 2 Apr 2008 17:55

Help needed with TSQL statement
Hi all, I have a booking table that records changes to bookings to give an audit trail. Table1 ID - is an Identity column. BookingID - is a varchar column containing the booking id of each booking. Comment - is a varchar column containing details of the booking changes. dtTime - a datetime column contain... 1 Apr 2008 19:34

SQL Server - synchronizing database changes across servers
On Mar 28, 3:33 am, Erland Sommarskog <esq...(a)sommarskog.se> wrote: javelin (google.1.jvm...(a)spamgourmet.com) writes: I was under the impression that replication would produce a complete copy. I want to leave objects alone so that I can propagate only data changes at times, and at other times, only st... 1 Apr 2008 17:21

from 'image' to 'varbinary(max)'
Hi I moved to SQL Server 2005 (from 2000) and noticed there is a better variable to deal with binary arrays. I hava a table that hold 9 columns of images (BLOB). each array has a different size and can be larger than 4k. I've changed the column data type from image to varbinary(max). After the chnage, the size ... 1 Apr 2008 17:54

Mimic Windows Explorer sorting by filename
Hi all, Does anybody know if it's possible to mimic the window explorer algorithm (which I don't know) to sort by filename from SQL server? Suppose I have a table with the field "myFileName" and I want a resultset sorted by that field. SELECT * FROM myTable ORDER BY myFileName but I want the resultset order... 1 Apr 2008 11:13

Default storage space - DB engine tuning advisor
Received this error when running the DB engine tuning Advisor (DTA) The minimum storage space required for the selected physical design structures exceeds the default storage space selected by Database Engine Tuning Advisor. Either keep fewer physical design structures, or increase the default storage space to be... 1 Apr 2008 11:13

What does it mean to SET a value?
What does it mean to set a value or April fools all year long :) http://beyondsql.blogspot.com/2008/03/sql-what-does-it-mean-to-set-value.html ... 4 Apr 2008 05:51