Hi all, What is the easiest and fastest way to move all the files for databases to another drive? The drive they are on now is running out of space...

06-24-2010 01:25 PM
Aedna

I have this query I'm running for a client. I changed the select to select * to make things clearer. The problem is the last line in the where clause...

Eregnon

06-23-2010 05:12 PM
Erland Sommarskog

I am looking for a chart or something that will tell me what Microsoft Products and what versions of these products are compatible with SQL...

rstein

06-23-2010 03:15 PM
rstein

I am having very strange issue . I am able to rollup SP3 for my SQL 2005 but two services it fails and give me the following message. Product ...

viol-8-r

06-23-2010 12:24 PM
viol-8-r

Desperately need help with something very simple! I'm working with SSRS 2008 in my Visual Studio 2008. I would really like to use the functionality...

M

06-23-2010 06:53 AM
M

Many many years ago I used a product called Brio which had a "broadcast server" configuration where a report template could be specified, and then a...

SnapDive

06-22-2010 06:35 PM
SnapDive

I am receiving a timeout error when trying log into a server from sql mangament studio. The Db is upa nd running fine except all of the backup...

Jcoffman

06-22-2010 03:40 PM
Erland Sommarskog

I am having records just disappear. Is there a way of telling when they were deleted and maybe by whom? Does transaction log give this information?

seeker

06-22-2010 03:24 PM
Wojciech Garwol

I am confused as to the release of SQL Server 2008 R2. Is this the supposed SQL Server 2010 release? or some sort of stop gap release? What's the...

GrampaJoe

06-22-2010 03:24 PM
Wojciech Garwol

Hi, i am from Spain, excuse my Inglish I have a Windows Server 2003 R2 x64 1) can I install SQL 2000 Standard Edition? 2) Can I downgrade SQL 2008...

ZIDAC

06-22-2010 01:27 PM
Erland Sommarskog

Hi, i've downloaded SQL 2008 from our Licensed download page and upon running the setup i selected "Trial" and there seems to be a Serial Key...

Aznan

06-22-2010 01:23 PM
Erland Sommarskog

In the Microsoft sql server management studio when I am trying to plan for maintenance task i am getting following error "cannot show editor for...

Sridhar

06-22-2010 06:34 AM
Magnus

Is there an easy way to check that the cursor you're fetching through is on it's last row? I can get the rowcount, but I don't want to select...

Cindy Lee

06-21-2010 07:49 PM
Cindy Lee

SQL Server 2005, Excel 2003 I would like to populate some tables in a SQL database from some tables in Excel. Previously I have used the Concatenate...

will~

06-21-2010 02:41 PM
Tazzin

Hi. How can i know that a column of a table is in which table as foriegn key & whats tha name of that foriegn key clun in the other table. Let if...

Muhammad Bilal

06-21-2010 03:13 AM
Emiel Nijhuis

I would appreciate if someone can guide me on where I can find useful administration scripts (daily, weekly, monthly, etc) I can setup for a news...

SQL

06-20-2010 01:45 PM
John Bell

I renamed our SA account (lets just say to SA2 as an example) but now the SQL Server Agent jobs fail, even though they show the new name SA2 as the...

TracyR via SQLMonster.com

06-20-2010 03:12 AM
Uri Dimant

Hello, I have SQL 2008 R 180 installed as default instance on my laptop. Access is mixed mode When I log into my laptop as administrator, I can login...

Zee Aay

06-19-2010 08:57 PM
Zee Aay

Hi All, We get very strange hang situation at our customers from time to time. I execute very simple query like insert into <table1> select...

prudon@inbox.ru

06-18-2010 04:17 PM
Erland Sommarskog

Having an issue using the 2005 Native Client on a windows 2003 R2 termserver to connect to a clustered instance behind an external firewall. 1) no...

horseradish

06-18-2010 04:12 PM
Erland Sommarskog

hi is sql 2005 named instance is same as sql server virtual server?

Mecn

06-18-2010 02:51 PM
John Bell

Hello All, From a stored procedure I would like to call an SSIS package. I have two packages: 1. Does an FTP call to a legacy system to collect...

ben brugman

06-18-2010 11:00 AM
John Bell

Hi......... m running this code for backing up and to have backup log backup database adventureworks to disk = 'g:radvent6.bak' mirror to...

rino_abraham

06-18-2010 07:06 AM
rino_abraham via SQLMonster.com

Hi, in MSSQL 2005 would you be so kind to explain me the difference between CLR storedet procedures and Transact-SQL storedet procedures ? Thank...

big

06-18-2010 12:49 AM
JussiJ

I have a table that has several columns, two of which are date fields. A start_date and comp_date for start and completion date. I need to run a...

mclaugh2010

06-17-2010 05:54 PM
b. edwards

