SQL Newsgroups: Microsoft SQL Server Administration

Enterprise Manager 2000 vs 2005

Rob - 28 Apr 2007 5:39 PM - 3 messages

Maybe I just haven't found the right place yet, but... 1. In 2000 you could hold down the control key, select several tables and script them out into 1 file.... why doesn't this work in 2005 (or how do you ...

named pipes vs tcp

Dan D. - 28 Apr 2007 3:16 PM - 4 messages

Using SS2000 SP4. We have both named pipes (it's listed first) and TCP/IP enable in network libraries. I noticed in EM under current activity and process info for some processes named pipes is used and for other processes ...

hierarchical select

Tomas Vojtech - 28 Apr 2007 11:56 AM - 2 messages

hello, i have a hierarchical select something like this with temp_containerCollect (id) as ( select c.id from LOGI_T_CONT4REFCOLLECT c where c.parent_id is null AND c.isActive like 'Y' /~filter_refuseCollection: AND c.refusecollection_id = {filter_refuseCollection} ~/ union all select st.id from LOGI_T_CONT4REFCOLLECT st ...

Data Cleansing

Shehab Kamal - 28 Apr 2007 8:52 AM - 3 messages

We have just started a new data cleansing project. One of the aims of the project is to identify similar records so that we can eliminate them. The problem lies in how to identify those similar records. Consider a table that has the columns: (ID, name â€¦). A record whose name is ...

Can someone explain why this stored proc does not work?

jbonifacejr - 28 Apr 2007 3:49 AM - 3 messages

Sorry if this angers anyone. I'm posting here and to the .NET group. I am unable to get a return value from a stored procedure in .NET using the following Sproc and .NET code Here is the code in my stored proc. ...

Fail to drop schema - Error 15150

stephanie - 28 Apr 2007 1:58 AM - 6 messages

I want to drop a schema but it shows Fail to drop schema - Error 15150. I found that there is no object under the schema. Any idea? Thanks in advnace ...

SQL Server Express and xcopy

AlBruAn - 27 Apr 2007 11:56 PM - 3 messages

Hi all, A friend has a db he needs to detach and xcopy over to another machine. He told me he's able to detach, xcopy it to another location on his hard drive, reattach it and it's fully functional; however, when he tries to xcopy it to ...

Listing and Changing Filegroup assignments in SSMS

Dave Booker - 27 Apr 2007 11:24 PM - 2 messages

Using SQL 2005 Server Management Studio how can I: 1. List the Filegroup being used by each Table (or vice versa)? 2. Move a Table to a different Filegroup? Note on #2: My understanding is that if I change the storage location of a ...

Unable to Execute ActiveX Script in Job Scheduler

PaulRoney - 27 Apr 2007 9:02 PM - 3 messages

I am unable to run scheduled jobs that contain ActiveX steps. Jobs that contain only SQL excute successfully. The error in the job scheduler history is: Error creating security descriptor for shared objects (reason: No mapping between account names and security IDs was done). The step failed. ...

Changing the Logical/Physical name of a DB, or log

JayKon - 27 Apr 2007 7:54 PM - 4 messages

The system I'm working with has many databases, almost all of which have a logical name of "DBname_Data" and "DBname_Log" which have physical names if "DBname_Data.MDF" and "DBname_Log.LDF". All except one that is. It is named "DBname_dat" & "DBname_dat.MDF". ...

Get Remote SQL Server Date Time

Ram - 27 Apr 2007 7:20 PM - 2 messages

Hi All, I have 3 sql servers located at different time zones. Say, CST,PST,EST. Now how can I get current time at EST,PST from the SQL server located at CST? Is there any query to do that? ...

SQL Server Management Studio extensibility

Frank Rizzo - 27 Apr 2007 6:29 PM - 5 messages

I understand that SQL Server Management Studio is built upon Visual Studio 2005. So does it support plugins, like VS2005 does? I would love to have some type of Code Snippet functionality. ...

collation settings for codepage 1255

eladla - 27 Apr 2007 5:10 PM - 4 messages

Hi, I am parsing some HTML and getting text from one of the tags encoded in 1255. In visual studio everything looks ok, but after the text is saved to the DB, all I can see is '?' standing for each letter. ...

DB name not in sysfiles

donsql22222 - 27 Apr 2007 5:06 PM - 7 messages

This command: dbcc shrinkfile(ABC2_Log,10) yields: "Could not locate file 'ABC2_Log' in sysfiles." Initially, I had backed up ABC and restored it as ABC2. Sysfiles on DB ABC2 shows the name of the DB as "ABC". I think that might be the problem. ...

Setting Processor Utilization

zomer - 27 Apr 2007 4:26 PM - 6 messages

Is it possible for me to set the SQL Server 2005 uses only 90% of the processors?? The server has 4 cpu and i want to limit the amount of processing horsepower SQL Server can use. I know you can take an ...

Audit logins

Prem - 27 Apr 2007 4:19 PM - 4 messages

Is there a way to identify users within sql server 2005/2000 that have not accessed a database within 90 days ? ...

Database Mirror or Log Shipping?

Lijun Zhang - 27 Apr 2007 3:17 PM - 4 messages

We are going to setup a new secondary server for reporting purpose. A group of users will use the secondary database for data modeling, analysis, etc. We have already setup two log shipping secondary servers for the primary, one is over WAN. The logs are backup and restore on every 15 minutes. For ...

Need a query to get path for last DB backup

dsprentice - 27 Apr 2007 2:52 PM - 3 messages

Help needed. I need a query (or location of that data so I can write one) to get the file path information for the last backup taken. Many thanks. ...

long running query

Dan D. - 27 Apr 2007 1:22 PM - 21 messages

Using SS2000 SP4. I have a query that has been running for 17 hours now and I'm wondering if it is doing anything. The transaction log for the database has the same time stamp on it that it had yesterday before I started running ...

CPU Distribution between Sql Server and OS

Krish - 27 Apr 2007 12:16 PM - 2 messages

Hi, I am a DBA for SQL server and I have a poduct to be tested for performance with backend MSSQL Server 2005 developer edition. I have a machine of 8CPU's and the senario is the dataserver has to function for some big computations and data processing. ...

High buffer cache hit ration but low page life expectancy

pshroads - 26 Apr 2007 10:32 PM - 3 messages

I've noticed that I have a buffer cache hit ratio consistently around 99% but a page life expectancy chronically below the 300 second level. I'm wondering how this is possible? Presumably the page life expectancy is low because the buffer pool needs to clear out pages to ...

Index fragmentation

phancey - 26 Apr 2007 10:17 PM - 7 messages

I've got 99% fragmentation on a clustered index of a table with 29699 rows (there have been just 29699 inserts, no updates, no deletes). There are 8 columns on the table with an int and a char(32) being the ...

What is the Minimum Version of SQL Server 2005 required to use SOAP

Kay Davis - 26 Apr 2007 9:20 PM - 3 messages

I know this may seem like a simple question, however we are currently using SOAP to communicate with a SQL2000 server. Since we are in the process of making the migration from 2000 to 2005 and from the looks of things we could ...

Index fragmentation

phancey - 26 Apr 2007 9:05 PM - 4 messages

I've got 99% fragmentation on a clustered index of a table with 29699 rows (there have been just 29699 inserts, no updates, no deletes). There are 8 columns on the table with an int and a char(32) being the ...

Access Form/Combo Box not liking sql syntax: Need sql server syntax

Mitchell_Collen - 26 Apr 2007 8:51 PM - 3 messages

This query is supposed to call a form 'f_test' combo box 'combo2'. However, I have found that the syntax is used for access sql and not sql server 2000. (The combo box holds a value that will return in f_test subform a resultset ...

Server switched and now I cannot delete maintenance plans

SQLdba - 26 Apr 2007 7:54 PM - 2 messages

I have a sql 2005 standard server that was a target server for log shipping. We had to use it and go live by restoring msdb along with the databases and now I cannot delete maintenance plans. The maintenance plan connections ...

First in sequence

thejamie - 26 Apr 2007 6:58 PM - 2 messages

A java group put this out. Is there a way to make it work in SQL 2000 (works fine in SQL 2005 using a partition by statement - only looking for a 2000 method) create table #tt(id int,name varchar(3),salary int) ...

Distributed transaction

lwidjaya - 26 Apr 2007 6:46 PM - 3 messages

We had 3 SQL servers (S1, S2, S3). S1 and S3 are in the same domain. both S2 and S3 have views that link to S1. Recently we replaced S1 with S11. Now, we can run views in S2 and S3 however we cannot modify the views in S2 or add ...

SQL Server 2005 -- is it possible to index XML?

Arkadiy - 26 Apr 2007 6:45 PM - 10 messages

Hi all, SQL server 2005 provides capability to use node values of XML fields (accessed through the "query" method via XPath) in select statements. But is it possible to index on them for faster search? I can't find ...

sp_helptext

stoney - 26 Apr 2007 6:30 PM - 4 messages

Is there an alternative to sp_helptext. I want to read the code to a view but not use the stored procedure sp_helptext to read the code. sp_helptest 'view name' anything else out there ...

upgrading from SQL 2005 Developer to Enterprise

childofthe1980s - 26 Apr 2007 6:28 PM - 2 messages

Hello: Is upgrading from SQL Server 2005 Developer Edition as simple as placing the SQL Server 2005 Enterprise Edition CD in the server, running the upgrade, and pointing the upgrade to the Developer instance? I guess what I'm asking is how to upgrade SQL Server 2005 Developer Edition ...

Create index concurrency (online=on)

rdahlstrom - 26 Apr 2007 4:26 PM - 4 messages

Version: 2005 Enterprise 64 bit, patched and current. Problem description: Select queries block index drop/recreate, even when nolock/readpast are specified I have a requirement to be able to create an index while maintaining access to the table the index will be created on. The index would not ...

Trial to Full Version

Neil Paddock - 26 Apr 2007 3:16 PM - 2 messages

Hi, We have currently installed the 90 day trial version of SQL 2005 on our cluster. We are waiting for our SQL licensing to come through - When this finally does happen, how can I convert my trial version to the fully licensed ...

Performance issue-Stored proc across multiple databases

shub - 26 Apr 2007 3:05 PM - 3 messages

We have a situation where we have multiple databases over 25 of them all with the same schema across 3 different SQL servers. These databases store Customer related information by region across these databases. All of these databases have the same ...

Moved SQL Server 2000 to 2005 and login is not attache

axwack@gmail.com - 26 Apr 2007 2:57 PM - 3 messages

I recently moved a SQL Server 2000 server to 2005 and I cannot drop the user. One of the issues is that the user does not have a login. I tried to do an Alter USer but it's not sticking. ...

Basic Question on SQL Server 2005 Backup Theory

Michael Gorsuch - 26 Apr 2007 2:25 PM - 2 messages

I am replicating a large number of databases (the size changes dynamically) from one sql server to another, all pragmatically. Once a week, I do a full backup and restore it on the destination. All other times I am just backing up the log files, copying them over, ...

ntext data type

mecn - 26 Apr 2007 1:53 PM - 5 messages

hi, What's the length for the data type = ntext, length =16? If I need that field to have longer size, what data type else that I could use? Thanks ...

My database is missing

shapper - 26 Apr 2007 1:43 PM - 3 messages

Hello, I created a database name dbBA and I was seeing it on my Microsoft SQL Server Management Studio. However, now I can't see it. I can see the System Databases, Adventure Works database, etc but not my database. ...

unable to begin a distributed transaction

Darin - 26 Apr 2007 12:36 PM - 4 messages

I have a customer that has 3 remote laptops that will connect using DTC to update the SQL data. One machine works fine. The other 2 both receieve the message: the operation could not be performed because the OLE DB provider ...

SQL Server Agent Problems

Amos Soma - 26 Apr 2007 12:20 PM - 6 messages

I have a number of scheduled jobs running on a server that normally run without any problem. However, on occassion, like yesterday, they simply stop running. The SQL Server agent is running and no errors are occuring anywhere but the jobs simply don't fire off. For example, I have a job that contains ...

running multiple instances

Jason Blake - 26 Apr 2007 9:08 AM - 2 messages

hi... On a windows 2003 server there is already SQL installed as a MSDE/express instance and is used BY sages ACT software. soon I will need to possibly put SQL 2005 standard or workgroup edition on this server to.. Is this ok to do ? Will it harm the existing msde/express ...

Row or column specified is outside the range of the specified query result set

Silver Fox - 26 Apr 2007 6:46 AM - 2 messages

hi guys, we are using MCMS to publish our web news, and we are trying to create a same production environment on another network. We copied MCMS database to another database server and we install another MCMS server on another web server. Then I use DCA point the ...

Log-in failed for user "domain name/administrator".MS SQL Error:18

MICS - 26 Apr 2007 6:40 AM - 7 messages

Hello Group: I encounter this error message when i tried connect to an instance of mssql 2005 server.The situation is like this: I have 2 servers,one is configured as main domain controller server and the other configured as domain controller ...

Transaction Log Shipping Issue

HappyAdmin - 26 Apr 2007 4:28 AM - 3 messages

Doing my first job.... Primary Computer A on a network in Phoenix. Secondary Computer B on a network in Minneapolis. Both SQL2005. It wants to see share names, and when I start to process the job after my config options, it tries on Computer B to connect to a network share on ...

suspect database question

00ScarlettJohnson - 26 Apr 2007 1:51 AM - 3 messages

How do I suspect database in SQL 2000? Thanks. ...

Licence minimisation

MarkH - 26 Apr 2007 12:46 AM - 2 messages

We currently have deployed a number of externally accessible web front ends which hook into numerous backend SQL servers. I have been given the project to minimise our licence costs with respect to these. Some of the backend SQL ...

Error Importing CVS into SQL Server 2005 using SQLBulkCopy and c#

Rob Dob - 25 Apr 2007 11:32 PM - 2 messages

Hi, I'm using SQLBulkCopy via c#, I'm importing a large text file into a destination SQL Table, the file contains multiple columns and is about 100k records, I am getting the following error: 'Could not allocate space for object 'dbo.list0001'.PK_List001Table' in ...

Database Mail: getting bounce info from Exchange?

Manny Klystron - 25 Apr 2007 11:03 PM - 2 messages

Database Mail only sends SMTP email messages and logs problems connecting to the mail server. However, I also need to log bounced emails (bad address, etc). Are there any clean ways to do this with Database Mail and Exchange? ...

Changing the server collations SQL 2005 Express

Anthony - 25 Apr 2007 9:32 PM - 3 messages

How do you change the collation on the master and temp DB Thanks Anthony ...

Database in transition and not accessible?

Michael MacGregor - 25 Apr 2007 8:37 PM - 3 messages

Someone attempted to take one of our databases offline, but it didn't seem to work, however now we can't access the database at all, it says that the database is not accessible, and if I try to run sp_who2, it doesn't run and ...

Error after installing SQL 2005 sp2

TomT - 25 Apr 2007 8:10 PM - 5 messages

After installing this, when I try to open a backup maintenance plan in Management Studio, I get this error: Error 1 Error loading 'MSAAFullBackup' : Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass' to interface type ...

what does this query do?

Dan D. - 25 Apr 2007 7:38 PM - 4 messages

Using SS2000 SP4. I found this piece of code after a query that selects into a table. select 1/0 end else begin select 1/1 end What does it do? What is it's purpose? Thanks, ...

Find SQL Servers

sharman - 25 Apr 2007 7:26 PM - 3 messages

Hi, Is there a script or some tool that I can use to search for all the SQL Servers running in my domain? Thanks. ...

Data and log files on separate disks

Frank1213 - 25 Apr 2007 6:06 PM - 6 messages

The production database of one of our clients is set up with both the data and log files on the same disk. We suggested that they should separate them out to eliminate disk contention and to eliminate I/O problems. The DBA at ...

Snapshots

JayKon - 25 Apr 2007 5:52 PM - 3 messages

We currently use SQL Server 2000 and are in the first stages of moving to 2005. Currently, we make a copy of the live database nightly by restoring a backup (LiteSpeed backup, if relevent) to a staging server. This works OK for the ...

Concat rows into string

Sehboo - 25 Apr 2007 5:48 PM - 2 messages

I have a simple select statement - select groupname FROM Groups This returns 30 rows. What I want is return everything as comma seperated string like "group1, group2, group3..." But I don't want to use function or cursor. Is there anyway? In on ...

2005 Installation location

Emma - 25 Apr 2007 3:42 PM - 2 messages

The initial installation of 2005 was to the C drive of the server. I want to uninstall and reinstalling on the D drive. What is the best way of doing this and still retain all the information already setup in the database? Example, ...

Database connection timeout

kjamesmssql - 25 Apr 2007 3:42 PM - 4 messages

Is there a default value for inactivity (idle) timeout limit for a SQL Server database connection? ...

Determining index usage

zdrakec - 25 Apr 2007 2:08 PM - 3 messages

Hello all: Is it possible to determine, for any given index, that last time that it was actually put to use in a query, in either SQL Server 2000 or 2005? Thanks much, zdrakec ...

Installing new performance dashboard for SQL Server 2005 SP2

Peter Nolan - 25 Apr 2007 12:44 PM - 3 messages

Hi All, I tried to install the new performance dashboards on 2005 sp2 on windows 2003 and received the following error messages. Has anyone seen these before? I know it is quite new... Thanks Peter Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27 ...

No dependencies when inserting data into a #temp table

Karsten Feddersen, Denmark - 25 Apr 2007 12:40 PM - 2 messages

Hi I have a problem. I have a database with way to many stored procedures. In order delete some i made a script that finds stored procedures and their dependencies. Those without any dependencies should be deleted because they typically have been emptied for logic. ...

TRN chain

taal.peter - 25 Apr 2007 10:43 AM - 2 messages

Say you have a chain of TRN files file backupped on tape media. Then some of the original ones on Disk are removed by the Maintenance Plan. Then you do restore of the missing TRN files from tape to disk. You ...

corrupt DB on disconnected external storage

Aramid - 25 Apr 2007 9:10 AM - 4 messages

Dear All, I got several non-clustered SQL servers connected to an external storage via iSCSI. Some of the databases are on that storage. When the external storage is rebooted without shutting down the SQL servers (or detaching the databases contained there), these databases will be ...

Parse Identifier

Bashar Naffa - 25 Apr 2007 8:24 AM - 4 messages

hi how can i configure the SQL server & inforce to parse & excute ONLY if he found an specific identifier, i.e: ;(semicolon) within default SQL server configurations one space is enough to seperate between statement while parsing & excuting. ...

Which Version of SQL Server Best Fits My Needs?

ffrugone - 24 Apr 2007 9:29 PM - 3 messages

My new SQL Server box will handle two databases (approx. 400MB and 600MB). They are the backends for GUI applications used by our company for client data. A maximum of five users will be connected at any given time, (three over the private network and two over the ...

Which Version of SQL Server Best Fits My Needs?

ffrugone - 24 Apr 2007 9:25 PM - 3 messages

My new SQL Server box will handle two databases (approx. 400MB and 600MB). They are the backends for GUI applications used by our company for client data. A maximum of five users will be connected at any given time, (three over the private network and two over the ...

Looking for how to for SQLexpress

Daniel - 24 Apr 2007 8:27 PM - 3 messages

I recently installed SQL express on my winXP machine at home... Installed and configured IIS as requested. I have created a simple table for testing but cannot establish a DSN connection using either SQL or SQL Native driver It mentioned something about allowing remote connections, but that feature ...

Different UPDATE behaviors across servers/databases

Baby Dragon - 24 Apr 2007 7:25 PM - 3 messages

Hi! I have a stored procedure that takes 22 minutes to run in one environment, that only takes 1 sec or so to run in another environment. Here is the exact situation: Database 1 on Server 1 vs. Database 2 on Server 2 - the data is ...

Error adding an Account to a Profile for 'Database Mail'

Buehler - 24 Apr 2007 7:24 PM - 3 messages

Configuring... - Create new account 'SQL Agent SMTP Account' for SMTP server {exchange server}(Error) Messages â€¢ Unable to create new account SQL Agent SMTP Account for SMTP server Microsoft.SqlServer.Management.SqlManagerUI.SQLiMailServer. ------------------------------ ADDITIONAL INFORMATION: Create failed for MailAccount 'SQL Agent SMTP Account'. ...

DB Restore from multiple files

FS - 24 Apr 2007 7:04 PM - 2 messages

Hi, I've got a pretty large database that i normally backup to 6 files and restore it to another database. I've only done this through enterprise manager so it's just point and click. But i was wondering if anyone knew what ...

number of tempdb files?

Lijun Zhang - 24 Apr 2007 6:31 PM - 2 messages

On a 4 dual core, hyper threading server, how many tempdb files I should configure in order to reduce schema lock contention? 8, or 16? I see 16 processors on the Task Manager. According to some articles dual-core CPU is ...

average_time_of_=E9x=E9cusion_of_a_request_sql

jomu - 24 Apr 2007 5:48 PM - 3 messages

hi, i m asking about : average time of éxécusion of a request sql . thks for help ...

temps_moyen_d'=E9x=E9cution_d'une_requete

jomu - 24 Apr 2007 5:44 PM - 2 messages

bonsoir, ma question est la suivante : c'est combien le temps moyen d'éxécution dune requete SQL (sous sql server 2000 ou 2005 ), pour considérer qu'une requete est dans les normes. merci pour l'aide. ...

SQL table cant be updated/inserted

albertleng - 24 Apr 2007 4:53 PM - 2 messages

Hi. My VB program is inserting some records into a SQL table (Ms SQL Server 2005) continuously from a source. It has worked for few weeks already until yesterday in which that table couldnt be inserted anymore. All the new data did not go into that table. ...

Create a stored procedure in schema permision

×’×œ - 24 Apr 2007 2:56 PM - 4 messages

I want to let my developers to create/alter stored procedure only under a specific schema. which role let the login create a procedure , or Which role let the login make ddl changes only in on schema (not in the dbo schema) ...

SQL Server 2000 and Outlook 2003 - XP_SendMail Error 0X8004011D

Kijl Arn - 24 Apr 2007 2:00 PM - 4 messages

At first, when i use XP_Sendmail it throws 0x80040111 and 0x80070057 errors respectively. Also, I was receiving the error that SQLMail could not find a MAPI profile. Even thought I have had one set up for a while, I was still ...

DTC and firewalls

Alexis - 24 Apr 2007 1:56 PM - 3 messages

We have a requirement to utilize MS-DTC from internet facing to an internal system running SQL Server 2000. Can the DTC be stand alone on a dedicated server in the external environment and then contact the SQL database through ...

Is there a way to look at Index fragmentation in SQL 7?

Hurme - 24 Apr 2007 1:42 PM - 6 messages

I tried to do a dbcc showcontig on a SQL 7 table, but this command is not available on SQL 7. Does anyone know if there is a way to check index fragmentation in SQL 7? TIA ...

Some questions about SQL Server 2005 licenses

ume - 24 Apr 2007 1:35 PM - 2 messages

Hi everybody. I have a question about SQL Server 2005 licensing. I have a Windows 2003 server that works as a Web Server for some public web applications. Internet users can access to these applications, create their accounts and manage them. The web server ...

SQL 2000 and 2005 together on production servers

Bajgon - 24 Apr 2007 1:13 PM - 4 messages

Hello, I know this is technically possible to install both SQL Server 2000 and 2005 on the same server. I would like to ask if this is a recommended solution for production servers. I have two production databases, one for SQL 2000 and the other for ...

Optimization and Integrity question

sharman - 24 Apr 2007 12:58 PM - 2 messages

Hi, I have set up a database maintenance plan for all the databases on a server that takes care of the Optimization and Integrity every week on the weekends. However, it's been failing consistently for the past couple of weeks. This is ...

Trial Microsoft SQL Server 2005 Standart Edition

Alex Petrovsky - 24 Apr 2007 12:50 PM - 4 messages

Hi, I need trial Microsoft SQL Server 2005 Standart Edition. But I couldn't find it on the [link] ...

Log Shipping out of sync

Alex Delgado - 24 Apr 2007 8:50 AM - 7 messages

Hi everyone, We have set up a log shipping between two SQL 2000 servers with a monitor server as well. The problem is that I've been on holidays, and the people that should check the databases didn't do it. The result is that the log shipping has been out ...

Keep sp in cache

Juaninho - 24 Apr 2007 8:00 AM - 3 messages

hi, I wonder if anyone knows if it is possible to specify that a specific stored procedure always should stay in cache or for example set that i specific sp has "high cache priority"? Regards Juaninho ...

sql 2005 err 233

perspolis - 24 Apr 2007 5:13 AM - 2 messages

Hi all I have this problem when connecting to sql 2005 : A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings ...

this DBCC rebuild_log('db_name','db_log_path') comand sql 2005

Roberto - 24 Apr 2007 4:48 AM - 4 messages

Hi everyone I have a question Did you know this command DBCC rebuild_log('db_name','db_log_path') of Sql 2000 wicth is equivalent in sql 2005? ...

INVERT vs UPDATE

Fernand St-Georges - 24 Apr 2007 2:32 AM - 2 messages

Hi why does an UPDATE triggers itself at the same time as the INSERT trigger? thanks ...

Limiting parallelism to only some of the processors?

pshroads - 23 Apr 2007 11:02 PM - 4 messages

We are considering turning off parallelism on our server. I've read a few articles that also talk about limiting parallelism to a certain number of processors instead of turning it off completely. They say that this requirement is rare but don't describe situations where it ...

AWE and 3GB switches

Terri - 23 Apr 2007 10:40 PM - 6 messages

I'm configuring a new server with Windows 2003 Enterprise SP1 and SQL Server 2000 Enterprise/SP3a. The server has 8GB of RAM I have set the /PAE switch in boot.ini and then ran the following: sp_configure 'show advanced options', 1 ...

Copy Production Database to the Test Server

Diane Walker - 23 Apr 2007 10:12 PM - 20 messages

We are running SQL 2000 Enterprise Edition on Windows 2003 server. We would like to copy the production database to the test database server. The test server also runs SQL2000 Enterprise Edition under Windows 2003 server. Do ...

Question about updating a SQL Express Database

Eric - 23 Apr 2007 9:25 PM - 3 messages

I have a webserver set up with SQL Server Express. This is all set up for someone else to use. He sent me the orignal databases and I attached them to the server just fine. Now he has made some changes on his and and sent me the updated ...

sql server 2005 log shipping,mirroring, replication

Kumar - 23 Apr 2007 8:24 PM - 2 messages

Hi Folks, In my office we have one OLTP (Database_1)database. For running reports we need exact copy of the same database (Database_1C) and it should be realtime. (<=15 min delay) we want to ensure high performance and minimum impact on Database_1 ...

Extracting Users for restore

Ron - 23 Apr 2007 7:42 PM - 7 messages

I'm refreshing (restoring) a database and would like to keep the users from the original database. Is there a efficient way to extract users, restore the database and then re-apply the users. I'm not talking about logins as ...

SQL Server 2005 backup jobs wont end

Damian - 23 Apr 2007 7:41 PM - 3 messages

I have 1 out of 10 SQL DB Servers that executes but does not write to the hard drive. I have verified that the account used to execute the jobs has the appropriate permissions and that a manual backup executes ...

Performance issue about move large amount of data from database to database

Lee - 23 Apr 2007 7:26 PM - 9 messages

guys, I have a project need to move more than 100,000 records from one database table to another database table every week. Currently, users input date range from web UI, my store procedure will take those date ranges to INSERT records to a table in another database, then delete ...

Max file group per database in SQL Server 2005.

Chen - 23 Apr 2007 7:14 PM - 5 messages

Hi All, Whatâ€™s the max number of file group in SQL Server 2005 database? I knew that in SQL Server 2000, the max file group per database is 16. Regards, Chen ...

SQL authentication error

Vishal - 23 Apr 2007 6:40 PM - 6 messages

Hi, We have setup a private VPN and I am able to ping to and fro between the two offices. I have a couple of problems though. (1) I am able to open open a shared file on my main network from my branch ...

Nightly Update / Fallback protection

BizEd - 23 Apr 2007 6:10 PM - 6 messages

I have become involved with an assessment of a client's nightly update procedures, and I keep running into the following practice. The client consistently copies databases off to separate locations and performs updates upon the new copy. After successful update, the ...

Renaming SQL Server Problem

Joe Williams - 23 Apr 2007 4:36 PM - 3 messages

our server is a Windows 2003 SErver, SQL Server 2000. I had to rename the server from ServerOldName to ServerNewName2. I did that through Windows, however some of my code that references the server no longer works, saying that the server "Server OldName" cannot be found in "sysservers". so ...

Missing Database Mail

Emma - 23 Apr 2007 3:54 PM - 10 messages

How do I access Database Mail in 2005? I do not see it after upgrading a 2000 server to 2005. Thanks, Emma ...

enterprise manager in sql 2005?

SQL 2005 Data Transfer

Query plan miscalculates row count causing system slow down?

Perfmon & Network monorting

Cannot Shrink Log File

What port does Log Shipping use?

Job Hangs...

Problem restarting SQL Server Agent

Automatically Transfer logins/users to a script file

Maximize Sql Server 2005 Memory.

Tricky hardware decision

Log file becomes ungrowable every morning.

Where To Put SQL Server Computer On Network

Login failed - Error Number: 18456 - Severity: 14 - State: 1

AWE on Windows 64 Bit

Indexing Question

Cant insert data through view

Obtain msinfo32 info + am I SAN attached ?