I am running on VS 2005 and Sql Server 2005 and trying to deploy my project to Analysis Server and I get the following message: The project could...

tshad

07-31-2010 07:51 PM
tshad

Hi, We have 2 servers: PRD and DEV (PRD has 2 extra weeks of data).This is my query: SELECT COUNT(*) FROM...

hayko98

07-30-2010 12:21 PM
hayko98

Every night at about 10 pm (2000 hours) on our SQL 2005 since about 7/21 or so we have got this recurring error in our SQL server logs: 07/22/2010...

tom12010

07-30-2010 10:03 AM
tom12010

Hi, Does anyone know the diff between SQL2008 32 bit adn 64 bit. What kind of situation the we need to have WIN 64 bit + sql server 64 bit? Thanks,

Mecn

07-30-2010 08:33 AM
Mecn

Hi How to enable XP_CmdShell in SQL Server 2000 as I ran the following script to enable EXEC MASTER.dbo.SP_CONFIGURE 'Show Advanced Options',...

Muhammad Bilal

07-29-2010 04:15 PM
Erland Sommarskog

I have a database which is 2 GB but the log file has grown to 35 GB. I would like to truncate the log so I set the recovery method to SIMPLE but the...

Rich Lawson

07-29-2010 10:55 AM
Rich Lawson

I have a query that runs against a linked server (tables are in dBase). When I run a simple select statement against one of the tables, I get an...

Jerry Haynes

07-28-2010 04:54 PM
Erland Sommarskog

Hello Periodically, some of the records in one table have one field updated to the following value: <!--<1586567094>--> It is the most bizarre...

Mike Myers

07-28-2010 11:20 AM
Dan

After a failed update to SQL 2008 SP1 + CU8, I restored master, and then tried to do a repair on the install to make sure I was back to SP1 only. I...

David Hay

07-28-2010 08:59 AM
David Hay

See DDL below. This represents a very simplistic view of my client's system, in which there are actually about 95 tables and nearly 50 views. The...

Edward

07-28-2010 04:05 AM
Edward

I have 3 jobs in My maintenance plan. The jobs are connected by precedence constraints. In each case, the constraint is set to completion. It...

RG

07-27-2010 11:25 AM
RG

I download SQLEXPR_x86_ENU.exe (sql 2008 express sp1)from microsoft but do not know how to install sp1 from this exe file. Can someone help me? Is...

aspfun via SQLMonster.com

07-27-2010 04:12 AM
Dan

I have the following query. I would like 'createnamerole' to become the columns and 'ordersourcedesc' to become the rows with the count values...

Qaspec

07-27-2010 03:39 AM
Erland Sommarskog

Hi, I have over 8 years of IT experience but very new to the Data Center space and have 4 questions. If someone can answer, I would...

Hemanshu Ahuja

07-27-2010 01:39 AM
John Bell

Why is SQL Server 2005 open 40-50 threads for same SPID for a given database at times and goes back to sleep and will have only 2-3 threds per SPID...

Bero

07-26-2010 06:11 PM
Bero

I have a db which originally occupied 80 gig. I have deleted 80% of the rows in the db. After, I ran reindex and defrag. However, the db...

RG

07-26-2010 03:31 AM
Dan

Brushes and combs are used to organize and untangle the hair, encouraging all of the strands to lie in the same direction and removing debris such as...

Amily

07-25-2010 10:07 PM
Amily

Is it possible to write a script that, as its input, takes the name of a stored procedure, and, as its output, produces a table each of whose rows...

Behzad Sadeghi

07-25-2010 05:34 PM
Behzad Sadeghi

Bero (robertatnova (AT) gmail (DOT) com) writes: Replication could have been an issue if it had been the log file. You can find out which are the...

Bero

07-24-2010 11:56 AM
Erland Sommarskog

I have done a rebuild indexes using a new stored procedure (with a cursor) for some of the user databases via SQL agent and it failed after few...

Bero

07-24-2010 05:53 AM
Erland Sommarskog

I just signed up with a client to help them with the performance of their SQL Server 2005 application. A check of sys.indexes on their database...

Behzad Sadeghi

07-23-2010 04:37 PM
Behzad Sadeghi

I have a new install of Server 2003 with SQL Server 2008 ... How do I get the Object Explorer to display in the Management Studio. Selecting F8...

barnicoat

07-23-2010 03:18 PM
mhork pheus

Hi All, Since last 2-3 weeks, our system has been experiencing issue of deadlocks and slow performance. The configuration is SQL Server 2005 SP3 64...

Malkesh

07-23-2010 08:06 AM
Erland Sommarskog

I am planning to creae a DBA document that lists all SQL Servers, db configurations, etc. Does anyone can point me to a sample template doc and also...

Bero

07-22-2010 04:50 PM
Bero

on sql server 2000, I have a table has a datetime field stored date, e.g. 2010-07-21, and another datetime field store time, e.g 23:00, i need to...

