Hi all, I know SQL 2005 Std Edition supports a 2-node cluster. Does it support a 2-node active/active cluster? And also does it support a 2-node...

11-13-2008 07:35 AM
Charles Wang [MSFT]

Hello All. My server ... 2 cpu xeon 3.2ghz, Hyperthreading Enabled 4gig de ram 5 36gig 10000rpm scsi: 2 = Mirror 3 = Raid5 Windows 2003 SP1 SQL...

Jonathan

11-13-2008 02:48 AM
Uri Dimant

Hi, I have uninstall reporting server in sql 2005. But I still can see the databases ReportServer and ReportServerTempDB Is is safe to remove the...

Jan

11-13-2008 02:46 AM
Tibor Karaszi

Msg 15115, Level 16, State 1, Line 1 Password validation failed. The password cannot be used at this time. Msg 15115, Level 16, State 1, Line...

pheonix1t@gmail.com

11-13-2008 01:47 AM
Tibor Karaszi

MDT is asking me to create a sql share. I cannot find anything referring to creating a share inside the SQL Management Studio. Any...

Allan

11-13-2008 01:43 AM
Tibor Karaszi

May I know if the database is mirroring, and the mode sets to FULL Recovery... is it possible to truncate the log? i ran the following queries and...

Michael Lam

11-13-2008 01:36 AM
Tibor Karaszi

Hello, Is there any information on how to limit access to SQL Server 2000. I want to allow access from "only local machine." Instead of firewall, is...

Ohjoo Kwon

11-13-2008 01:35 AM
Tibor Karaszi

When I right-click on a Linked Server name and select "Test Connection", I get the following error message: Server...

bobbyboy

11-12-2008 06:16 PM
bobbyboy

I run this nice dmv sys.dm_db_index_usage_stats, then run a humongous SP, then run the dmv again to get a delta. Even though the SP has done...

JRStern

11-12-2008 04:42 PM
JRStern

Hi there We have an Excel workbook with pivot tables based on a SQL Server 2005 Analysis Services cube. In the year or so that we've been using...

Michael Anderson

11-12-2008 04:40 PM
Michael Anderson

MSP Error: 28130 A domain group is missing for one or more services. To install SQL Server 2005 as a failover cluster, domain groups must...

ABR_Matt

11-12-2008 11:02 AM
ABR_Matt

Hello, I have a table with about 15000 rows and I want to update a text field for all rows of my table where this field is not null. I tried the...

Miguel Isidoro

11-12-2008 08:39 AM
Miguel Isidoro

I have a SQL server 2005 Standard edition installed on a Windows 2003 Server (R2). The setting on Surface Area Configuration for Features -...

DaveB

11-12-2008 08:38 AM
DaveB

Hello: We changed the Domain Admin password and not SQL will not start. Please let me know what we need to do. Thanks! childofthe1980s

childofthe1980s

11-12-2008 06:52 AM
childofthe1980s

We have a SQL Server 2000 Standard Edition (SP4) running on Windows 2003 Enterprise Edition (SP1) on Quad Dual-Core Xeon with 32GB of RAM...

KTN

11-12-2008 05:54 AM
Tibor Karaszi

Hi, I switch from SQL 2005 to SQL 2008. Since I change the server hardware at the same time I need no live migration. What is the best way to have...

Patrick D.

11-12-2008 04:21 AM
Hugo Kornelis

Hello everyone Got a fairly straight forward question here which for some reason I cannot find a straight answer to Can Data Protection Managment...

SimonW

11-12-2008 01:49 AM
John Bell

Hi guys, I have db that setup as simple recovery model in slq 2005. The transaction log was not truncated and get bigger. Is that not truncated log...

Iter

11-12-2008 01:41 AM
Tibor Karaszi

Hi All, Anybody worked with the sqlBulkCopy class to import records? I am having an issue with ms sql 2005 service. It is filling up the memory very...

Steve

11-12-2008 12:49 AM
Uri Dimant

I am in the process of preparring a recommendation on how to handle blocking issues that occasionally creep up on us in SQL Server 2005. Currently...

Spencer

11-12-2008 12:46 AM
Uri Dimant

Hi All, I need to compare all the stored procedures that are in production environment with the development environment for 1 database of sql...

Kumar

11-11-2008 10:46 PM
Dariusz Dziewialtowski

I have a question on memory usage for 32bti SQL Server 2000. It is my understanding that the max memory the engine can use...

Shawn Mason

11-11-2008 08:57 PM
Dan Guzman

For SQL Server 2000, 2005 and 2008: I will like to know is there anything missing in developer edition in comparion to other editions such as...

Prem Mehrotra

11-11-2008 06:02 PM
Peter Gibbons

Hi all, I'm getting this error message:- Cannot resolve collation conflict for equal to operation. where running this query:- SELECT...

Greg Hines

11-11-2008 05:56 PM
Greg Hines

Hello, I am developing a Windows WPF application to run on a local network. This application is to be installed on 3 computers of the local network...

