SQL Newsgroups: Microsoft SQL Server Administration

question about installing sql server express

Bart - 24 Mar 2007 11:24 PM - 3 messages

Hi, During installation process of sql server2005 express, i had to choose between three options: install sql server as: local system Network Service local service Can somebody explain me the pro/contra? What should i take? Thanks in advance Bart ...

which default database to assign to login?

Bart - 24 Mar 2007 8:50 PM - 4 messages

Hi, i have just created a new login (server\aspnet) for runnung aspx pages. When arriving at the "default database" option, in the dropdownlist, all the databases are in it, also systeem objects as Master, Model, MSDB .... The databases are all run with account 'aspnet', so does it make any ...

DB Maintenance Plan SQL 2005 on 6300+ Database

Icemokka - 24 Mar 2007 3:37 PM - 2 messages

Hi, We have a SQL-cluster with over 6300 databases, most of them pretty small in size and usage. For this reason all these databases are on auto-close ( Otherwise SQL would need many many gigabytes ). We've recently upgraded to SQL 2005 because of the Management Studio, ...

DBCC DBREINDEX Behaviour

Scott H. - 24 Mar 2007 3:10 PM - 9 messages

Folks, I have a table with a clustered index and 6 non-clustered indexes. When I issue a DBCC DBREINDEX without specifying a specific index all indexes are rebuilt including the clustered index - this takes 3 hours to complete and ...

adding DB from another computer

Areq - 23 Mar 2007 9:30 PM - 4 messages

Hi! I have copied from other computer, from location "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data" files my_db.mdf and md_db_log.ldf to other computer to the same location, and I can't see this DB. How can I import DB ...

Copying tables between two databases

Jerry Flatto - 23 Mar 2007 9:04 PM - 2 messages

I am trying to copy the chart of accounts from Fabrikam to a newly created company. I am running SQL 2005 and Dynamics GP 9.0. I am following the steps from article 866332 in the knowledge base. This ...

ss2005 connection problems

GaryDean - 23 Mar 2007 8:55 PM - 8 messages

Ever since I migrated to SS2005 I have been plaged by continual connection problems where I can't get connected to SS2005 instances on other machines on the network. It always comes up with that message that says SS2005 ...

Backup Exec broke my SQL!!

Just Guessing - 23 Mar 2007 8:54 PM - 5 messages

