SQL Newsgroups: Microsoft SQL Server Administration

How to restore database with Move

Stephen K. Miyasato - 14 Oct 2006 7:06 PM - 3 messages

I have back up my database on one machine using backup and wish to confirm that I can restore this on another server. how do I use Restore with Move? Thanks Stephen K. Miyasato ...

SQl server 2005 64 bit Installation -- Best practices.

Kumar - 14 Oct 2006 4:41 PM - 4 messages

Hi All, I need to Install SQl server 2005 64 bit on windows 2003 64 bit cluster environment. Is there any standard best practices,check list documents for this kind of deployment? Any kind of help is greatly appreciated. ...

Linked Serevrs

Mukut - 14 Oct 2006 12:15 PM - 2 messages

Hi All, This is an urgent issue. In our project, we are using a stored procedure which populates a table in sql server 2000 database by taking value from an excel file. While running the sp, the error we are getting is as follows: ...

how to modify column names through TSql

Vadim - 13 Oct 2006 11:50 PM - 3 messages

Hi, I need to just change the case of some letters in a column of a table, e.g. from PURCHASE_ORDER to Purchase_Order and I can do it easily through EM. Works well and preserves all the data in tact. ...

Row-versioning Features and Compatibility Mode

Ernie Gutierrez - 13 Oct 2006 11:22 PM - 3 messages

I've been looking for a clear statement about whether the new row-versioning features (snapshot isolation level and the new read committed isolation) in SQL Server 2005 will function under compatibility mode 80. Does anyone happen to know the answer to this ...

dbcc reports different size than shown in database properties

JeremyGrand - 13 Oct 2006 11:00 PM - 2 messages

In sql 2k, I've been looking at size and autogrowth, and some issues have come up. In my database properties, general tab, I see size 9118mb, space avail 1372mb. However, when I run dbcc showfilestats ...

Run large sql script via osql takes loooong time

john conwell - 13 Oct 2006 10:34 PM - 2 messages

I have a large sql script file. If I open it in Query Analyzer and run it, it takes about 15 seconds to run. If i run the same file via osql with the -i argument to specify the sql file, it takes several minutes to run. ...

SQL Server 2005 - Database Mail

Joe K. - 13 Oct 2006 9:32 PM - 2 messages

I tried to set up Database Mail when executed the Send Test E-Mail I received the error listed below. Please help me resolve the error listed below. Example of email account name and mail server name. Thanks, ...

Management Studio: "select *",column names automatically filled in?

emde - 13 Oct 2006 9:28 PM - 5 messages

I am new to SQL 2005 and can't figgure this out. If I open a table, the results are displayed. If I then modify the query statement (leaving select *) and then click on execute, all of the column names are filled ...

SQL Sentence count disctint

Alejandro - 13 Oct 2006 8:26 PM - 3 messages

Hi I have 1 app that always make SELECT count(DISTINCT cedula) FROM(matrix_odontograma) This is very slow in 1 MB of record, exist any way to make this more efficient ? ...

Zip Code Import

Colette - 13 Oct 2006 7:23 PM - 4 messages

I need to derive address information from the zip code. I have a zip code file that I need to put into a SQL table. What's the best way to do that? ...

Uninstall/Reninstall Help!

Kevin Thomas - 13 Oct 2006 6:31 PM - 3 messages

System: IBM ThinkPad running Windows XP Pro 2002 SP2 Problem: MSDE and Microsoft SQL folders were manually deleted from within C:\Program Files. Now I am unable to get MSDE or SQL to install successfully again. I tried to re-install my original version of SQL and ...

table query

coenzyme - 13 Oct 2006 6:11 PM - 3 messages

Does anyone have a query that will select a group of tables and at a scheduled time return the number of records in each table to another table? Thanks to eveyone for being there to help. SQL 2000 ...

what mssql versions/sp's will run on Win2k3 without sp1?

Keithb - 13 Oct 2006 6:04 PM - 2 messages

We need to deploy sql server on a windows 2003 box that does not and cannot have SP1 due to conflicts with other applications. What is the most recent sql server version/service pack that will run on Windows 2003 without sp1? ...