Hi, I have a big table(20 GB), I want to archive the data and clean up the table to fast access. Is it this the better way to min downtime: select...

06-17-2010 04:40 PM
John Bell

We currently have SQL Standard 2008 in a 2 node cluster and are investigating perhaps updating to R2. Does anyone know where I could find a...

Robyn H

06-17-2010 04:38 PM
Erland Sommarskog

I have an urgent requirement to debug Transact-SQL in SQL Server 2005 and I have a couple of questions. 1. Are there any *free* programs that will...

allanc

06-17-2010 04:24 PM
Erland Sommarskog

Hi I have windows 2003-X64-enterprise with all the updates and I was trying to install SQL 2008 (R2_enterprise_x86_x64_ia64), and I got the...

Bahram

06-17-2010 01:53 PM
Bahram

hi, let consider, A table has following fields, name amount date

visweswaran28 via SQLMonster.com

06-17-2010 07:50 AM
obiron via SQLMonster.com

Hello, I am creating a backup of a SQL Database using T-SQL and I get an error when saving it to a folder under Users/Miguel/Backup. The same...

shapper

06-16-2010 07:30 PM
Tom Moreau

Hi getting the following error when attempting to start mirroring configuration: The server network address tcp://us-sql01.<mydomain.com>:5022 can...

Gerry M

06-16-2010 02:23 PM
Gerry M

I'm trying to setup an unattended installation of SQL 2008 Express Edition. I want the local administrator of the box to have sysadmin access. ...

Steve

06-16-2010 01:27 PM
Steve

Hi, I'm a novice DBA looking after a DB, there are about 100 users in 3 offices. I'm thinking to upgrade to sql 2008 release 2 from sql...

dboon6767

06-16-2010 01:14 PM
dboon6767 via SQLMonster.com

Hello, i am trouble trying to do a SELECT . i have one table : persons (person_id, person_child,distance) WHERE distance is the number of...

stunaz

06-16-2010 07:37 AM
stunaz

hello guys, can someone show me how to create an array variable in an MSSQL database. Thank u. Francis

Francis Baiden

06-16-2010 02:49 AM
John Bell

Hello, I am hosting a web site on IIS 7.5 in a Windows 2008 server. This web site requires an SQL Database so I configured the SQL Server to allow...

shapper

06-15-2010 04:05 PM
Erland Sommarskog

Hi, I need to be able to establish an exclusive connection to the database and do a restore to it. Nobody, can be connected to that database prior...

tolcis

06-15-2010 04:03 PM
Erland Sommarskog

I ran sp_who2, what is SPID? From Microsoft, I found that it is session ID.(I copied it at bottom). I used ASP.NET in app, what is the relationship...

aspfun via SQLMonster.com

06-15-2010 02:14 PM
aspfun via SQLMonster.com

Users are complaining that they are getting experiencing time outs to a MS SQL 2005 database. There is no explaination on the network, however lots...

gracie

06-15-2010 08:03 AM
gracie

Hi, I want an SQL query to populate a table with thousands of rows of random data There's an example...

Gerry Hickman

06-15-2010 03:38 AM
eliza sahoo

Hello, I have a web application running on a IIS 7 Application Pool that runs on Network Service. I enabled my SQL Express Server to allow remote...

shapper

06-14-2010 06:41 PM
shapper

Hello, So I have spent now couple of hours tearing my hair out about this problem. So, I have this set of data - table with string field in...

Passiday

06-14-2010 04:25 PM
Erland Sommarskog

We're looking into implementing SharePoint 2010 with a SQL Server 2008 R2 backend. We were also interested in using the RBS addon to get our files...

Rich Brown

06-14-2010 11:31 AM
Rich Brown

Hi, I have a table that looks like...

Eric

06-14-2010 10:07 AM
Eric

I have a query like ............. ............ col11 = 'THIS' OR col12 = 'THAT' AND col13 = '201003' AND col14 = 'THE...

A

06-14-2010 07:56 AM
A

Hi All, I had a third party install some backup scrips for me. He stated: There is no file to put in the c:\ntutil folder as the script code is...

ToddAndMargo

06-13-2010 08:48 PM
ToddAndMargo

We at www.sqlServer-Training.com, are trying to educate people on Microsoft SQL Server. We are providing daily tutorials, news and articles via our...

DBATAG

06-13-2010 01:06 PM
DBATAG

Hi, I use SS 2005 on W2003 EE 6GB with /PAE /3GB I set: max mem 2147483647 MB awe is checked SS is using only 100MB about

bob123

06-13-2010 12:57 PM
DBATAG

Hi, On my SQL Server 2008 my collation is SQL_Latin1_CP1_CI_AS am I unicode ? Thanks in advance

bob123

06-13-2010 03:06 AM
bob123