I installed Symantec Backup Exec 11d on a new Windows 2003 Small Business Server R1. I had many problems and after talking forever with Dell support, I uninstalled Backup Exec "manually" (believe it or not, there's no other ...

SQL Server Connection Pooling Configuration Option?

WalterWalt - 23 Mar 2007 6:41 PM - 2 messages

Hello, I have a ASP.NET app that uses ado.net 2.0 and works well normall, but when deployed to a secure production server I get errros involving nonpooled connections. The connection string and IIS Server are configured for ...

Last time table was used

sharman - 23 Mar 2007 6:34 PM - 3 messages

Hi, I have been assigned to research a database. I am trying to find out whether the database is currently being used by some process/user. Is there a way to find when a particular table/ object was last used/updated/inserted? This ...

Identity columns no longer identities

badlydressedboy - 23 Mar 2007 5:06 PM - 6 messages

Hi, I have an entire db that for no reason I can see has had every identity column's identity property set to 'no'. I have lots of inserts into the affected tables which obviously produces errors inserting null into a column ...

Collation question

sweetpotatop - 23 Mar 2007 4:54 PM - 9 messages

INSERT INTO #TMP_Table# Select * from tabCS, tabCI where tabCS.col1 COLLATE SQL_Latin1_General_CP1_CS_AS = tabCI.col1 COLLATE SQL_Latin1_General_CP1_CS_AS Currently this query is run in a case insensitive server: tabCS is table from a case sensitive server and tabCI is a table from a Case insensitive server which is the same ...

2 servers with different collation

sweetpotatop - 23 Mar 2007 4:08 PM - 3 messages

Hi, I have a stored procedure in which querying tables from 2 different servers (one Case Sensitive, and one Case Insensitive). The stored procedure is currently sitting in the CI server, while the CS server is a linked server. I use "COLLATE" a lot within the stored procedure ...

Setting up log shipping with database mirroring

HeatherK - 23 Mar 2007 3:34 PM - 2 messages

Hello, We are running SQL Server 2005 SP2 Developer Edition x64 on Windows Server 2003 R2 x64. I have configured database mirroring between two servers, and that is working fine. I want to setup a log shipping secondary. I have read ...

Service won't start

musosdev - 23 Mar 2007 3:21 PM - 4 messages

Hi everyone We have an Win2k3 machine which we're using as an Intranet/Database server with IIS6 and SQL 2005 Express. All was working fine, but something has happened. The database isn't running, and when I try to start the service, I get the following error. ...

search database by uncategorized text

katzir.shai - 23 Mar 2007 3:03 PM - 2 messages

Hi. i need help in using simple search which should be quick and efficient. my database has several categories, i want to search it by sending uncategorized text ( can be 1 or more categories in it) and receiveing a list of matching fields. ...

HELP: Updating column with data from another column

John Steen - 23 Mar 2007 1:31 PM - 5 messages

I post a message about this several months ago, but I may have misstated the problem. So here goes again. My apologies for the duplicate. I have two databases, each with identical schema. I need to update about ...

Performance problems when running trhough Com+ and DTC

Anders Evensen - 23 Mar 2007 12:32 PM - 13 messages

Hi everyone, we have a performance problem when running a relatively heavy INSERT statement from a COM+ application against SQL Server 2005 (SP1). The query takes up all CPU resources (4 CPUs) on the database server while processing (about 15 minutes) and the database server does not respond to other ...

MSSQL 2005 Temp DB and Memory Usage

italic - 23 Mar 2007 10:12 AM - 3 messages

Hi All, We have a sql statement that consist of joining 5-6 huge tables. The scripts is completed in 15 minutes in MSSQL 2000. During this time sql use 15-20 MB memory and tempdb size increase by 140 MB. When we run same script ...

Delete data from sys.columns in SQL Server 2005

gj111 - 23 Mar 2007 8:52 AM - 12 messages

Hello, My understanding is that modifying data in system tables in SQL Server 2005 isn't allowed. Currently, I have an issue where a full dbcc checkdb is failing due to records existing in sys.columns, but not in sys.objects. ...

SQL Server 2005 Express and Access 2003 SP2

niuginikiwi - 22 Mar 2007 11:11 PM - 3 messages

Hi all, I have a DB sitting on SQL S 2005 Express and can create a new Access (Access 2003 SP2) project adp to connect to that db but I can not create any other objects such as tables, views, procedures or database ...

Disabling AWE

kulkarni.ninad - 22 Mar 2007 8:47 PM - 2 messages

How do i disable AWE? i mean what are all things that i need to change in order to disable awe in windows 2000 advanced server. Do i just need to remove the switches from boot.ini or do i need to use /NOPAE ...

disabling AWE

kulkarni.ninad - 22 Mar 2007 8:41 PM - 2 messages

What are all step do i need to take in order to disable AWE? Currently, I have /3GB /PAE option setup in my boot.ini and awe is enabled with 6GB RAM to it what i need to do to disable AWE? ...

Updates were not installed Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)

JDJ - 22 Mar 2007 7:47 PM - 2 messages

The following updates were not installed Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) About the only thing I know of that uses SQL Server is ACT! 2007 (version 9) ...

awe question

kulkarni.ninad - 22 Mar 2007 7:14 PM - 5 messages

We are going to turn on AWE on our production environment currently its 4 processor box with 12GB of RAM and windows advanced server 2000 loaded on it. Now my question is do i need to use /PAE and /3GB ...

Replicate tables without primary keys