How does SQL Server Management Studio count query lines?

Keithb - 13 Oct 2006 5:26 PM - 4 messages

How does SQL Server Management Studio count query lines? Running table creation scripts on a 2000 instance using scripts created in 2005, I get the error messages shown below. There are no '(' characters on the designated lines. Furthemore, if delete the designated lines and parse the script ...

xp_logininfo in SQL 2005

Michael Viking - 13 Oct 2006 4:47 PM - 5 messages

Greetings! Our software depends on customers being able to give users access to xp_logininfo. Now with SQL 2005 we have the wonderful " In earlier versions of Microsoft SQL Server, permission to execute xp_logininfo can be granted to users. In SQL Server 2005, xp_logininfo can ...

DROP a Mirrored DB

shaun.steckley - 13 Oct 2006 4:22 PM - 3 messages

I setup Database Mirroring for the first time on SQL 2005 SP1 and am at a point where I want to delete the mirrored test database. However, when I try to drop the DB on the mirrored server I receive an error. ...

Database design question

Mindy - 13 Oct 2006 4:03 PM - 5 messages

Hi, I am working on a Budgeting web based application using ASP.NET 2 and SQL Server 2000. The budgeting data will build up over a course of period and these historical data will be used for decision making in future budget. ...

sp_spaceused reports negative unallocated space

Mark Stricker - 13 Oct 2006 3:34 PM - 7 messages

sp_spaceused is reporting negative unallocated space for about 20 of the 130 databases I am tracking. In other words, the database is using more space than is allocated. That, of course, must be incorrect. Here's an example: ...

Inserting a pdf from the file system into a table

John Scott - 13 Oct 2006 3:30 PM - 4 messages

Hi there...I have a pdf that is generated using Reporting Services. RSS works fine in creating these files and puts them all into a directory. But, I do not want to store the files on the file system, but rather back in the ...

Unique field pair constraints

Chris Crowther - 13 Oct 2006 3:09 PM - 3 messages

Hi All, Is it possible to create an SQL Server constraint that enforces uniqueness of a field pair combination? I have a table with three fields, all Int values. One field is merely a unique ID for the row in the table, the other two fields contain the ...

Detach/Delete

John Holt - 13 Oct 2006 2:35 PM - 5 messages

I have noticed that a Detach is almost instant and a Delete can take a few. I have detached a lot of databases and am wondering if there is some kind of cleanup I should be doing. I know the Detach leaves the data files intact, ...

Table Collation

Cenk FIRAT - 13 Oct 2006 2:31 PM - 3 messages

Hi, I have tables (it has data) and i want to change table collation (not column collation) is it possible? if possible how i can change table collation? Thanks, Cenk FIRAT ...

SQL Server 2005 - Disable Remote Connections

Joe K. - 13 Oct 2006 1:50 PM - 2 messages

I loaded the SQL Server 2005 evaluation copy on my computer that has XP Professional operating system. I received the error listed below when I tried to connect to the Database Engine. The SQL Server Brower service is ...

counting values in aresult set

Rory - 13 Oct 2006 12:56 PM - 8 messages

Hi, I have the following query: SELECT ahd.call_req.ref_num AS Incident FROM ahd.call_req JOIN ahd.act_log ON ahd.act_log.call_req_id=ahd.call_req.persid WHERE ahd.act_log.type = 'TR' which returns a single column called Incidents containing integer values. ...

Can we install SQL Server 2000 on same server with SQL Server 2005

Marceepoo - 13 Oct 2006 11:46 AM - 4 messages

We have SQL Server 2005 running on our main server. We need to install an application that is programmed for SQL Server 2000. We are planning to have the application upgraded to SQL Server 2005, but that will take time and we ...

count sproc executions

sam.m.gardiner - 13 Oct 2006 11:19 AM - 5 messages

is there a dynamic view or function that I can call to find the number of times a sproc or function has executed? I am looking at a report generated from the summary page in sql server 2005 management studio that says a function has executed 12,000,000 ...