tulip

07-22-2010 04:05 PM
Gert-Jan Strik

Theoretically, we have 24x7 system. However, there are times of a day when there is little or no activity. The database is extremely overallocated...

RG

07-22-2010 03:31 PM
Erland Sommarskog

I am using the following query select 'level' = case when dbo.function1 = 1 then ( case when ( dbo.function2(dbo.function3, 1) > 0) then 3 end )

cheenujunk

07-22-2010 03:30 PM
Erland Sommarskog

Hi SQL Monsters I am having an issue using the format file that I generated using bcp. I am using SQL Server 2005. I cannot figure out why it doesn't...

Mitchell_Collen via SQLMonster.com

07-22-2010 03:27 PM
Erland Sommarskog

Hi Guys, For sql server 2005/2008, is there any way to track transaction activities in transation log? Let's say if I want to know the size on how...

Iter

07-22-2010 12:27 PM
Iter

Hi, Could you give me an advice what are different between MSSQL$SQLEXPRESS and MSSQL SQLEXPRESS? Sorry I am not good memory :"( Thank you all.

MN

07-22-2010 08:28 AM
MN

I am limited in my testing environment, so I am trying to validate my findings via this post. I am trying to understand: (1) if the size of the log...

cbrichards via SQLMonster.com

07-22-2010 06:35 AM
Andrew J. Kelly

as I can find the tables have a view? that is, if I have "select * from vFacturas" how I can find the fields and tables for each field? thanks

Miguel F

07-22-2010 04:37 AM
Erland Sommarskog

-- Thanks & Regards Malkesh

Malkesh

07-21-2010 05:12 PM
Malkesh

Hi, I'm using MSSql Server 2005. My client is Oracle SQL Developer on Mac 10.6.3. My problem is that I'm trying to get the execution plan for...

laredotornado

07-21-2010 04:38 PM
Erland Sommarskog

Hi all, i found that the sql server cluster failover from node A to node B slow i saw the cluster log show below error, and we haven't set the...

ken

07-21-2010 02:02 AM
ken

I need to send emails to locations which come up in the query SELECT ,,,, FROM ' , each location shud get there own information emailed to...

dtrivedi

07-20-2010 03:47 PM
John Bell

Hello, I am looking for a way how to select field value, if the table and field name both are available as string parameters. I am aware that in SP...

Passiday

07-20-2010 03:32 PM
John Bell

Just curious if any of you run/have run SQL Server in a virtual environment and what your opinion is on doing so?

Matthew

07-20-2010 03:03 PM
Matija Kapraljevic [Revenger]

Does anyone know a free program that will repair coruppted sql databases (mdf files)? All I see on the net is paid ones. Thanks Dave

DCR

07-19-2010 10:37 PM
DCR

erver windows 2003 sp1. 64 bits, Paging file size for selected drive C is (custom selected) Initial 2046 MB, and maximum 4092 MB. It is currently...

DoleBludger

07-19-2010 04:46 PM
Erland Sommarskog

Please suggest me what kind of data type can I use in SQLServer that supports numbers whith two decimal digits. Thanks LAM

LAM

07-19-2010 03:21 PM
Gert-Jan Strik

SQL Express 2008 When attempting to attach a db I can only see a path of user/username and then the mdf has to be in that folder. I'd like to...

SAC

07-19-2010 02:25 PM
John Bell

Is there a simple way of determining the actual T-SQL being executed in the current transaction_id? The code below displays the active...

Rubens

07-19-2010 01:36 PM
Rubens

We seem to have hit an oddity. We have a stored procedure that gets the next sequence number. It is protected by a transaction so no two processes...

RG

07-19-2010 09:56 AM
Jeroen Mostert

Hi guys. On a previous project, the requirement was just to store who updated a row, and when. So, we have a: created_date, created_user_id,...

Craig Lister

07-19-2010 03:44 AM
Erland Sommarskog

Hello, Here's the strange thing: I can't see how to order text in Latvian language alhabetically, respecting the order of the special...

Passiday

07-18-2010 12:08 AM
Michael Kaplan

Hi, I wrote a stored procedure that is fed values via a table stored in a particular database on one of our SQL server environments. The values...

jam772

07-17-2010 01:44 AM
Jeroen Mostert

Hello, We've had performance issues with our server. We typically get 'insufficient resources' error and eventually wind up rebooting the...

Peter Capazzi

07-16-2010 04:42 PM
Erland Sommarskog

I have a SQL 2008 x64 Standard server with 16GB of memory. The database on this server is using almost of of this memory. The database is 35GB. ...

John

07-16-2010 09:42 AM
John

When an index is rebuilt are: (1) statistics updated on the index during the rebuild process, or (2) is a flag set so that when the index is used...

cbrichards via SQLMonster.com

07-16-2010 03:45 AM
Erland Sommarskog