andyoye - 22 Mar 2007 7:06 PM - 9 messages

Is it possible to replicate tables without primary keys? I am using transactional replication. thanks ...

For NULL

spaulsamin - 22 Mar 2007 5:20 PM - 2 messages

Hello Everybody When I do Insert query for table targeting selected columns it has to store NULL value for rest of the columns, ...

SQL2005 Stops Because of fatal exception c0000005

Jody Greening - 22 Mar 2007 3:29 PM - 4 messages

I have literally spent days looking into this, and I am kind of at a dead end here, do you have any input into this issue? The funny thing is that this does not happen all the time. I think I may have identified 2 issues for this: ...

Slow performence

msnews.microsoft.com - 22 Mar 2007 3:16 PM - 3 messages

I ahve production Server with SQL 2000 SP4 and windows 2000 SP4 . It has 2 G of Memory and we are having slow preformenc and I think we are low on Memory .. Do you agree base on the info bellow .Thanks! ...

Moving SQL Express data to SQL Server 2005 Dev?

MSSQL-n00b - 22 Mar 2007 3:11 PM - 2 messages

Hi gang, Sorry for the bloody obviousness of this quetion, but I'm a unix/mysql guy who's been tasked with moving an web app developed with SQL Express (specifically RedDot CMS) to SQL Server 2005 Developer, and, having literally NO working experience with the Microsoft products, am ...

Restore Database

Audrey Ng - 22 Mar 2007 2:48 PM - 5 messages

Hi everyone, I have a SQL Server JOB that restores a database every day at 2 AM. Here's the script: USE master RESTORE DATABASE SomeDatabase FROM DISK = 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\SomeDatabase.bak' ...

Error When Creating Maintenance Plan after SP2

michad76 - 22 Mar 2007 1:54 PM - 2 messages

Exception has been thrown by the target of an invocation (mscorlib) Additional information: Creating instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from iClassFactory failed due to the following error: c001f011. (Microsoft.SQLServer.ManagedDTS) IClassFactory Microsoft.SQLServer.ManagedDTS ...

HTTP POST OR GET

madfisher - 22 Mar 2007 1:53 PM - 2 messages

Hi, Does anybody know if MSSQL can do an HTTP POST or GET from a trigger or something like that? Thanks, Marcus de Leon ...

SQL 2005 how can I encrypt an entire table or database?

Default User - 22 Mar 2007 12:31 PM - 7 messages

Hi, I have an application that is running on the local (free) version of SQL Server 2005. Does this version support encryption? Can someone post a link or info on how encryption works? Thanks, Alan [link] ...

moving table from one drive to other in sql server 2000

shiva - 22 Mar 2007 12:22 PM - 2 messages

Hi I wanted the know the syntax, how we can move a particular table (lets say a database having two filegroup in c, d drive) from c: drive to d: drive without detaching that particular database ...

Visual Foxpro ver 6.0 Database to Sql 2000 Database conversion

ranjik2001 - 22 Mar 2007 11:41 AM - 2 messages

As our requirement for the project is to convert foxpro database to sql 2000 database and use Sql database .I have tried with Import/ Export wizard and set source as Ms Visual Foxpro Driver and mapped the DSN path and Destination as OLEDB provider for Sql server and mapped ...

Rebuild SQL Server Express database on a SQL Server 2000

Dahab - 22 Mar 2007 9:42 AM - 4 messages

Hi, Anyone know if it's possible to rebuild a SQL Server Express database on a SQL Server 2000? Thanks! Regards D. ...

query related to like operator

perunchithiran - 22 Mar 2007 9:24 AM - 2 messages

Hi all, I have the following doubt in sql server. "I have two coloumns firstname,lastname in the table I have to search the name.I can give either firstname or lastname but i need check it in the database. firstname and lastname should be concatinated and how ...

SQL Server concurrent queries

ipc.eric - 22 Mar 2007 8:00 AM - 15 messages