Query.....help

amatuer - 13 Oct 2006 7:17 AM - 2 messages

Cloumn Name, Data type, length, allow nulls: ID int 4 0 NAAM nvarchar 254 1 DATUM smalldatetime 4 1 Dag int 4 1 Maand int 4 1 Jaar int 4 1 Reenval_Silo float 8 1 Using this table i need to get the average of "Reenval_Silo" per month ...

AWE Memory?

Fredrik - 13 Oct 2006 7:03 AM - 8 messages

Hi all? I've tried reading about how AWE memory works but I really can't figure it out... I have a dedicated SQL Server 2000 SP4, Ent Edition that runs on a Windows 2003 Advanced server. The box has 4 Gbytes RAM and I want to be able to use ...

SQL Server 2000 Datatype and length question

Jason Huang - 13 Oct 2006 3:49 AM - 5 messages

Hi, In my SQL Server 2000, a column Tax which datatype is float and it's default length is 10. But in my SQl Query Analyzer, when I SELECT from the INFORMATION_SCHEMA.COLUMNS, it's Numecir_Precision is 53. Why it's not 10? ...

Can't connect to new sql server instance

Keithb - 13 Oct 2006 3:03 AM - 3 messages

I installed sql server 2000 on a box that already has sql server 2005 installed. I used an instance name of "{machine name}/mssql2k" and I'm trying to connect using {machine name}/mssql2k. When I open SQL Server Management Studio and try to connect to the new instance, I get the message ...

How to name different database instances?

Keithb - 13 Oct 2006 12:25 AM - 3 messages

I now have an instance of sql server 2005 installed on my development box. That instance uses the machine name and there seems to be no other reference to an instance name. Now, I need to also install an instance of sql server ...

Help with Query

Charles A. Lackman - 13 Oct 2006 12:03 AM - 2 messages

I have the following table: TableName: Customers ID - Integer CustomerID - VarChar Name - VarChar LoanNo= Int Amount = Money ID CustomerID Name LoanNo Amount ...

Cannot CREATE ASSEMBLY

landers - 12 Oct 2006 10:46 PM - 2 messages

Hi, I am new to SQL Server 2005 but not to dotnet development. I am trying to use the CREATE ASSEMBLY on my machine that is running the developer edition. The ASSEMBLY keyword is not highlighted as a recognised keyword and when I ...

Scan events

Alex - 12 Oct 2006 10:18 PM - 4 messages

Hi friends, I'm curious about those events. Profiler shows scans regardles whether it's index seek or real index scan. And values in Mode column seem to be not much of help to filter out index seeks. What are they about in fact? Did anyone ...

Update table if condition is met?

aljamala - 12 Oct 2006 7:50 PM - 7 messages

Hello, I am having difficulty finding a way to convert this code into a stored procedure on SQL Server...Here is the original code IF Request("updflag" & n) = "Y" then cmdTemp.CommandText = " SELECT ast.asset_id, " & _ ...

Exclamation Message in Security logins

gv - 12 Oct 2006 7:28 PM - 4 messages

Hi, Ok maybe I posted this in the wrong thread before. I restored 4 databases onto another SQL server and added sql logins. When I click on a login under Security I get this Exclamation message? "One or more databases are inaccessible and will not be displayed in the ...

publishing sql 2005

param - 12 Oct 2006 7:01 PM - 2 messages

Hi all, I need to publish my SQL2005 cluster in ISA 2004 for access to my DMZ Web servers. But I need to know which TCP port to publish. When I check SQL Config Manager it says dynamic ports? TIA! ...

Restoring records in a particular table

Srik - 12 Oct 2006 6:34 PM - 6 messages

Hi, I have unknowingly deleted 100 records instead of 1 record. I haven't set autocommit off also... Could you please let me know if there is any way to get back those records... Thanks in advance... ...

question about numeric type

Jen - 12 Oct 2006 6:21 PM - 7 messages

Hi, I am kind of confused regarding the numeric data type. If I define a numeric column to be precision 38 (the maximum allowed), in EM the column length automatically turns to be 17. What's the relationship between 38 and 17? ...

