Apologies if this is a dumb question, but is there a way to extract the contents of SQL Server's Design Table display to use in a printed document (Word, say)? Cheers, Dave ...more >>

Hi All, I've been trying to implement the sample Report Services Printer Delivery extension. I've been through the tutorial and haven't been able to add the following security code group (shown at the bottom) successfully, since there is no indication of where this should go or why. I not...more >>

Dear all, I just want to ask you a question (maybe it is very simple to you) : (1) I used "SQL Server Business Intelligence Development Studio" to create some 2005 Reporting Server reports, how can my users make use of them, or what programs or tools they can read these reports ? Excel ? ASP...more >>

Hello, all. On SQL Server 2000 SP4, I've set the recovery model for a 3 GB database to full, scheduled a daily database backup for 10PM, and scheduled hourly transaction log backups. Everything seems to be working OK, however I am concerned that the transaction log backup which occurs roughly co...more >>

Summary: to enable Service Broker, one needs to ensure that all connections to the target database are closed. I restored a copy of a development database from a backup of the live database (SQL Server 2005 Express) and fould that SQLCacheDependency didn't work in ASP.NET 2.0. The error messag...more >>

Hi, I have a question about designing a database. If this newsgroup is not for this question please forgive me. I want to create a database for a test done on patients. This test checks near 500 parameters on every patient. I create a table with 500 fields. Primary keys are ID of patient and ...more >>

Hi all :) My apologies if I posted in the wrong groups, but I just jumped in MS SQL waters, so any guidance will be appreciated. What I'm trying to do is the following process: [1] present operator with a web page (script) [2] once filled with db name and username, script will create ....more >>

We have a 15 GB SQL Server database and our hosting service made a backup file of it that we want onsite. The problem is that it is 15 GB and we don't have compatible tape drives. How do you copy a large 15 GB file to DVD or CD? Is there any way to divide up files onto multiple discs? Do yo...more >>

I have a database running on a MS Sql Server 2000 sp3a and need to export the schema. What is the best way to do this? Thanks ...more >>

In MS SQL 2005 when you do a Full Backup does it also backup and truncate the transaction logs or do I need to back the transaction logs up separately? Thanks. Brian ...more >>

Hi, I have a problem with optimising a database view that I would like peoples opinions on. I have a database view (in SQL Server 2005 SP2) that is quick when I do not perform an ORDER BY on it. However when I apply an ORDER on a single column returned from the view, the speed of the quer...more >>

I want to use this simple query: select distinct(date) from mytable. However, the database column contains date and the time associated hence returns me multiple records for the same date. Is there a function or some other way in which I can filter out the time and use the query only on the...more >>

Our company has been using an Access 2003 application split into a front-end / back-end configuration. The back-end currently resides on our network and each user has a copy of the front end. The plan has been to migrate the back-end to SQL Server 2005 and continue to use the Access applicatio...more >>

HI All, I'm trying to produce a report, but I'm having trouble with a field which contains numbers and semicolon separators the filed looks something like this... 38100 4400 4430 4400;4430;4490;45000;4520;45510;4511 3841 4430 48400 4400 I need to find every occurrence 4430 and 4500...more >>

Hi, I'm using Sql server 2k and have a query with a drived table. Query contains applicant, applicationdetail and contact tables as follow: Select Application.Number From Application Join ApplicationDetail on Application.ID = ApplicationDetail.Applica...more >>

Hi experts, is there any external tool or feature within SQL Server 2005, which enables a searchable documentation of schemas? What I would like to do is to add descriptions to tables, columns and foreign key relations describing their meaning in detail. By the term "description" I do not m...more >>

Hello, i am modifying an insert trigger created by the up-sizing wizard that = creates a random primary key. I would like to keep any key values import= ed = from another table- only using the randonm key for new records not in t= he = old imported tables. I would like the state...more >>

I've scoured Google searching for an answer that seems like it should be easy but apparently isn't...when I open SSMS to connect to a SQL 2005 database and choose Windows authentication, it greys out the User Name box...problem is, the server I need to connect to is in another domain...how o...more >>

I am using sql server 2005. I created a stored procedure, but it's executing but not returning expected result. If am executing the query part only from query designer, its working fine. why this is happening ? Somesh ...more >>

Hi, i want to join two tables together :) t1: k1| x --+-- A | 1 B | 2 C | 3 t2: k2| y --+-- A | 4 D | 5 E | 6 Outer Join T1 to T2, so that i get: (- represents NULL) SELECT t1.k1, t2.k2, t1.x, t2.y FROM t1 FULL OUTER JOIN t2 ON t1.k1 = t2.k2 k1| k2| x | y --+---+--...more >>

Hello, When trying to add new index to a table the New Index is grayed, why ? Regards, NK. ...more >>