I am in process of migrating an old SQL 2000 server databases into a SQL 2008 database server. Many of the old databases on the 2000 server are not...

Shon Miles

10-20-2009 12:31 PM
Tibor Karaszi

I am running Windows Server 2003 with SQL2005 Standard with SSMS Express with Dynamics CRM 4.0 Database. Is it possible to upgrade the SQL 2005...

Len

10-20-2009 11:52 AM
Andrew J. Kelly

Within the SQL Server Agent job function, there are some differences between SQL 2000 and 2005 where the change in the new version is not as useful...

dp

10-20-2009 07:32 AM
Russell Fields

All, I have to run the Profiler between 5:00AM and 7:00AM to check if anyone is accessing the application during this time and I have to run this...

rgn

10-20-2009 06:51 AM
Dan Guzman

Hi Guys, I have question regarding adding new files in tempdb. I added new files into tempdb using sql script. I found some things I don't like and...

Iter

10-20-2009 03:10 AM
Tibor Karaszi

I have backed up MY db as the comaand below (3 days ago) BACKUP DATABASE TO DISK = N'D:\Backup\Sql\Bayi.bak' WITH NOFORMAT, NOINIT, NAME =...

Seyfullah ÝZMÝRLÝ

10-20-2009 02:52 AM
Tibor Karaszi

Can anyone tell me why this takes 10 hours for 400 packages? Both SQL Server instances are 64-bit SQL Server 2005 Enterprise, its not the cursor as...

Erik G

10-20-2009 12:18 AM
John Bell

Hello NG Does anyone know of any performance isues with a SQL Sever 2005 installed on a Windows 2000. My problem is that we have a rather old...

J E Jensen

10-20-2009 12:16 AM
John Bell

If I already have a table with lots of data in it, is it possible to partition it? I've read that you can drop the clustered index and then recreate...

Steven

10-19-2009 01:57 PM
Steven

I have Project Server 2007 running on an evaluation copy of SQL Server 2005. The evaluation copy has expired and we are now looking to upgrade to...

Chris M

10-19-2009 01:52 PM
Tom Moreau

"Martin Racette" wrote: Hello Martin, do you get an error message when you try to connect (what message)? Can you see the service in service...

Olaf Helper

10-19-2009 01:44 PM
Olaf Helper

rough analysis of a bloated TempDB shows that the space mainly is consumed by the version store --------------Version store---------- SELECT...

rek

10-19-2009 06:58 AM
rek

Hi I'm using sql2000 standard version I am trying to create a sql agent job which will run app. every minute. What I would like to accomplish is to...

JW

10-19-2009 01:50 AM
Tibor Karaszi

Hi, I'm trying to clean up a table called WorkOrders where we had been storing the EmployeeID rather than just store the Employees name We have...

AkAlan

10-18-2009 03:42 AM
Uri Dimant

Hello, Are there any problems rebuilding indexes on tables that contain BLOBs? Any help would be greatly appreciated! Thanks in advance.

Gregg

10-17-2009 10:09 AM
Andrew J. Kelly