Automatically Create Linked Server If Not Exists

Matthew - 12 Oct 2006 5:22 PM - 4 messages

I was hoping this would be simple but like everything lately there seems to be some catch. What I am trying to do is if one of my SP makes a request to another system, if the Linked Server does not exists, it will create it on the ...

SQL Proxy Account Error

Jeff Sanders - 12 Oct 2006 4:52 PM - 8 messages

I get the following error when trying to reset the SQL Server 200 Proxy Account: "Unable to set the sql agent proxy account because of the reason listed below. 'error executing extended stored procedure: specified user can not login'" If anyone has any ideas or suggestions, it would be greatly appreciated. ...

A question on indexed views and the optimizer ...

sqlpractitioner - 12 Oct 2006 4:47 PM - 2 messages

Gentle SQL gurus, Say I have a table "a" which has a column "ca". And I have a table "b" which has a column "cb". And I define a view "ajoinb" as create view ajoinb as select ..., a.ca, b.cb, ... ...

Is it possible to change the initial size of the transaction log?

Rob Pain - 12 Oct 2006 4:43 PM - 5 messages

I have a database, and the log file would appear to have been created with some default settings (it is 512Kb size, which I believe is the minimum SQL 2000 can allocate, and its auto-grow factor is 10%). When I insert some binary data into an image column, I can see a whole ...

Setting Permissions

kuhrty - 12 Oct 2006 4:02 PM - 2 messages

Is there a way to set several group permissions on many tables and SP at once? During development we can get away from doing so, in QA, we are moving in 15 tables and 40 SP's. Instead manually doing it and ...

Problem backing up databases with maintenance plan

Greensombrero - 12 Oct 2006 3:56 PM - 2 messages

I'm having a strange error when I try and backup several databases using a maintenance plan. The first couple will backup but then I get the following error: Failed:(-1073548784) Executing the query "BACKUP DATABASE [TfsWorkItemTracking] TO DISK = ...

Sysmon

Rob - 12 Oct 2006 3:32 PM - 2 messages

Hi, One of our servers recently lost a memory module and now the server has lost 25% of its memory (4 GB to 3GB). I'd like to run Sysmon on this server for the next couple of days to capture key counters to help me understand if ...

How can db_owner restore db from backup and keep his permissions?

HP - 12 Oct 2006 3:22 PM - 2 messages

Hi there I'm developing an application, and from time to time I take it to production environment and keep it up to date with dev version. When I tried to do this alone (istead of sysadmin) I got some error saying ...

AWE Memory: Seeing approx. 1 Gig less than expected

cbrichards via SQLMonster.com - 12 Oct 2006 3:02 PM - 5 messages

I am runnning a dedicated SQL Server 2005 Standard edition server on Win 2003, with 16 GB RAM. I have AWE enabled, with a Max Server Memory of 14336 (14 GB). I have /3GB /PAE set in the boot.ini. ...

backup for SQL Server Express

Joel - 12 Oct 2006 2:30 PM - 5 messages

Can someone tell me how to backup SQL server express 2005? ...

Licensing Question

Michael K. Walter - 12 Oct 2006 2:20 PM - 4 messages

First - sorry if this is not the right place for this - but I didn't see a better one. I have a client who has licensed SQLServer 2000 Std edition + 50 or so CALs. They have no maintenance/License Assurance contract. What options do they ...

SQL Servers

AF - 12 Oct 2006 1:55 PM - 7 messages

I have some extra gear that I would like to setup to function as an extra server for reads.. is this possible? ...

Failure Audit for SQL Server

DXC - 12 Oct 2006 1:41 PM - 6 messages

I am getting the below Failure Audit in the SQL Server event log for 3 users. All the users have access to a database in SQL Server with their domain account. Below message keeps poping every second. How can I trouble shoot ...

Space padding in SQL server

Jerry C - 12 Oct 2006 12:57 PM - 4 messages

I have several databases and some of them will pad text with spaces to the width of the field and some don't. Is there a setting in a database or server that controls the trailing spaces?. SQL like "Select * from mytable" in some databases the fields are padded and ...