Dear Sir, I found out from the log of my SQL Server and it keep showing the following message, I am wondering if any one can help or know the reason. This SQL Server has been optimized for 8 concurrent queries. This ...

rebuild a database from backupfile only?

Rainer Queck - 22 Mar 2007 7:16 AM - 9 messages

Hi NG, in case this is not the right news group, please advise me to the right one for my question. How can I rebuild a database from a plain backup? Here is my problem: From within a C# Program I am generating backups of my database by sending ...

sql server is not configured for RPC

Samuel Lee - 22 Mar 2007 4:58 AM - 4 messages

Hi All, I have two servers with the following detail: Server #1 Server Name: SQL2005WIN2003SERVER Windows: Win 2003 Server SQL DB: SQL Server 2005 ('sa', 'pswd123') MS.NET: .NET Framework 1.1 and 2.0 Firewall: NO Server #2 Server Name: OLDMSDE\WIN2000SERVER ...

Sql Server 2000 Service Pack 4 Upgrade Question

jyard - 21 Mar 2007 11:58 PM - 3 messages

I am upgrading 2 Sql Server 2k systems to Service Pack 4 from Service Pack 3. These are part of a replication configuration. System A is the subscriber; ssystem B is the publisher and distributor. Can I update system A, the subscriber ...

Incorrect Login associated with dbo

cbrichards via SQLMonster.com - 21 Mar 2007 8:56 PM - 2 messages

If I run the following statement and do not get any returns, does that mean I have an incorrect login associated with the dbo? use MY_DATABASE go select d.name, dp.name, d.owner_sid, dp.sid from sys.databases d, ...

Where did my SSIS package go?

Paul - 21 Mar 2007 8:20 PM - 5 messages

I created three SSIS packages. One I created to a file. The other two I created within SQL. I can see the one I created to a file. But I have no idea where the other two are. The documentation I found ...

Identify source of 'sa' login failures.

ToeJam - 21 Mar 2007 8:02 PM - 7 messages

Serious issue. How can I track / identify the source of where login failures are originating? Of primary concern are "Login failure for 'sa'". I cannot tell if it is internal or external. What means are available of catching the IP address, ...

Remote ODBC connections fail to SQL 2005 database (Error: 18456, Severity: 14, State: 8.)

Mltwwlco - 21 Mar 2007 7:53 PM - 7 messages

I have reviewed the blog posting "Understanding "login failed" (Error 18456) error messages in SQL Server 2005" at [link] 2007-03-21 11:49:14.55 Logon Error: 18456, Severity: 14, State: 8. ...

2005: change all schema to dbo?

Paul - 21 Mar 2007 6:52 PM - 3 messages

My hosting service moved my database to sql server 2005 and the schema for the tables and procedures is no longer 'dbo'. I need to change all the object owners back to 'dbo'. There was a script in sql 2000 to do ...

adding sql licenses

Rick - 21 Mar 2007 6:18 PM - 2 messages

As I recall, I set the licensing format and number of licenses when I installed SQL Server. a) How can I tell how many and type of licenses that are setup b) How can I increase the number. I can't seem to get back to that original screen. ...

Newbie - Copy table from SQL Server 2005 to Access

Paul - 21 Mar 2007 5:16 PM - 5 messages

I need to copy a farily large table (+200,000 records) to Access. I need to do this from a VB.NET 2005 program. I can get this to work using .NET code. But it's too slow. ...

SQL Schema change auditing.

Sezgin - 21 Mar 2007 5:10 PM - 6 messages

Hi everyone, Is there any way of logging all schema updates(SP modifications,table structure changes,database objects added/deleted etc.) in SQL Server 2000 and 2005 ? Regards, Sezgin ...

datepart datatype

retima - 21 Mar 2007 4:51 PM - 4 messages

