I am running SQL 2005 Express for development of a db that runs on the client's server on SQL 2008 Enterprise. The database traditionally has...

Neil

01-20-2009 04:27 PM
Erland Sommarskog

Take the chance of the Valenitne’s Day to show your love, appreciation, and humor for your love, family, and friends: “Clone” your lover to surprise...

maky

01-19-2009 11:28 PM
maky

I manage an application that consists of a web front end to a MS-SQL database for input of data. The application is in english and I only want it to...

mccreeryd@yahoo.com

01-19-2009 04:05 PM
Erland Sommarskog

Hi, I'd really appreciate some help here. I'm trying to write an online re- indexing script, and would like to to display the index data-type...

Jimbo

01-19-2009 03:57 PM
Erland Sommarskog

Hi. Could somebody explain to me how I structure my table relationships when I need to record when somebody searches on a category and finds...

pbd22

01-18-2009 08:05 AM
--CELKO--

Hello. I have to write stored procedure to find all rows in the table (Parent) that have references(children) in at least one table in...

Inna

01-16-2009 09:25 AM
Inna

I am building data for our Data Warehouse. Below is my SQL that I will use in our ETL to create the new table I wish to create for reporting. I have...

rcamarda

01-16-2009 01:29 AM
bill

I'm trying to copy data from a table to an identical table in another database. I have a query window in SSMS for the database I'm copying from, and...

Neil

01-14-2009 08:18 PM
Neil

Hello, SQL Server 2005 SP2 Connection : JDBC Inet opta When i am profiling statements sent by web server ( connection : jdbc inetopta driver) to...

M A Srinivas

01-14-2009 04:43 PM
Erland Sommarskog

Worked great. Thanks! "Chris.Cheney" <Chris.CheneyXXNOSPAMXX (AT) tesco (DOT) net> wrote

Neil

01-14-2009 03:30 PM
Neil

I am getting the following error messages from SQL 01/14/2009 11:37:14,Logon,Unknown,Login failed for user 'NT AUTHORITY \NETWORK SERVICE'. Reason:...

Bill

01-14-2009 11:58 AM
Bill

I have a stored procedure from SQL 7 that won't run in SQL 2005, and I can't figure out what the issue is. Can someone take a look at it and see...

Neil

01-13-2009 10:43 PM
Neil

Hi, I have a folder containing about 150 stored procedures. Is there a way - through batch or command file to execute all of them at once..execute...

tirath

01-13-2009 07:15 AM
Dan Guzman

Hi all, I am just swimming here with sql permissions. I am tryin to set up a synchonization with an Access database. Yes it's clunky, but for...

Pachydermitis

01-12-2009 06:29 PM
Pachydermitis

I have the following query: SELECT COUNT(tbl_Documents.UID) AS docCount, p.BranchNumber, p.NewBranchNumber, p.LeaseName, p.ID, dt.treecount FROM...

John

01-12-2009 11:26 AM
Plamen Ratchev

hi when i run the below code in a windows app or a console app notepad opens just fine when i run it from a Service it does not open in its own...

daveL

01-11-2009 06:58 PM
Dan Guzman

hello all... Im writing a Task Scheduling Service c# 2.0 Ado.net The Service will grab all the Tasks to Run once a day and manage Schedules locally...

daveL

01-10-2009 09:39 AM
daveL

please let me know about that solution From http://www.developmentnow.com/g/95_2003_10_0_0_0/comp-databases-ms-sqlserver.htm Posted via...

indika

01-10-2009 03:55 AM
Erland Sommarskog

I recently moved our database from SQL 7 to SQL 2005. I configured the maintenance plan in SQL 2005 and ran it. However, the server hung when...

Neil

01-09-2009 04:32 PM
Erland Sommarskog

I have sql2005 db (main) on one network and sql2000 (bogus) on the other, both are under W'2003, both servers see each other over tcp/ip. I need to...

migurus

01-09-2009 02:36 PM
sql_noob

Hello everyone. I just got moved to SQL 2008. Here is a very dumb question but does the Sql Server Integration Services (SSIS) have anything that...

eighthman11

01-09-2009 02:31 PM
sql_noob

Hi - how do I determine the default time zone for a given sql 2005 instance (that was set up a long time and that I wasn't a part of)? As in: if a...

patfla

01-08-2009 06:02 PM
Plamen Ratchev

Hi I'm using this interface to write SQL (and I'm new to SQL). I've received some code that is all upper case. Is there someway to convert it into...

FortisChet@gmail.com

01-08-2009 03:54 PM
Plamen Ratchev

I have several files with t-sql code. I want to create a one script in which I can execute code from these files. eg. create db //execute code from...

lszk

01-08-2009 11:49 AM
Plamen Ratchev

Hello, I am trying to free some space on the server by cleaning up tables that have unused(garbage) data. Here is what I do, but I would like to get...

Inna

01-07-2009 04:07 PM
Erland Sommarskog