insert performance varies

kh - 12 Oct 2006 12:47 PM - 4 messages

hi. i'm no dba and wouldn't mind a few pointers for investigation of an issue i have with sql server 2000 sp3. i am running a script within query analyzer. the batch includes hundreds of deletes followed by hundreds of inserts, all ...

Question as to why dates have two quotes as ''2006-09-26 17:05:30:730'' in Profiler

ben brugman - 12 Oct 2006 8:15 AM - 6 messages

This question was asked in the microsoft.public.sqlserver.programming by 'Farmer'. I found the question by Googling, this confirms a problem we have, but there were no answers to why this is happening, or what a solution is to this ...

Configure Integration Services on a Cluster

Brad Baker - 12 Oct 2006 6:19 AM - 7 messages

We are attempting to setup Integration Services on a Cluster per the following article: [link] We have the following Cluster Groups/resources "Cluster Group" Disk Q - Quorum Disk R - MSDTC ...

trigger - crate string from other columns

adamwalan - 12 Oct 2006 5:24 AM - 7 messages

I have table table1 with columns pk - int, is_blond - bit , is_brunet - bit , test - char(200) I want to create trigger, which will do: if is_blond=1 temp="one" ELSE temp="zero" if is_brunet=1 temp=temp+" three" ELSE temp=temp+" four" ...

is there a way to increase the datetime range of sql server 2005

kamal - 12 Oct 2006 1:44 AM - 5 messages

hello everybody, the existing datetime range of sql server 2005 which is between Jan 1, 1753 and Dec 31, 9999 is creating problems. Some of the dates i would like to store are lesser than 1753. The lower range is not ...

Is there an easy way to switch a table from "ANSI NULLS OFF" to "ANSI NULLS OFF"

sqlpractitioner - 12 Oct 2006 1:04 AM - 7 messages

We have some tables with quite a lot of data (in the order of tens of millions of rows) which were created with ANSI NULLS OFF. Now that we want to create some indexed views we need these tables to have ANSI ...

Trigger usage

Frank Rizzo - 12 Oct 2006 12:44 AM - 3 messages

Hello, I have a table called tblWhatever. I have an update trigger for this table called trg_tblWhatever_upd. I run an update query against the table update tblWhatever set someField = 'stuff' where 1 = 0 Basically no rows will be updated in the tblWhatever table. Why does ...

OPTION (Keepfixed plan) syntax

Frank Rizzo - 11 Oct 2006 10:34 PM - 4 messages

I am at a bit of a loss as to how I can use the OPTION (KEEPFIXED PLAN) statement in the query where I have it below. Currently, it won't compile - it complains on invalid syntax. I am trying to prevent SQL ...

DENY "DELETE" persmission for a user on a table in SQL SERVER 2000

loga123 - 11 Oct 2006 10:21 PM - 2 messages

hi all, I would like to DENY "DELETE" permission for a user on table in SQL Server 2000. The user "testUser" is a member of "public" role, "A" role, "B" role. These roles have been granted "DELETE" permission for the table. ...

Linked server delegation problem, works for a while after reboots

Martin M - 11 Oct 2006 10:02 PM - 6 messages

I have two SQL servers setup with linked servers pointing back and forth between them. The first is running SQL Server 2005 with the post SP1 hotfix. The second is running SQL Server 2000 SP4. Both are running on Windows ...

DBCC Shrinkfile

Rob - 11 Oct 2006 9:19 PM - 2 messages

Hi, Can someone tell me of some the reasons why DBCC Shrinkfile does not shrink the size of the log file in my SQL Server 2000 server? After backing up the log file, I tried to shrink the physical size of the log file to 2000 MB but ...

Newbie question - disk defrag

Si - 11 Oct 2006 8:30 PM - 3 messages

Hi all Please ignore my lack of knowledge, im new to sql... I would like to defrag my sql databases and have found several sources on the net that recommend using the command DBCC INDEXDEFRAG. When I try and run this from the command prompt i get DBCC is not a ...