On a paramater of datepart (like the first one in DateAdd), can I in any chance pass a parameter? (and not use the constants week, month etc.) SELECT DateAdd(@my_dt , 1 , CONVERT (DATETIME, '01/01/01')) As 'Date' ...

SQL 2005 log is 16GB and growing..help!

Pat M - City of Reno - 21 Mar 2007 4:19 PM - 4 messages

THis is a small server 33GB. The database in question is only 400MB. The log has grown and I can't get it truncated. I even tried the following. Backup the database, deleted it, recreated the db, restored. At first the space was ...

Installing several instance of SQL Server

craigkenisston - 21 Mar 2007 4:08 PM - 2 messages

I'm trying to instance several instance of SQL Server in my Developer machine. To start with, I already have SQL Server 2000 Developer. Then I installed SQL Server 2005 Express, this last defaulted to "\Program Files\Microsoft SQL Server", i.e. the same directory of the 2000 ...

max mem field not working

Scott - 21 Mar 2007 3:58 PM - 3 messages

Hi, i explained to SQL 2005 express that the max mem it could use was 500mb (via the Max server memory field in Mem option on properties). yet when i examine task manager its using 800mb. Any idea why ? Need to stop restart for changes to take effect maybe ? ...

How to loop through a table?

Curious - 21 Mar 2007 3:35 PM - 2 messages

Hi, I have a stored procedure, SPUpdateStatus, with a parameter, InstanceID. InstanceID is a column in a table, "BatchInstance". I'll need to loop through table, "BatchInstance", and execute SPUpdateStatus on each InstanceID. What's the syntax for the loop? ...

ANSI_PADDING Deprecated

Jerad Rose - 21 Mar 2007 3:25 PM - 5 messages

I have a few questions regarding the ANSI_PADDING option. I see, according to MSDN ([link]), that this option is deprecated: My questions are: 1) What will this setting be fixed to once it is no longer supported? ...

connection issue

stoney - 21 Mar 2007 3:18 PM - 2 messages

Created a script to restore db. it drops all connection first then it waits for 5 minutes just incase there are jobs running. problem is after it kills all the users and then it waits 5 minutes before it drops the db another users can connect to the db. Any idea on what I can ...

Enterprise Manager Job Scheduler and the Time change problem

Granola Pete - 21 Mar 2007 3:15 PM - 5 messages

We just noticed a problem with the SQL Server Agent's Job Scheduler. During the time change the other week, the system clock would reset itself every day. I've seen it go an hour ahead and an hour behind. During this time, ...

Maintenance Plan Wizard doesn't see my DB

Francois PIETTE - 21 Mar 2007 2:47 PM - 7 messages

Using SQL2005-Std, the Maintenance Plan Wizard doesn't see my database. My database is not listed in the dialog box where you select specific databases to backup. I see AdventureWorks, AdventureWorksSW, master, model and msdb. Object Explorer doesn't show "msdb". Maybe it is my DB ? Strange because my ...

Example Connect by prior, pleasee

Jesus Suarez - 21 Mar 2007 2:46 PM - 2 messages

helllo what is the intruction that execute "connect by prior" en sql server ...

vmware and SQl 2005 case scenario

Didier Godot - 21 Mar 2007 2:16 PM - 3 messages

Hi, i'm looking for informations about having sql 2005 into vmware. whe have few (5) sql server 2000, 7 with around 12 db wich i want to migrate on sql 2005. i'm looking to do it with vmware with 2 server, does anyone have ...

Various SQL 2005 Errors in Event Log

NRC Help - 21 Mar 2007 11:54 AM - 5 messages

I am running SQL 2005 SP2 and MOM 2005 SP1 on a Windows 2003 R2 server. There are 5 errrors that keep coming up in the event log, they are listed below in chronological order. I've done everything I can think of to troubleshoot, but ...

Connecting to SQL Server over the LAN

Jim Shady - 21 Mar 2007 11:08 AM - 3 messages