Hello everyone. Resently started using SQL Management Studio. Here's the question. In the old Query Analyzer that I used to use there was a way to...

eighthman11

01-07-2009 01:23 PM
Hugo Kornelis

Hi, I have 2 SQLserver 2008 servers running a mirrored database I have another machine (client) with SQL Native client (2008) and...

Christian Tanner

01-07-2009 07:37 AM
Christian Tanner

Upgraded from SQL 7 to SQL 2005. Setup maintenance plan with backup. Got message: "Databases that have a compatibility level of 70 (SQL Server...

Neil

01-05-2009 06:13 PM
Neil

Moved db to new server on 12/26 (new server SQL 2005; old was SQL 7). MDF on new server shows Date Modified (in Windows Explorer) of date/time that...

Neil

01-05-2009 11:21 AM
Neil

I use thi GUI for Sql Server 2005 Express service pack 3. When I open a table as structure (context menu on table and click on "project" item), load...

Dedalus

01-03-2009 01:22 AM
Fabio M. ROSSETTI

Thanks everyone. I see the newer tables use uniqueidentifier as the data type for this key column. Jim

jgeissman@socal.rr.com

01-02-2009 06:13 PM
--CELKO--

I wrote a procedure to check, if specified table exists in db. create procedure spCheckTableInDatabase( @TableName nvarchar(50) ) as begin select...

lszk

12-29-2008 04:34 AM
Hugo Kornelis

To the OP: I am assuming that you have been given a file of customers to load, and this can serve as grist for your SELECT statements. If this...

bill

12-28-2008 06:43 PM
bill

I have only used hints a few times and it has been a while. Every time I try to play with an SQL statement to force use of index over a non-indexed...

Mark D Powell

12-15-2008 04:16 PM
Hugo Kornelis

Hi. I have recently added the ASPNETDB tables to my database so I can take advantage of autentication / roles / groups and so on. From the online...

pbd22

12-12-2008 07:57 PM
Oscar Santiesteban

M.T.09.05-08.Tanskan insinööriliitossa uskotaan uusiutuvaan energiaan "Energiasuunnitelma 2030"- nimisen raportin (ES). Sen tekoon osallistui 1 600...

Henrik Lehto

12-12-2008 03:45 AM
Henrik Lehto

Hi, I'm working on a questionnaire which will include multiple input types (check boxes, drop-downs, textarea) to submit answers. Currently, in my...

ll

12-11-2008 07:52 PM
ll

I recently started at a new company as their DBA. In looking at their databases they have indexes that are all non-clustered (including PK's). ...

C-Note

12-11-2008 04:52 PM
Erland Sommarskog

Could someone help me to get my table to look like this with the dynamic pivot table with the months being generated across the top? The fields that...

JJ297

12-11-2008 12:41 PM
JJ297

MS SQL Server 2005 9.0.3054 64-bit Does anyone have experience using the MS SQLS Server 1.2 JDBC Driver? Since upgrading from the 1.1 driver, we...

aj

12-11-2008 11:48 AM
aj

One of our SQL server CPU went up to 95% and it seems this query was responsible for it. The first query is from a php code. But I am not sure where...

Tux Tango

12-06-2008 07:06 AM
Erland Sommarskog

I'm having a mental block about how to make a view displaying the records I need that's editable and not read-only. Given the following basic table...

Bernard West

12-05-2008 03:36 AM
Bernard West

Hi! Simple questio - how to add rows to table in Microsoft SQL 2008 Server. I don't mean by executing query (INSERT INTO...), but by clicking...

krzys

12-04-2008 08:54 PM
steve

Thanks for the suggestions. I think I will get PostgreSql -- I believe it has good geographical data capabilities, which will be useful to me. In...

JG

12-04-2008 08:03 AM
Tom van Stiphout

Hello, Query Analyzer had two command: 1) Ctrl+Shift+C -> Put Comment 2) Ctrl+Shift+R -> Remove Comment Which are the command within SQL Server...

m

12-04-2008 06:39 AM
Plamen Ratchev

Hi guys, I have a Projects table, with ProjectID being the primary key. My report lists all projects. So, select * from Projects. However, I join...

Cralis

12-01-2008 06:47 PM
Cralis

MIS Magazine has recognised Yellowfin Business Intelligence as a rising star with inclusion in its strategic 100 list for 2008. The MIS Strategic...

JP

12-01-2008 05:31 AM
JP

I have table update two colunms at a time . pls anyone send me query thanking you surya

surya

12-01-2008 12:19 AM
Plamen Ratchev

Hi everyone, 5 samples are analyzed for lead in three different tests. Not every sample is necessarily analyzed in each test, resulting in gaps in...

john.wb@assaynet.com

11-30-2008 04:44 PM
steve11228@gmail.com

Hi, I encounter a weird locking problem but it does not seem to be a deadlock problem. My server program is written in Java with JMS (activeMQ) and...

Hacking Bear

11-29-2008 06:24 PM
Hacking Bear