Server change causes Query to be slow.

ITContractor - 11 Oct 2006 7:00 PM - 9 messages

I would appreciate input or suggestions for further troubleshooting for the following configuration. Please find essential details following for your convenience. Hardware Dell SC1420 Two Processors (Xeon 3.0Ghz) SQL Server 2000 SP3 Default SQL Server settings (NOTE: shows four processors !) ...

sql2000-> excel file

Paul - 11 Oct 2006 6:03 PM - 5 messages

I was not sure if I should post this in the office forum but just wondering if anyone knows if there is a way to display an excel file in a webform (.net application) that reads data off of an sql 2000 database? I was able to ...

sp_change_monitor_role; Role change failed. [SQLSTATE 42000]

Juanjo - 11 Oct 2006 5:59 PM - 3 messages

Hi, I am working on a Log shipping solution with SQL server 2000 and I find some problems. I have already solved some of them thanks to these newsgroups but I still have one pending: At the end of the role change, once I execute sp_change_monitor_role I get ...

SQL 2005 DB Script

Randy - 11 Oct 2006 5:21 PM - 3 messages

Hi, Is there a way in Management Studio to create the insert commands for tables with data? Thanks ...

SQL Server 2000 Transaction Recovery

Jack - 11 Oct 2006 5:11 PM - 9 messages

I goofed and did not have a maintenance plan running. Someone deleted a folder in Sharepoint with thousands of documents. Since no backup has been run, the transaction log has not been truncated. Is there any way to roll back all transactions since Monday, or am I hosed? ...

SQL Server 2005 -Trying to setup email alerts once backup is done.

Sam Commar - 11 Oct 2006 4:29 PM - 4 messages

I am using SQL 2005 and setting up alerts once backups are completed. I have setup SQL mail but am unsure of process of setting up the email alert Could someone please guide me on the same. Thanks Sam Commar ...

SQL Server won't start due to full log file

slisbin - 11 Oct 2006 4:25 PM - 4 messages

Firstly, I am not a DBA but am "standing in" as there is no one else available. I only know enough to be dangerous... We cannot start our SQL Server 2000 due to the log being full. I cannot find a way to clear it out without being able to connect. ...

SQL Server 2005 / SQL Server 2000 - XP Professional

Joe K. - 11 Oct 2006 4:16 PM - 3 messages

Is it possible to load SQL Server 2000 and SQL Server 2005 on the same computer with XP Professional operating system? ...

Can you alter the DB freespace during a restore?

BH337 - 11 Oct 2006 3:39 PM - 3 messages

Can you restore a database from a .bak file to another server and configure the amount of "free space" available differently from the original database? For example, your backup server has a different Hard Drive configuration than the original and you need to adjust the total DB size to fit on the new ...

Backup SQL 2005 to SQL 2000

sonicm - 11 Oct 2006 3:25 PM - 2 messages

Hi, Is there anyway to restore a database that was created on SQL 2005 into SQL 2000. We have a database that I have been doing some testing on, on SQL 2005 and need to restore it back to SQL 2000 but keep getting various messages. ...

Backup SQL 2005 - Restore In SQL 2000

sonicm - 11 Oct 2006 3:04 PM - 3 messages

Hi, I have been testing a database in SQL 2005 (keeping it in 2000 Mode from the properties) and need to restore it back to another machine running SQL 2000 SP4. I am getting errors and cannot find a way to do it? Can any one help ...

Performance

Chico - 11 Oct 2006 2:49 PM - 3 messages

Hi I have a sql server 2000 running with SP4. My goal is the improvement of server prformance! Can i install server performance advisor and get about SQL? Regards ...

converting varchar to smallmoney

thomas - 11 Oct 2006 12:37 PM - 2 messages