shapper

11-11-2008 05:16 PM
shapper

Hello all...I'm in dire need of good advice. A previous admin installed SQL 2000 Enterprise when the company actually licensed Standard. ...

cbarks

11-11-2008 04:16 PM
cbarks

Hello, I've checked that a Database is corrupted and I saw that a specific extent is unhealthy. Anybody knows how can I check which object is...

julianohorta via SQLMonster.com

11-11-2008 01:40 PM
Kalen Delaney

I have an issue with a web application using a newly installed SQL Server 2005 database. All tables have an ID field that has an identity...

Gonzornung

11-11-2008 12:27 PM
Russell Fields

I am trying to analyze hundreds of thousands of rows in a trace as while the trace is running. What I want to do is select all the rows in the trace...

myotheraccount

11-11-2008 11:59 AM
TheSQLGuru

Hi all, I have a webservice that runs some jobs that were written in .Net. Each job performs heavy business calculations. Statuses for each job are...

tolcis

11-11-2008 11:57 AM
TheSQLGuru

This is what the customer wants, and i don't want to say no, but i'm beginning to wonder if this is even possible. The challenge is to sort a funnel...

Markus

11-11-2008 11:05 AM
Markus

If you were to employ mirroring, are you required to buy another copy of SQL 2005? -- Greg

Greg

11-11-2008 08:40 AM
Tibor Karaszi

In "oledb destination" , I changed the AccessMode option from OpenRowset to OpenRowset using fastload. The package ran a lot faster. What's the...

Jack Benny

11-11-2008 06:51 AM
Jack Benny

Hello! For some time, our database-backups has been stalling causing the transaction-log to grow. When this finally came to my attention, I...

David

11-11-2008 05:49 AM
Tibor Karaszi

Hi I have a table with columns as: ID ParentID Value Level The output I want is:

mdGandhi

11-11-2008 04:11 AM
Uri Dimant

Try to assign a column name to Count(*).

Maninder

11-11-2008 03:24 AM
pelegk1

Hello, I need to set up a scheduled Agent job that will let me know if any of my databases that has "full" recovery model does not have the log...

msnews.microsoft.com

11-11-2008 02:45 AM
msnews.microsoft.com

Have to migrate a WSUS database from a WSUS server to a remote SQL 2005 SP2 server. Microsoft describes the procedure on Technet...

Franz Schenk

11-11-2008 02:17 AM
Flipp

Hi all. I'm ne to SQL and Tigger, but I am using the following for an Insert Trigger: CREATE TRIGGER trig_Add_WO_Items -- Update WO_Items and...

Erin Standa

11-11-2008 01:26 AM
John Bell

I keep getting the following message after each reboot of out SQL Server 2005 Express server: 2008-11-09 02:42:13.40 spid11s Service Broker...

dbalorenzini

11-10-2008 05:11 PM
TheSQLGuru

Environment Details ----------------------- Windows Server 2003 Enterprise x64 Edition - 32 GB of RAM Sql Server Standard Edition (64 bit) - Min Max...

Mike

11-10-2008 05:01 PM
Mike

I have a database that's 300gb, but 200gb is in one table, that I want to move to another filegroup. Say that gets done, now I want to shrink...

JRStern

11-10-2008 04:25 PM
Mohit K. Gupta

Is there a step-by-step procedure available on-line that explains how to set up SQL Server 2008 Express to allow user access from a...

ironwoodcanyon@gmail.com

11-10-2008 03:22 PM
ironwoodcanyon@gmail.com

Does Alter Database take variables for DBname? Like so... DECLARE @DbName nvarchar(50) SET @DbName = 'IPMASTER' Alter Database @DbName set...

Doug

11-10-2008 03:22 PM
Russell Fields

I got this table: +--------+------------+-------------+ I need to get MAX(Temperature) for the full year and also know...

Pasi

11-10-2008 08:18 AM
Plamen Ratchev

I am trying to shrink the datafile for my database with the following command: DBCC SHRINKFILE (N'Database_Data', 79000) This statement will shrink...

dbalorenzini

11-10-2008 07:42 AM
dbalorenzini

Hello, There is a RESTORE database job that is running right now that has code: RESTORE DATABASE FROM , , WITH FILE = 1, NOUNLOAD, ...

msnews.microsoft.com

11-10-2008 07:15 AM
Tibor Karaszi

I am not a sql dba and have some questions about upgrading to SQL 2005 x64 or 2008 x64 for my company. We are running a ERP software package called...

Ricus

11-10-2008 07:01 AM
Ricus

Hi, Has anyone been able to connect sql mgr to sql server (2005 or 2008 installed in a server w/w2003 and with firewall enable) using Vista? If so,...

Emilio

11-10-2008 01:33 AM
John Bell

I've got a Windows 2003 Server STD box with SQL Server 2005. My research suggests that a new install to 2008 is always preferable, but that would be...

circulent

11-09-2008 10:06 PM
circulent