Please forgive my newbee SQL status.. I have the following database structure and data: CREATE TABLE CUSTOMER_ORDER ( ROWID INT , ID varchar(15)...

stewsterl

10-16-2009 08:28 PM
stewsterl via SQLMonster.com

See my ealier post this morning. Questions regarding Microsoft SQL Server Express Edition with Advanced Services on SBS 2008

AllenM

10-16-2009 05:19 PM
AllenM

OK first of all please excuse my cross posting of this. I also posted this in the SBS NG as I was unsure which would be the appropriate forum to...

AllenM

10-16-2009 05:15 PM
Chris Wood

Howdy, By default, the Remote Query Timeout was set to 600 sec. What are the side effects to sql performance or anything relates to sql server if I...

Vito Corleone

10-16-2009 04:56 PM
Erland Sommarskog

I've been instructed to install SQL Server 2005 on a Windows 2003 server. I've done so, but now I need to apply any outstanding patches. I don't...

Buck Turgidson

10-16-2009 01:21 PM
Geoff N. Hiten

When a SQL 2008 server is rebooted, is dbcc checkdb automatically executed during the startup? What about after an upgrade from SQL 2000 to SQL...

Liz

10-16-2009 12:55 PM
Olaf Helper

Hi all I have to migrate a site from an host to another. Both hosts use mylittleadmin/mylittlebackup. Backup procedure from first host: ok Restore...

Redwiz

10-16-2009 07:02 AM
Dan Guzman

Hi, My console application is trying to connect to remote SQL server under impersonated identity in integrated windows authentication mode. My...

Sandeep

10-16-2009 02:23 AM
Sandeep

Hello, I have read about the different Isolation Levels, but Iam confused between REPEATABLE READ & SERIALIZABLE. This is a snippet of the...

Abba

10-15-2009 09:49 PM
Abba

Hi, Can I do SQL server replication if I have SQL server purchased, or is there a separat product? Thank you, T

Tester

10-15-2009 04:16 PM
Russell Fields

hi, my company is selling software based on either oracle or sql server. currently we are planning to use an hosting provider to have our...

Fritz Theiss

10-15-2009 02:59 PM
Sylvain Lafontaine

I saw an analysis in Techblog. The main argument is that there are many people inside Microsoft who believes that using proprietary software is not...

Andy Sams

10-15-2009 02:24 PM
Andy Sams

Hello I have loads of trouble getting my head around dates especially the formats. I have a list of dates in the following format 11/05/2009...

silentbob

10-15-2009 11:02 AM
Russell Fields

Hello, I have few general sql scripts Version100.sql Version200.sql Version300.sql Version400.sql .....

anxcomp

10-15-2009 10:57 AM
anxcomp

Hi, I have a table like this, note there are duplicate names, but different date-of-birth name, dob john smith, 12/12/1950 jane brown,...

Gerry Hickman

10-15-2009 10:14 AM
Gerry Hickman

I am making a web app that needs to be scalable as it likely to become very busy. I'm the full book on SQL and was wondering about some strategies...

ThatsIT.net.au

10-15-2009 09:34 AM
ThatsIT.net.au

Hi Experts, Can I change the settings of the database engine to allow remote connections using sql (or c#) code and not from the SQL Server 2005...

Avi

10-15-2009 09:33 AM
Erland Sommarskog

I hope the subject line hasn't kept people away; I couldn't think of the best way to summarise the question. You have a database server and a web...

Charles

10-15-2009 07:30 AM
Charles

Hello, Iam facing an issue with one of the queries taking lot of time to execute. The query consumes a lot of CPU and other system resources. Can...

Abba

10-15-2009 06:51 AM
Abba

Hi, I migrated windows domain & users and it happened that the users now belong to a new domain domain2, The users in sql server 2000 SP4 are still...

Imran

10-15-2009 05:41 AM
mir rahman

Hello, I want to migrate a two node Windows Server 2003 x64 R2 Cluster with multiple clustered SQL Server 2008 instances and a few TB of...

Peter Gibbons

10-14-2009 04:33 PM
Peter Gibbons

For SQL 2005, does the maintenance plan 'Shrink Database' also shrink the associated log files as well or would that have to be a...

Jack Benny

10-14-2009 03:07 PM
Andrew J. Kelly

Hi! I have installed a SQL Server 2008 Ent on Windows 2003 Server Ent 64 bit. Server 2003 is hosted on VMWare ESX 3.5. I gave 8 Gb ram and 4 vCPUs...

Zaur Bahramov

10-14-2009 08:32 AM
Uri Dimant

Hello, EXEC sp_executesql @stmt = N'SELECT * FROM Inven.InventoryDetails WHERE InventID = @InvID', @params = N'@InvID int', @InvID = 100320 - Is...

Abba

10-14-2009 04:11 AM
Abba

Hi all, I have a old NT4 Based SQL 6.x Server I'm tring to get ride of as it is holding up my Domain migration (don't laugh I have only been here 9...

Fisher

10-13-2009 05:02 PM
Erland Sommarskog

Why would both the user and its group appear in the User Rights Assignment for "Log on as a service"? Should I much care? We're installing SQL...

Greg Stigers

10-13-2009 10:41 AM
Greg Stigers

What T SQL operations are performed in Tempdb or make heavy use of TempDB? Based on my knowledge, DISTINCT, Sort (ORDER BY), CROSS Join (Cartesian...

Chirag Shah

10-13-2009 10:19 AM
c_shah

Hello, Under what cvircumstances does the Actual and Estimated query plans vary? I checked some queries and found that they are identical on all...

Abba

10-13-2009 05:02 AM
Abba

Hi All, I have a prepared statement which i execute through jdbc, it is a simple select statement with 200 parameters in the IN clause. The...

Rashmi Dharshan

10-13-2009 05:02 AM
Abba

I'd just like a simple way to get an idea of how old a server is or when SQL was originally installed or something to let me know if I'm dealing with...

Jack Benny

10-13-2009 01:56 AM
Uri Dimant

Hi, I have SSIS installed on one of the SQL Servers. I used to be able to connect to the Integration Services via Microsoft SQL Server Management...

tolcis

10-13-2009 01:44 AM
Uri Dimant

Hi, wich is the best way to exchange data form WM6 with SQL Server 2008 connected in wifi? .. direct connection. .. wcf .. ??? Thanks in advance

GAS

10-12-2009 05:20 AM
GAS

Hello, I need to conduct a session to SQL developers on the below topics. Does anyone have a list or powerpoint or url that I can use? 1. Best...

Abba

10-12-2009 01:14 AM
Abba

"TheSQLGuru" wrote: Thank you for answer, sometimes it is true but not always, for example look at Nagios, it is free and used for a lot of people...

anxcomp

10-11-2009 03:19 PM
anxcomp

Hi, i defined a field as INT which is primary key and which has Identity Specification=YES and with Identity Increment = 1. Now i deleted the whole...

Luc

10-11-2009 07:00 AM
Erland Sommarskog