Hi My ticket engine stores values in varchar. The sql db-field that corresponds was created as smallmoney. The below statement works for conversion of "leavedays" if the given value is entered without any decimal places (E.G. 4) As soon as a user enters a value that includes decimal places (E.G. ...

SQL 2005 - Bulk insert task error

Sabo, Eric - 11 Oct 2006 12:04 PM - 4 messages

We are trying to do a bulk insert task from a windows xp SP2 workstation that has the sql 2005 client tools installed with Visual Studio 2005. We are getting the following error when we are doing the bulk insert task - "cannot ...

SQL2005 Piecemeal Recovery

Woo - 11 Oct 2006 11:48 AM - 7 messages

Hi, I have a question about SQL2005 piecemeal recovery. This gives the option to get the database online while corrupt files/filesgroups remain offline. But when restoring these corrupt read-write files/filesgroups, would they need to be rolled forward to the ...

Insert only if not still exist?

rene - 11 Oct 2006 10:04 AM - 4 messages

Hello, I need a statement to insert some data into a table with autoincrement - but only if there is not the same data still in the table. I think it's a combined Insert/Select state, isn't it? ...

windows event log bloat with SQL 2005

Tim_Mac - 11 Oct 2006 9:42 AM - 4 messages

hi, my system application log is getting written to every minute or two by SQL 2005, with a 'starting up' event. a sample event is below this message. if something goes wrong in a database then i have enough confidence in SQL ...

opposite query

amatuer - 11 Oct 2006 6:52 AM - 4 messages

Hi, Need some help with a query, this is what it looks like: SELECT TOP 10 * FROM [dbo].[R_Reenval] Now how do i get the bottom/last 10 records? I tried replacing the ...

execute a big query without writing to transaction log

Ya Ya - 11 Oct 2006 5:37 AM - 8 messages

I need to execute a big delete query. The problem is that this delete query creates a big transaction log that is bigger then my free space on the HD. Is it possible to execute this delete query without writing the transactions ...

Online Restore.

Mahesh - 11 Oct 2006 5:27 AM - 6 messages

Hi, Can i take backup(not full db, only one filegroup) of a database in Server1 and restore it on a same database in another server2 using Online Restore commands. Note:both database has same schema and data. Addtional data in few tables in server1 needs to be copied to server2 ...

Scheduling jobs?

philt - 11 Oct 2006 3:54 AM - 3 messages

I need to schedule a job to run 6 days after the last Friday of the month. How would I go about this? Using SQL Server 2000 SP4 thanks in advanced. ...

Remember password checkbox does NOT remember password

Jani Hovilainen - 11 Oct 2006 3:05 AM - 5 messages

SQL Server 2005->SQL Server Management Studio->Connect to Server-window: Remember password-checkbox does not stay checked and the password field is emptied. How many years still for a company that has 31 billion dollars in cash to fix this annoying problem in a login screen on one of their most ...

Question about profiling SQL Server Express

JC - 11 Oct 2006 2:07 AM - 3 messages

Anyone here know of a guide to profiling for MS SQL Server Express? ...

SQL Authentication

Rustom - 10 Oct 2006 11:52 PM - 2 messages

I am running SQL Server 2005 in a Windows Server 2003 domain and utilizing Windows Authentication. I have a webserver running a Visual Studio application which resides in the DMZ on a Windows Workgroup. From a security perspective what is the best practice with regards to how this ...

Actual vs. Estimated Row Counts

cbrichards via SQLMonster.com - 10 Oct 2006 10:31 PM - 4 messages

I have a stored procedure that contains a complex query of approximately 16 joins, (a mixture of inner and left joins). These joins are mostly on standard user tables, but includes joins on two temporary tables and two non- indexable views. ...

What is the 'logical' file name?

kevin bailey - 10 Oct 2006 10:00 PM - 6 messages

What is the 'logical' file name? When restoring over a different database I use the WITH MOVE option to change the name of the physical file. But what is the logical file name? I don't alter it and the restore seems to work fine but I'd like to know ...

Installing multiple instances of MSDE on the same system.

JDeats - 10 Oct 2006 9:56 PM - 2 messages

I am trying to install a second instance of MSDE on the same machine. setup SAPWD="mystrongname" INSTANCENAME="instancename" DATADIR="C:\MydataDir" TARGETDIR="C:\MyInstanceFolder" All of the above attributes are unique to this new instance. When I try to run this I get prompted with "Product: Microsoft SQL ...

Looking For Data Diagram Software

Vito Corleone - 10 Oct 2006 9:54 PM - 2 messages

Hi SQL Gurus, I have a database that has 250 tables. I need to a 3rd party software that will generate data diagram for me. I used data diagram from sql but it is useless with a huge amount of tables. ...

Using COLLATE in ORDER BY?

Maury Markowitz - 10 Oct 2006 9:39 PM - 3 messages

Apparently my complaints about sorting can be addressed using the COLLATE clause. So I modified my select like this... select col1, col2 COLLATE Latin1_General_CS_AS_KS_WS from stuff order by col1, col2 COLLATE Latin1_General_CS_AS_KS_WS It appears to have no effect, however. I would have thought that selecting ...

Enterprise Manager performance

Glenn Coello - 10 Oct 2006 9:25 PM - 5 messages

Not sure what category this belongs to, so sqlserver.server it is... Anyway, I am experiencing signficant performance problems using SS2K Enterprise Manager. Any action, including something as simple as expanding the list of databases on a server takes takes an incredibly long time. ...

Need to access the impact of changing IP address

LanLan - 10 Oct 2006 9:08 PM - 2 messages

we plan to move our sql server from one place to another place. It's IP has to been changed, yet the hostname can be kept. I need to access the possible impact of this move. Our application server query the datababase by server ...

adding a filegroup

Bill - 10 Oct 2006 9:06 PM - 6 messages

when you add a filegroup to a existing server on a half full harddrive does it take longer to add if the file group size is very large likje over 100 gigs *** Sent via Developersdex [link] *** ...

Sorting alphanumertics properly?

Maury Markowitz - 10 Oct 2006 7:56 PM - 10 messages

I have a table that has two columns: Blob A1 Blob A2 Blob A11 Thing B1 Thing B5 Thing B12 When I sort of ORDER BY col1, col2, I get: Blob A1 ...

Log Shipping Problem

Fran Morabito - 10 Oct 2006 7:47 PM - 2 messages

I have a warm standby 2003 Server and am trying to set up log shipping. I am working with SQL Server 2005 and have created the log shipping jobs using the wizard. Initially as suggested in the documentation, I backed up the primary ...

SQL memory upgrade

insert statement script/stored proc.

Masking Question

q; radius search

Import CSV

SQL Connection problem - Help!

simple synchroniation script needed

Cannot Drop Server

production database down....hangs on startup..URGENT

when to use mulitple file groups?

Set field to insert current datetime.

NOP command in Sysprocesses

Use of SQL reserved word GO

SQL Server 2005 on OS XP Professional

Maintenance plan problem

Using NEWID in SPs

URGENT xp_cmsshell asp page and xml

Day Of The Week Aggregate

Construction of view or sp

How to verify that the data of one table is a subset of another ta

How to persist a sql server connection?

Data Diagrams

SQL License & Configuration

Index Column Order of Operations

SQL Server and Active Directrory

CATCH block question

Stored Procedures

database mirroring error? -- Scenario HASL2.3

Stmt_End?

Blocking

General Question on Maintenance Plans

Error 3627 (Could not create worker thread) - Transaction Log Back

Sugestions to create my RAIDS.

Maintenance Plan

Establish log dhipping db in sql2005

sp_addlinkedserver not working with network files

DDL Server Trigger Error (SQL2005)

calling all gurus! - simple synchronisation and backups - best plan needed!

sp_cursorprepexec using wrong index

Diskperf on Windows Server 2003 Standard Edition.

Restoring a large database

launch report manager

Exporting SQL 2005 Maintenance Plans on SQL Cluster

.sql scripts NEBIE ALERT

SQL 2005 capability

NULL vs. empty strings, SQL Server setting

Large sql statement with 5000 insert and update commands

Split one field into two fields

Re: How to determine the best setting for Max Worker Threads

SQL locks with results parallelism

missing file to uninstall SQL Server 2000...

Database Design vs Database Modelling..