Hello, I have SQL Server installed on a machine named SQLHOST with an IP address 192.168.1.4, and the SQL server is installed with the instance named 'CLIENTDB'. Now on another machine, I have a client software written using .NET which connects using the following string: ...

Default values in tables

Bobby - 21 Mar 2007 8:39 AM - 7 messages

Hello all, I thought that I knew how to do this, but I must be having a mental block. I have a SQL table, populated with 14,000 records. I have several int columns which I need to change the default value to 0 ...

connection manager in SQL 2005

00EricClapton - 21 Mar 2007 7:24 AM - 2 messages

I am writing a new Ole DB connection thru connection manager in Visual Studio in SQL 2005. I used Native OLE DB\MS Jet 4.0 OLE DB Provider and I specify a database path as d:\temp\database.dbf and set up the extended ...

Error executing SSIS package

Peter Afonin - 21 Mar 2007 6:46 AM - 6 messages

Hello, I'm running SQL Server 2005 Developer edition on Vista Ultimate. I've created several SSIS packages and run them under proxy account. At first they worked just fine, but then all of them started to fail with the error ...

How to calculate the difference between two dates - aging

Cliff Parker - 21 Mar 2007 5:12 AM - 8 messages

I have created a Model and using Report Builder to create a report. The only thing I cannot get is the formula for the date difference. I need to take an [Opened Date and Time] and the [Closed Date and Time] and get the ...

SQL 2005

Matthew - 21 Mar 2007 3:41 AM - 3 messages

I need to know if I can install SQL 2005 on my pc and have it serve as the server machine as well as allow me to run query analyzer against my database. Anything I would need to know about Access 2003 and the odbc to hit said SQL ...

Restore / Backup - NEED HELP ASAP

portCo - 21 Mar 2007 3:36 AM - 5 messages

Hi there, I have a big favour to ask you. I accidently delete one of my table in database. However, luckly I have a bak file. But, I can't restore whole database with bak file because since I deleted table, there are new data in that table and other table as ...

unicode problem

00EricClapton - 21 Mar 2007 2:12 AM - 5 messages

I tried to write a package for transferring SQL 2005 table to a flat file in Visual Studio. However I got the unicode error message at the destination even though I only use English. Does anyone has idea? Thanks. ...

password policy

00EricClapton - 21 Mar 2007 2:03 AM - 3 messages

I tried to unchecked the password policy for a user. But I got an error message when I press the OK button, "CHeck policy and check expiration cannot be off when must change is on". Can anyone please tell me where I can ...

MSSQL 2000 DB Migration to Microsoft SQL 2005

J.H - 21 Mar 2007 12:54 AM - 3 messages

Hi, We're building new machine Windows 2003 with MSSQL 2005 server. We have current machine running Windows 2000 with MSSQL 2000. How do we migrate the MSSQL2000 database to MSSQL 2005 server? A) My way: inplace upgrade (i know this one will 99% work!) ...

find a field in a database

jason - 20 Mar 2007 10:45 PM - 9 messages

hello, i want to search all of the databases on a sql server for a specific field, e.g. last name, or ssn, what would be the best way to do that? thanks ...

smtp mail and SQL 2005 x64

FredDBA - 20 Mar 2007 9:53 PM - 2 messages

Hi, I am currently in the process of testing a migration from SQL 2000 x86 standard to SQL 2005 x64 standard. One of my concern is the migration of xp_smtp_sendmail. From what I read and tested, it seems this dll is not compatible for 64 bit servers, here is ...

database mail Vs. xp_smtp_sendmail

msnews.microsoft.com - 20 Mar 2007 9:17 PM - 7 messages

Hi, we are in the process of upgrading SQL Server 2000 to 2005, Now, a lot of emails are sent within stored procedures using xp_smtp_sendmail. Now this procedure is quite nice because it lets the caller define diffrent From names and ReplyTo depending on certain conditions. ...

Newbie question about SQL 2000 backup

