Anyone able to point me to a page on upgrading from SQL Server 2008 Developer edition to SQL Server 2008 R2 Developer edition. As usual, the MS site...

Diesel@srn.invalid

07-04-2010 11:33 AM
Diesel@srn.invalid

Greetings all. Let's say I've got a database schema like this (with the all-capital terms in being the table name) in an SQLServer DB: = = = = = =...

Jeff Nyman

09-09-2008 12:00 PM
Jeff Nyman

I have Excel 2007 and Microsoft SQL Server 2005 Express Edition. I would like to know how to retrieve data from a Excel 2007 work book with SQL...

Scott

06-16-2008 05:58 AM
Scott

Please, could anyone tell me how to get information from which attribute of which table is the attribute from the view derived(it could also be...

Mario

05-24-2008 11:28 AM
David Portas

I know that in order to reduce network traffic you should always select only the columns you require but I have a stored procedure which must...

Danny Burton

04-29-2008 01:30 PM
David Portas

In SQL Server 7 and 2000, the MSDE provided the SQL server agent, allowing me to set up jobs on the MSDE engine. With the advent of SQL 2005 and...

Gary Johnson

04-17-2008 07:17 PM
Knowledgy

can someone please help with a simple SQL command please I have a table open I want to copy the contents of one column (A) to another several...

Vass

04-17-2008 07:13 PM
Knowledgy

I'm trying to recover as much as possible from a database that has become the victim of data corruption on disk. The database uses simple recovery...

Lucvdv

03-31-2008 08:49 AM
Luc

I am not familiar with databases, so I am hoping someone could help. If some records in a table sometimes get deleted, their IDs...

Jack

03-03-2008 09:09 AM
Aidy

SQL Server Programming Issue -- Please help Can somebody tell me how I can save the results of a view into a new table? Thank you, Steve

Steven Skindell

02-25-2008 02:05 PM
David Portas

I have a table, the entry of which may or not relate to a row in another table. Is it ok to make that field a nullable foreign...

Aidy

02-16-2008 10:04 AM
Jack Vamvas

I've got a query for search function where I need to select the latest range of records for product codes and I'm using a...

masterslave

01-25-2008 08:13 AM
Jack Vamvas

I have inherited a SQL db and am trying to get some data from it. The issue I am having is that the data is broken down by year in tables (data2000,...

georgiairish@gmail.com

01-25-2008 08:03 AM
Jack Vamvas

Here is another site that I came across by American Consultants Rx that really helped me and my family deal with the high cost of prescription drugs...

apzc18ti

12-24-2007 07:32 PM
apzc18ti

In SQL Server 2000 Enterprise Manager, when I import tables to a database in which I have db_owner rights, the imported table's owner defaults to my...

tgashby@gmail.com

12-19-2007 02:50 PM
tgashby@gmail.com

In article <475d8a98$0$2284$4c368faf (AT) roadrunner (DOT) com>, jimrichards (AT) satx (DOT) rr.com says... Bad move posting a binary to Usenet...

Leythos

12-15-2007 08:35 PM
Leythos

When I write a Query from Query Analyzer, the output pane numbers each row in the Output so that you can tell exactly how many rows were returned...

Jim Richards

12-09-2007 12:47 PM
Jim Richards

How can I, logged in as sa, reset the password of a user (not a Windows user, a database user) to a known value in MSDE without knowing the old...

Don

12-09-2007 08:16 AM
Don

(I also posted this in the Excel programming group) We have an excel sheet that connects and pulls data from SQL Server 2005. We want to format and...

Sam

12-04-2007 10:13 AM
Sam

Hello, I have some questions regarding the SQL cluster that will be utilizing Domain Authentication. We have multiple child domains of school...

Saqib Ali

12-03-2007 11:32 AM
Saqib Ali

I need some help. I have two tables in the following format: ARSIA...

Gordon

11-15-2007 01:37 PM
Gordon

Hi, I am trying to create a database procedure that will produce a list of results based on a Google like search. e.g. "Frank Spencer" -car +BBC I...

Chris

10-28-2007 05:38 AM
infiraghu@gmail.com

I just made a major addition to the data in our database (SQL 7 with an Access 2000 front end). The users had been working with a set of 66,000...

Neil

10-24-2007 11:49 PM
Neil

Any good recommendations out there for books dealing with database design? We use MS SQL Server, but a generic db book will work as well. I'm...

Dave

10-11-2007 07:32 PM
Dave

Does SQL 2005 Serivice Patch 2 include Report Services Service Patch 2 or do I need to install them separately? I have both the database engine and...

Fayven Wren

10-05-2007 10:49 AM
Fayven Wren

On Sep 4, 10:50 pm, "Andi" <NOmgem35S... (AT) dslDOT (DOT) pipex.net> wrote: Which version of sql server you are using ? For the above requirement...

vijay

09-05-2007 09:47 AM
vijay

Hello. I have rows in a database that are grouped by a key value. They all have the same key value but some other columns on each row are not valued...

Walter Cohen

09-05-2007 06:16 AM
Walter Cohen

Hi, I've taken over an SQL server 2005 express database. The database has about 100,000 records in it. My client has asked me to pull out a subset...

Milagro

08-27-2007 02:09 AM
Ed Murphy

When I have any media open in Windows Media Player (WMP) is stutters or hooks. As soon as I close SQL Server Enterprise Manager the stuttering stops....

twiggzsa@gmail.com

08-07-2007 05:33 PM
GeekBoy

Hi, I don't know if these are stupid questions or not. 1. Does a view require any disk space in the database? Is it stored? 2. If not, does a view...

JT

06-04-2007 03:20 PM
Pranay Pandya

Probably one of the geekiest things I've ever done. Take a list of SQL Server keywords. Stick the words in a database table along with it's meter...

mjswart@gmail.com

05-25-2007 04:04 AM
Phil

Hello, I'm fairly new to SQL Server. I have a database already in MS Access, and want to import the structure (just the tables, not the data) into...

Phil

05-22-2007 08:20 AM
Phil

Hi there, I am using SQL 2000 and a database with tables. Somehow only database owner has permissions to it, select/read etc.although the...

Tester

05-08-2007 09:03 PM
Ed Murphy

I'm selecting from TableA into TableB (nothing fancy, just using "insert into") and TableB has an IDENTITY column. It is important that the rows...

Aidy

04-24-2007 10:31 AM
Aidy

Hi, I can't Copy a database from Sql Server 2000 to 2005. I am using the Copy Database option from Management menu. I want to transfer all tables,...

Johan Garst

03-27-2007 08:55 PM
Johan Garst

I have a field in a DB that I want to update with the contents of a text file. I retrieved the contents of the text file FROM the entry but now that...

Warren, John

03-12-2007 08:09 PM
Christian Donner

Hi, Can the pages that are shown by SQL Server 2005 reporting services be customised. The pages that are shown are rather "techy" looking. I want...

David Hyde

03-12-2007 07:32 PM
Christian Donner

Hi, My office are currently upgrading to SQL 2005, and as part of the upgrade process we would like to take advantage of the source control...

Nomad

03-04-2007 12:52 PM
David Portas

Hi, I am sure that I am overlooking the obvious. I am setting up a database and cannot connect to it from another computer (by Mgt studio or web...

Pachydermitis

02-20-2007 07:29 AM
Jens

Hi, I have a DB migrated from SQL Server 2000 to SQL Server 2005 and I have a strange problem that I don't find any reason. I make a simple SQL...

marzak@newhouseweb.com

02-06-2007 05:12 AM
Jens

I hope that I can get some help with database design. Specifically I have been working on a database which holds all company records in single...

Jester98x

01-26-2007 11:22 AM
Jester98x

A table has a field containing the date and time. Example 2006-2-20 08:11:44.123...field name is DateInitiated. I can extract the month, day and year...

Dale

01-21-2007 12:00 PM
Rik

Leythos wrote: I believe it's just CPU licenses (how can I tell?) What number of CALs would the problem appear at?

John Bailo

01-08-2007 10:27 AM
John Bailo

Everything I read says that SQL Server 2000 Standard edition can only address up to 2GB of memory. Yet, when I look at the Memory tab of my SQL...

John Bailo

01-08-2007 10:26 AM
John Bailo

Hi, I have installed SQL2005 and part of the install process I chose windows authentication for connection. However, when trying to connect it...

Nomad

12-16-2006 05:01 PM
Nomad

....with continued support for working with SQL Server and other databases. Altova is pleased to announce the availability of Version 2007 of...

announce@altova.com

12-12-2006 09:38 AM
announce@altova.com

I was registered in a class with Learing Tree for SQL Admin "531", but they called and stated that they did not have enough people enrolled to hold...

sid

12-11-2006 02:04 PM
sid

I recently just got a job diong callpdispatching for a major corp's IT division, in one of their offices. I've never known much about SQL and would...

Paul J. Perillo

12-09-2006 12:32 PM
Paul J. Perillo

We are still tunning a SQL 6.5 server and recently we have been having problem with the server completely freezing and locking users out of the...

svetelina@gmail.com

12-07-2006 02:23 PM
svetelina@gmail.com

Hello, We have been facing a problem for almost two months. All of a sudden, we got a 300% performance degradation in our ETL for some...

av_frco@hotmail.com

11-21-2006 08:56 AM
Peter Nolan