goundhog - 20 Mar 2007 8:12 PM - 2 messages

I have my SQL 2000 server running on W2003 Server Logged in as domain admin I want to do a manual backup of my database So I follow the Microsoft document Open Enterprise Manager, right click the database, all tasks, backeup ...

corrupt database

Mauro SB. - 20 Mar 2007 7:04 PM - 5 messages

hi, im triying to run a dbcc checkdb against a corrupt database. but i get the following Msg 8921, Level 16, State 1, Line 1 Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors. ...

Question(s) about memory management

Big Ern - 20 Mar 2007 7:00 PM - 2 messages

I'm monitoring a SQL Server 2000 server running on W2k3 and I'm noticing that the procedure cache is shrinking at an alarming rate and the buffer cache is growing. This is surprising to me as this is a proc intensive server and I ...

help with query

vncntj - 20 Mar 2007 6:28 PM - 7 messages

this is my query Select fname ,Case When Count(animal) >1 Then Convert(nvarchar(64), Count(animal)) Else animal ...

useroptions , sp_configure etc.

c-eric.geil - 20 Mar 2007 6:24 PM - 6 messages

I have a view that is returning a division by zero error. In order to get around this, I'm trying to turn on ARITHIGNORE, and turn off ARITHABORT and ANSI_WARNINGS. I used SET ANSI_WARNINGS OFF SET ARITHIGNORE ON SET ARITHABORT off ...

how to drop 1 users tmp objects

totoro - 20 Mar 2007 6:14 PM - 9 messages

I need to drop a user but the user owns objects, apparently tmp tables, how can I dlete them? Thanks in advance! ...

SSL error

tshad - 20 Mar 2007 5:40 PM - 3 messages

I have an sql server on my local XP machine that I haven't used for awhile and now I cannot connect to the Sql Server whether I use my normal logon or SA logon. I get the following error: ...

Merge two fields from the same temp database into one field.

GuyInTn - 20 Mar 2007 4:51 PM - 3 messages

Hello all, Can someone tell me how to merge two fields into one when they are in the same temp database. I then need to update another table with the newly merged field. I have tried: Declate @x varchar(1000) ...

Where is my database?!

Dan.Mandini - 20 Mar 2007 3:52 PM - 6 messages

I have server 2005 with SP2 and I created an analysis services project and went through all the steps and successfully deployed it. How can I view the information if I'm a user? I want our users to be able to ...

Extract Selected Records

Diane Walker - 20 Mar 2007 3:47 PM - 15 messages

We are running SQL 2000 Enterprise Edition on Windows 2003 Server, Standard Edition. We would like to extract selected records by using Query Analyzer and schedule this job to run daily. Is it possible? Thanks. ...

LOG of TEMPDB are growing

MIB - 20 Mar 2007 3:47 PM - 4 messages

Hi, The log of the TEMPDB database is growing and growing. What should i do ? What did i arrive to this situation? For information we are using SSIS and OLAP, maybe it will help to answer. Thanks. ...

SQL Server Performance Monitor Counters

Praveen - 20 Mar 2007 3:33 PM - 4 messages

When I try to monitor the performance using Performance Monitor, I could not see the SQL Server Specific counters? What shall i do for fixing this issue? Thanks ...

Applying Service Packs

MACason - 20 Mar 2007 1:52 PM - 4 messages

When applying service packs to SQL Server (2000 or 2005), does the service pack need to be applied to the client tools running on indivdual PCs/Laptops as well? Thanks. ...

Log Shipping Question

robboll - 20 Mar 2007 1:13 PM - 2 messages

A user has SQL Server 2000 Personal Edition for production and wants a stand-by server to ensure availability of her data. I suggested that we use a log shipping server so she has provided the Enterprise Edition of SQL Server 2000. So correct me if the best approach here ...

Something about query result

superbaby - 20 Mar 2007 12:42 PM - 3 messages

For example My query is like this: select item from itemtable as Item. I got result like: Item IT_133 IT_345 IT_477 But I need the result like(and the column size should be 8): Item 133 345 477 How can I make this happen? Anyone has idea? Thnaks! ...

machine sid & name

bill tie - 20 Mar 2007 12:40 PM - 3 messages

What may be the consequence of changing the name and SID of a machine running a SQL Server 2005? Thank you. ...

SQL Server 2005 Error

RDU - 20 Mar 2007 11:22 AM - 4 messages

I'm running XP Pro. I did some long overdue registry cleaning over the weekend. The only negative result was with SQL Server. Upon reboots, I get the following error: "Your SQL Server installation is either corrupt or has been tampered with ...

Objects dissappearing from SQL Server database

Terry Holland - 20 Mar 2007 10:32 AM - 2 messages

I wasn't sure if I was going mad or if something strange was happening with my SQL Server 2005. I was convinced that changes I had made to tables/views/procs etc were 'dissappearing' from time to time. ...

How do I restore a an SQL database?

Gonzo - 20 Mar 2007 10:12 AM - 10 messages

Our DB administrator is away and we can't connect him and we need to restore an SQL 2000 database that is backed up using lightspeed. I have the lightspeed BAK file but I can't use Enterprise Manager to restore ...

query

Meelis Lilbok - 20 Mar 2007 9:33 AM - 2 messages

Hi I have a following problem; Lets say i have table with names and value in this table "håkan" Now user enters text "hakan" for search and query must return alsow "håkan". Is in SQL any "special" function for this :)? ...

Replication between 2 SQL from 2 Windows SBS 2003?

sp - 19 Mar 2007 11:58 PM - 3 messages

Replication between 2 SQL from 2 Windows SBS 2003? I have 2 SBS servers with SQL 2000. I would like to do a Merge replication, I did it using wizard and everywhere I choose not trusted connection but SQL login and password: ...

Update table with data from dsn

DorkyGrin - 19 Mar 2007 11:25 PM - 4 messages

Hi I need to do a one-time update on a table in a SQL database. I am using SQL 2000, Query Analyzer in Enterprise Manager. In my database, there is a CheckNo field that is blank. The data must come ...

SQL Server 2005 and SBS 2003

lorenzdominic_ - 19 Mar 2007 10:30 PM - 3 messages

Hello I am wondering what is the optimum operating system host environment for SQL Server 2005? Currently we have SBS 2003 hosting a standalone version of SQL Server 2005 standard edition. My question is does SQL Server 2005 run better on a Windows 2003 Server or an SBS Server 2003? ...

New Instance on SQL 2000 SP 4

Daniel Jameson - 19 Mar 2007 9:59 PM - 2 messages

Hi, I have a server running SQL Server 2000 SP 4 on Windows Server 2003 SP 1. I want to install a named instance (this is a development environment). As far as I know, I will need start the install of the named instance from the ...

insert stored procedure does not commit to the database

philhey - 19 Mar 2007 9:41 PM - 12 messages

Hi, I have a problem where an insert stored procedure does not commit to the database from a vb.net program. I can run the stored procedure fine through the IDE, but when I use the following vb code the message ...

Could not continue scan with NOLOCK due to data movement.

SQL server 2k instances

Advertising SQL server names

How do I replicate data from MySQL to SQL2005

identifying which license version installed

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= ,

Why SQLAgent.out always empty; nothing ever logged?

HELP!!! --- From Job tasks to ASP

why convert? performance question...

Need FIX for KB893312

you defrag an OS that SQL Server is installed on using the standard Disk Defrag tool?

SQL 2005 Trace not capturing any data

maintenance plan reports delete backup file fail but deletes it ok

I/O requests taking longer than 15 seconds to complete

Install SQL Server 2005 on D drive ?

Clustering

SQL Server Upgrade

sql processes multiplying

Error converting data type varchar to numeric

Corrupt database needed

Creating a string - Cursor or Case