SQL Newsgroups: Microsoft SQL Server Administration

When do save the backup file?

Don - 10 Mar 2007 11:41 PM - 3 messages

Hello, I have inherited a system were at midnight a full back is done. Every hour a log backup is added to the backup device until it is reset again at midnight. The backup file is saved off to a tape backup at 12:15 ...

SQL Server 2005 SP2 on Vista Ultimate

dustyg99 - 10 Mar 2007 7:58 PM - 6 messages

I'm attempting to get SQL 2005 SP2 installed on vista ultimate. I apologize if this has been answsered but I've done about 2 hrs of searching on MSDN and google and 30 mins in google groups with no ...

Minimizing Fragmentation of table having Non-clustered Index.

csajid - 10 Mar 2007 3:33 PM - 5 messages

Hi All, i am working on SQL Server 2000 EE. I want to know that, is there any way to rebuild Non clustered index. How can we minimize fragmentation of table having non clustered index. can we defrag non clustred index. ...

Integrate Service Pack

Daniel Jameson - 9 Mar 2007 10:16 PM - 3 messages

Hi, With Windows XP and its Service Pack 2, one is able to run the service pack at the command line with an -integrate option, and it will update an RTM Windows XP install file set to an SP2 Windows XP install file set. ...

Increment Value, Where to find

tobiwan_kenobi - 9 Mar 2007 9:26 PM - 2 messages

Where in the system tables can I query to find the increment value for identity columns? ...

Increment Value of an Identity, How can we Change the

tobiwan_kenobi - 9 Mar 2007 9:23 PM - 2 messages

We are aware of several different ways of changing the increment value of an identity, such as 1. Use the modify menu item in the sql manager 2. Use a script to drop and then recreate the tables. ...

HELP: update a table from a text file

Warren, John - 9 Mar 2007 8:37 PM - 2 messages

I have a field in a DB that I want to update with the contents of a text file. I retrieved the contents of the text file FROM the entry but now that I edited them, I want to put them back. ...

Find out what is written into transaction log

ChanKaiShi - 9 Mar 2007 7:41 PM - 2 messages

Hi, My transaction log grows around 5 Gb an hour. I'm trying to find out what is being written there and running SQL profiler. I can find very few transactions with Writes other then 0. How can I find out what is being ...

Error 2812 Could not Find Stored Procedure msdb.dbo.sp_add_jobstep_internal

rubeel - 9 Mar 2007 6:46 PM - 2 messages

Getting this error when trying to create an instance as a Publisher. SQL Server 2000 SP4 reinstalled SP4 and that doesn't help Error 2812 Could not Find Stored Procedure msdb.dbo.sp_add_jobstep_internal ...

SQL 2000 Enterprise AWE

Patrick Rouse - 9 Mar 2007 4:48 PM - 6 messages

A client SQL Server 2000 Enterprise SP4 on 2000 Advanced SP4 w/ 8GB RAM. /PAE is in the boot.ini and AWE is enabled via SQL Script, but in task manager mem usage never goes above 4447036, i.e. 4GB. I checked the sqlerror ...

About change simple recovery modle to full recovery modle

Iter - 9 Mar 2007 4:41 PM - 3 messages

Hi Guys, I changed simple recovery modle to full recovery modle, but I monitor ther log file still not to be increased. IN the beginning it is increased, but after seconds,, in go back to original. Like simples modle. Can someone tell ...

sql server 2000 maintenance plan that starts at 2:00 AM (DST)

db - 9 Mar 2007 4:30 PM - 3 messages

Hi Do I need to modify maintenance plans for sunday for DST changes. Windows patches have been applied. Thanks in advance ...

need to move system DBs - detach is grayed out - what to do?

Rich - 9 Mar 2007 4:12 PM - 6 messages

Greetings, The system databases (master, tempdb,...) all installed on the C drive of our server. C drive is getting filled up. I need to move these DBs but the Detach option in Enterprise manager is grayed out. One of our production ...

restore all database

gnp1977 - 9 Mar 2007 3:48 PM - 7 messages

Hi, again me, just a simple question, how can I restore all my databases from a full backup. Not one by one, instead I´d like to do this un just one automatized process, where the user just start it and forget it. ...

Irregularly Occurring Performance Problem over Linked Servers

jkenney - 9 Mar 2007 3:24 PM - 3 messages

Hi all - I was wondering if anybody had encountered this. My shop is suddenly having difficulties with procs and scripts that were running fine, but are now hitting a wall. The indexes haven't changed, the statistics have been updated, we've tried various tuning strategies, ...

Can I rename a server with SQL Server on it?

Simon Harvey - 9 Mar 2007 3:08 PM - 5 messages

Hi all, I need to move an SQL Server machine to a client's site and we need to change the computer name and attach it to the companies domain. Can anyone tell me if renaming the machine will upset SQL Server or is ...

Is Truncating Log commiting data the the actual DB?

Phillip Vong - 9 Mar 2007 1:46 PM - 5 messages

Newbie question running SQL 2k My last entry in the .mdb file was January and everything else has been sitting in the Transaction log files. Everything works fine. I'm just wondering if Truncating the logs mean I'm going to commit the data from the ...

How to Increase maximum row size

Sudhakara.T.P. - 9 Mar 2007 1:32 PM - 3 messages

Hi, I have an database migration project wherein I need to migrate data from FileMaker Pro to SQL. The FileMaker Pro stores files as flat files and there are more than 300 fields in one table. Now when I try to create the same ...

SQL Server on a Domain Controller

PJ - 9 Mar 2007 12:25 PM - 2 messages

Hi, I have SQL Server 2000 Standard SP2 running on a Windows 2000 Server Standard SP4 domain controller and I would like to demote the server down to a member server. My question is how will this affect the SQL side of things? Is there ...

SQL Server and fixed memory question

Andreas B - 9 Mar 2007 9:09 AM - 7 messages

Hi, I need some help on the memory management: We have configured SQL Server 2000 to use a fix amount of 5 GB memory. According to the SQL Server it uses 5 GB. If I look at the Performance Tab of ...

BCP output

Swagener - 9 Mar 2007 8:42 AM - 5 messages

Hi All, The syntaxt below is not outputting any text file at the location specified. Any Ideas ! use tempdb go Create view vw_bcpMasterSysobjects as select name = '"' + name + '"' , crdate = '"' + convert(varchar(8), crdate, 112) + '"' , crtime = '"' + convert(varchar(8), crdate, 108) + '"' from master..sysobjects ...

Creating Stored Procedures Through VB.NET

Jonny - 9 Mar 2007 8:11 AM - 2 messages

Hello, I've trying to create some stored procedures through VB.Net by adding an SQLDataAdapter, and following the wizard. In the wizard I then choose to "Create Stored Procedures Automatically" However, for some reason I get the following message : ...

Deleting old backups

Ant - 9 Mar 2007 8:11 AM - 2 messages

Hi, I'd like to set up a job SQL Server agent which will delete backup files older than several months once a backup has succeeded. How can I write a step to do this? Bascially, it will be: if *.BAK > dateadd(m, -2, getdate()) then delete ...

How to write a message to SQL Server logs (SQL2000)

jcvoon - 9 Mar 2007 6:57 AM - 2 messages

Hi: I'm using xp_logevent to write a message to SQL Server logs: EXEC master.dbo.xp_logevent 99999, 'Testing', INFORMATIONAL But in SQL Server logs it show two lines of message, one is the message that i log which is 'Testing', another one is 'Error: 99999, ...

DTC question

Falconer - 9 Mar 2007 5:57 AM - 3 messages

Hi friends, If I have a ms dtc log file on my hands, and it is, I believe, in some binary format, is there any way to view it? Thanks a lot in advance ...

Sending fields at runtime to a stored procedure

maflatoun - 9 Mar 2007 2:33 AM - 2 messages

Hi, I have a C# web app that searches my database table using the following search parameters Search string, criteria (> < =) and the field you want to perform your search on. My understanding is that stored procedure is the way to go. ...

Default installation to named one

manu - 8 Mar 2007 10:05 PM - 2 messages

Hi, I have installed sql server on one of my box as a named installation and now I want to change it to default one without re-installing sql server. Please suggest how should I go for it. Also, whether it is possible or not. ...

How to use sql server 2000 with SSL

Ashish kanoongo - 8 Mar 2007 8:58 PM - 2 messages

Hello I want to Use sql server 2000 with SSL. Is this possible. Ashish ...

How to divide 1 datafile on new filegroup?

Fabio Rebelo - 8 Mar 2007 8:18 PM - 3 messages

Hi, I have a big problem with my SAP database. Our SQL Server (2000 SP4) have 3 datafiles with 300GB each on the default PRIMARY filegroup. Is very hard to me maintain database with these 3 big files. I want ...

Syntax help with comparing datename quarter functions

Paul - 8 Mar 2007 7:38 PM - 4 messages

Hello, I'm programming this into a reporting front end that sits on top of MS SQL 2000 database. My user community wants a column added to reports that is basically a "Yes" flag. They want to know if a sale is ...

Query to give me list of dbs + db size

Hassan - 8 Mar 2007 7:09 PM - 2 messages

How can I get a query that i can run against a SQL Server to get a list of dbs and its size such as Name Total DB Size Allocated DB Usage Total Log Size ...

SQL 2005 Limits

Lisa - 8 Mar 2007 7:02 PM - 5 messages

In SQL2000, there is a limit of 1024 fields in a table. Does this limit still exist in 2005? ...

SQL2005 Service Packs

IanP - 8 Mar 2007 6:55 PM - 8 messages

Just installed SP2a and database version number shown as 9.00.3050.00 and not 2005.90.3042.01 as expected and according to all docs on SPs I can find What is 3050.00 - sp3! released early and not documented? ...

Having trouble installing SQL Server 2005 SP2

Edward Ray - 8 Mar 2007 6:54 PM - 6 messages

The computer is a Windows 2003 R2 Enterprise 32-bit installed in a Windows 2003 R2 native AD domain/forest, and has WSUS/IIS6 running as well as SQL Server 2005 standard. When trying to install it fails with the following ...

Installing SQL Server 2000 Instance

rubeel - 8 Mar 2007 5:05 PM - 3 messages

I am trying to install a new instance and it asks me to kill the tasks for sql server other instances that are running. this occurs are the MDAC 2.6 setup. I have MDAC 2.8 installed on the box but this still ...

Password protected stored procedure question

Varied_Interest - 8 Mar 2007 5:03 PM - 4 messages

I have a password protected stored procedure that I have created. If the user issues just the name of the stored procedure he gets a message telling him that he needs to input the password. If the user inputs the wrong password he gets a "syntax error" message ...

New SP2 Client Install Failure

Chris Wood - 8 Mar 2007 4:56 PM - 3 messages

Hi, I have successfully upgraded a server with both the new SP2 and the 3050 hotfix. I am now trying to do this to my client workstation. It selected the following components on my SQL2005 SP1 client to upgrade. Setup Support Files ...

File Generation through the DTS

tolcis - 8 Mar 2007 4:54 PM - 4 messages

I have created a DTS package (SQL 2000) that generates an Excel file. The first time it works great but every time after that the DTS would append the data to a file and not overwrite it. I need to be ...

How do I display SQL Server 1/1/1900 dates as blank in Access?

Michael Nagan - 8 Mar 2007 4:12 PM - 2 messages

Is there an easy way to tell Access (2000 or 2003) to display the "1/1/1900" that SQL Server 2005 considers a blank date as blank rather than as "1/1/1900"? I know I can create a function like that shown below to do it. ...

Query Performance

Toni - 8 Mar 2007 3:24 PM - 10 messages

I have a vendor application running on SQL 2000 sp4. I've got a query that isn't using any indexes: select hsi.itemdata.itemnum, hsi.itemdata.itemname, hsi.itemdata.batchnum, hsi.itemdata.status, hsi.itemdata.itemtypegroupnum, hsi.itemdata.itemtypenum, hsi.itemdata.itrevnum, hsi.itemdata.itemdate, ...

SQL Veritas backups to tape

Vendage1 - 8 Mar 2007 2:59 PM - 2 messages

I'm currently stuck between the old rock and hard place. I was recently assigned Veritas as former owner left the company. Our main enterprise database has rapidly out grown our hard drive capibilites and the next logical move is to by pass the hard drive all together ...

How do I change the User id and password in SQL SErver 2005/SQL Express?

Learner - 8 Mar 2007 1:59 PM - 2 messages

Hello, I have forgotten the user id and password that I provided while installing the Sql express on my PC. I have two questions now. 1).How do I connect to SQL Express using windows authentication? 2).How do I change the User ID and pass word in my SQL Express / SQL ...

SQL Server 2005 service Pack 2 Error

Jael - 8 Mar 2007 1:31 PM - 3 messages

I am working with SQL Server 2005 trying to apply Service pack 2 (via remote desktop) on a web server which uses Reporting Services. Both the web server and report server are on separate domains. After the service pack 2 tool ...

RE: SQL Service pack version

Jael - 8 Mar 2007 1:28 PM - 2 messages

Try this stored proc in Query Analyzer against the server SELECT SERVERPROPERTY('ProductVersion') ...

Relative Dates

Mark Shields - 8 Mar 2007 12:11 PM - 5 messages

I need to create an SQL Statement that pulls data selected by a datetime field. i want to be able to select dates and times relative to the time that the query is run. Can these date manipulations be done in the SQL statement? ...

count(1) vs count(*). Which one is more efficient in SqlServer2005

zlf - 8 Mar 2007 12:04 PM - 2 messages

Hi all, I am not very familiar with SQLSERVER, I know their have the very same efficiency in Oracle since Oracle will automatically replace * with the most efficient primary key found. I just want to confirm which one is more efficient in SQLSERVER 2005? Thx ...

Problem running DBCC Shrinkfile

musosdev - 8 Mar 2007 10:39 AM - 20 messages

Hi guys I was trying to backup db and truncate the log, here's what I did.. 1) Used sp_addumpdevice danV2_db 2) Backup danV2 to danV2_db 3) Used sp_addumpdevice danV2_log 4) Backup danV2_log to danV2_log Then I tried.. DBCC SHRINKFILE(danV2_log, 5) ...

Windows write permissons and user sa bcp command

Alex_tring - 8 Mar 2007 9:50 AM - 4 messages

There is a shared directory on a server which users have read access to, but not write access to. How would you grant write access to user sa to write files using bcp out on there? Is user sa a particular ...

Auto increment problem

Binoy - 8 Mar 2007 6:48 AM - 6 messages

Hi, I deleted a table which contains 200 rows using delete statement. In that table i have used a identity column. Now i inserted more data in to that table, but i am getting the identity column series from 201.......... ...

Which is the best choice based on STATISTICS results?

VIKING - 8 Mar 2007 2:03 AM - 2 messages

Hi, I am trying to tune a query on SQL Server 2005 (SP1), and I was taking note of results of STATISTICS IO and STATISTICS TIME. Here are the results with various combinations on the query. a) WITHOUT INDEX AND WITHOUT LOOP JOIN HINT: ...

Problem with updating column in table - transaction log full

Ragnar Midtskogen - 8 Mar 2007 1:54 AM - 4 messages

Hello, I had trouble performing an update of one column of a table. The column is of Bit data type and the table has 60350 rows. When I run the following query in the Query Analyzer: update [Specimen CV] set HPV = 0 ...

How do I know I have notification services (DST)

tractng - 8 Mar 2007 12:10 AM - 2 messages

Hello, How can I verify this? We have SQL 2000 (version 8) with sp4. I am referring to the daylight saving time. Thanks ahead. Tony ...

Convert varchar to 12 hour time format

vtestaccount - 8 Mar 2007 12:06 AM - 2 messages

A column stores the time as varchar 24 hour format. Is there a way to change the data using the convert function to 12 hour format from the sql select statement? Thanks. ...

Strange result from running a stored procedure

KTN - 7 Mar 2007 11:55 PM - 2 messages

I have a stored procedure that returns different results even though the input values are the same. The stored procedure is using a table variable. For troubleshooting the issue, I added a select statement of the table variable, and it returned an empty result. If I copy the stored procedure to ...

SQL 6.5: How to retrieve dump file information

Rob - 7 Mar 2007 11:53 PM - 3 messages

I know, I know... It's a SQL 6.5 question, but here's the issue we're facing. One of our server blew up and we have no DRP for this server other than its tape backup. So, we've been able to rebuild another server and have installed SQL 6.5 on ...

Can't start SQL Server Agent

Ragnar Midtskogen - 7 Mar 2007 10:59 PM - 3 messages

Hello, When I try to start SQL Server Agent I get a message "An error 1049 - (The service did not start due to a logon failure) while performing this service operation on the SQLServerAgent service." I am logged on to the machine as Administrator and SQL Server has a login ...

Same query, different results in QA or EM

Mike Volo - 7 Mar 2007 10:25 PM - 2 messages

Problem : When running the same query in Enterprise Manager or Query Analayzer we get different results Query : SELECT DISTINCT LEFT(CONVERT(varchar(5000), Raw_data_text.raw_data), ...

Attaching SQL Database in 2005 from CD-ROM

srini - 7 Mar 2007 8:04 PM - 6 messages

Hi: I am trying to attach a database on a CD-ROM using the following command exec sp_attach_db dbname='dbname', filename1='d:\dbname.mdf', filename2='d:\dbname.ldf' and I am getting the following error Msg 3415, Level 16, State 1, Line 1 ...

Query security logins

HDI - 7 Mar 2007 7:59 PM - 3 messages

Hi, Does anyone know how I can query all security logins, so I have a list? Thx ...

Steps for jobs

tolcis - 7 Mar 2007 7:40 PM - 4 messages

Hi! I have a SQL Job with 24 independent steps. I would like to send out a notification if any of the steps failed but the job should continue from the next step. Our SQL Mail is not setup. The only way I know how to do it is to ...

0x80040E14 Error

nabimomo - 7 Mar 2007 7:29 PM - 5 messages

I am receiving the following error. Line 64 is objCommand.Execute. I tried to look up this info on the Internet but no luck. Any help would be greatly appreciated. Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]RAISERROR could not locate ...

automating table creation

qin_23 - 7 Mar 2007 7:20 PM - 2 messages

hi there. moving from IBM DB2 to MS SQL server. i dont need to take the actual data from the old db to the new one, but i would like to take the table structure. in DB2, i could run through a ddl file that contained CREATE ...

Why would backup file size double overnight?

stephendkay - 7 Mar 2007 6:58 PM - 3 messages

SQL 2005 cluster, one database, full backup to disk every night. .BAK file size had been in the 10 GB range, until one night when I intentionally failed the cluster over and back (installing security updates). Ever since then, the size of the .BAK file has doubled in ...

SQL 2005: All views encypted in a database???

Erik G - 7 Mar 2007 6:54 PM - 4 messages

I have a user who is dbo of a database and their all of the view objects (VIEWS) in MSSQL Management Studio in a database have lock icons and the encrypted property set to TRUE. I go in there on my ...

2nd REPOST (HELP!): Blocking access to system sprocs

K. Abit - 7 Mar 2007 6:40 PM - 5 messages

I have posted two other times and Kalen Delaney and David Browne were kind enough to respond. I thank them. Nonetheless, I am still without a solution and need help. My first subject probably wasn't good enough and ...

Index Lookups

cbrichards via SQLMonster.com - 7 Mar 2007 6:21 PM - 6 messages

I have queried sys.dm_db_index_usage_stats and found an index that has a high number of IndexLookups vs. IndexSeeks. This index is on a table that is refernced in over 1200 stored procedures. The index is comprised of a single column. ...

How to block a table

Iter - 7 Mar 2007 5:34 PM - 3 messages

Hi Guys, I want to build a test environment that I want to block the table sothat other application cannot access this table. Is there a way to block the table? Thanks ...

Trying to Do a transfer of data from mssql - postgresql, but get EXCEPTION_ACCESS_VIOLATION

Advo - 7 Mar 2007 4:51 PM - 2 messages

Hi there. Im trying to do a data transfer via enterprise manager for a database on our windows 2000 server. I try this, but I get the error EXCEPTION_ACCESS_VIOLATION ive done some research into that error, and the advice was to upgrade ...

MSDE2000 with DTS Batch file

BroncosBuck99@gmail.com - 7 Mar 2007 2:59 PM - 2 messages

I am using a MSDE2000 database as a pass through point from a AS400 to a Web Server. I am running the DTS thorugh SQL Server agent. I have added a series of steps to the job, that run a series of DOS Batch ...

Progress from DBCC SHRINKFILE

Matze - 7 Mar 2007 1:59 PM - 4 messages

Hello, how can I see the progress of DBCC SHRINKFILE? ...

Comparing table structure

Gaspar - 7 Mar 2007 12:55 PM - 2 messages

Is there any tool to compare table structures between two databases? For example: When comparing Table_A and Table_B, which fields are missing, which relations are missing, etc. Thanks, Gaspar ...

Cluster service error

get2rajesh - 7 Mar 2007 11:43 AM - 4 messages

I had a Windows Server 2003 (Enterprise ed) cluster with 2 nodes running. When I try to start the service through Cluster Administrator, which is installed on the local machine, I get "Error 1060: The specified service does not exist as an installed service" ...

DependOnService does not work as expected

developari - 7 Mar 2007 11:23 AM - 4 messages

I have several services that retrieve their initialization configuration from a database hosted on a SQL server express. All the services have the SQL server defined in their DependOnService value in the registry and should therefore not be launched until the SQL server ...

Bulk insert, commit and simple recovery mode

Ronen Shachar - 7 Mar 2007 11:02 AM - 2 messages

Hello, I have a theoretical question: If my database is in simple recover mode, and a bulk insert is performed. As far as I know in simple recovery mode bulk data is not logged. My question is - after I commit the transaction, is the data written to the disk? Or there ...

What steps does SQL Server take to bring a DB online

Andreas B - 7 Mar 2007 10:42 AM - 3 messages

Hi, is there any documentation what steps are performed when sql server starts up a database? I would especially like to know what kind of checks are performed at startup (e.g. I would expect an integrity check of the DB, before taking it online) ...

Oracle connection from a SQL2005 Ent. Edt. X64 cluster

Steen_Schlüter_Persson_(DK) - 7 Mar 2007 9:22 AM - 5 messages

Hi Does anybody know if there is a problem/issue with retrieving data from Oracle on a SQL2005 Cluster? My problem is that I don't seems to have the MSDAORA provider like I have on my other servers. I don't recall having ever seen this not being present in a SQL ...

BEFORE Triggers

Daniel Jameson - 7 Mar 2007 1:31 AM - 4 messages

Hey, Why doesn't SQL Server support BEFORE triggers? ...

Microsoft SQL Server 2005 SP2 Issue

Ed Lehman [MSFT] - 7 Mar 2007 1:10 AM - 2 messages

An issue was recently discovered with SQL Server 2005 SP2 which might impact customers using cleanup tasks in Maintenance Plans and SQL Server Integration Services packages. The issue is described in detail at [link] We have created a General ...

Importing data from excel spread sheet to SQL 2005

Kim_Quest - 7 Mar 2007 12:47 AM - 4 messages

I'm attempting to import data from an Excel spread sheet into an SQL 2005 this is what I try Select * Into SQLServerTable From OPENROWSET(â€˜Micorsoft.jet.OLEDB.4.0â€™,â€™Excel 5.0, Database = C:\example.xls;HDR = YESâ€™,â€™Select * From [example]) ...

block a user from executing system stored procs?

K. Abit - 6 Mar 2007 11:40 PM - 7 messages

How do you block a user from executing system stored procs? Seems a user is granted access to execute them even when they are not part of any schema or role. The user security page says "default schema > dbo" and owned schemas ...

Consistency of row when reading with READ UNCOMMITTED

Eli Tucker - 6 Mar 2007 11:37 PM - 2 messages

Hello. I have a question about the internal consistency of a single row during an update statement when another connection is reading the data with a READ UNCOMMITTED (also known as WITH(NOLOCK) ) isolation level. Let me give a small example to illustrate my question. ...

About how to crash the database

Iter - 6 Mar 2007 9:38 PM - 4 messages

Hi Guy, I am testing an application and want to crash the database. Is there a way to crash the database when database is runing? Thanks. ...

SQL Current Activity locks up

Bill - 6 Mar 2007 9:34 PM - 7 messages

Hello, I see this once and a while when SQL Management locks up in Enterprise Manager and I cannot open Current Activity. I was running a third party datababase maintenance program that locked up. Now I can't open anything in ...

SQL SERVER 2000 BACKUP

SJ - 6 Mar 2007 7:51 PM - 7 messages

I am trying to backup a database thro' enterprise manager and the msg I am getting is 'SQL Server Agent on target server (local) is stopped. Make sure it is running during the scheduled execution of this job.' I tried logging into Query Analyzer and I am able to - so the server is up ...

DST and Notification Services

RogBaker - 6 Mar 2007 7:41 PM - 3 messages

I need some clarification on Daylight Saving Time changes for SQL Server 2005. I read MicroSoft Article 931815. Per the doc, I have determined that I have Notification Services installed (determined via registry). However, I do not seem to have any Notification Services to stop (step ...

How to restore SQL 2000 msdb to another server? I get this error

Paul Oren - 6 Mar 2007 7:34 PM - 4 messages

Restore- SQLRES V-79-57344-33938 - An error occurred on a query to database msdb. V-79-57344-33938 - The backup of the system database on device msdb_00__60f69b04_bfad_4b17_a284_4047d59b9e28_ cannot be restored because it was created by a different version of the server (134218407) than this server ...

Help! Suspect Databases - Hardware Failure

cbrichards via SQLMonster.com - 6 Mar 2007 7:34 PM - 5 messages

We have numerous suspect databases across multiple serverse due to a hardware failure on our SAN. The part of the SAN that failed had a combination of data and log files, but not both for a given database. Right now we have services shut down on the server. When we bring the server ...

SQL Server 2005 periodic performance degradation

gidaspov - 6 Mar 2007 6:41 PM - 6 messages

Hi, We are using SQL Server 2005 (SP1) and it behaves very strange for one of our databases. The database is relatively small (up to 1.5 millions of records in main tables) and is primarily used for querying (updated once per day; ...

Copy Database from SQL 2000 to SQL 2005

David Lozzi - 6 Mar 2007 6:21 PM - 3 messages

Howdy, I'm trying to use the Copy Database wizard in SQL Server Management Studio to copy a database from a SQL 2000 Server to my local SQL 2005 Express. After running the wizard it errors out with the following. I can connect to ...

Security hole with db_executor in 2005 - workaround?

K. Abit - 6 Mar 2007 5:37 PM - 9 messages

Giving users access to only stored procedure execute permissions is a common issue. It is a good security practice. In 2005, we can grant excecute permissions at the database level instead of having to do it on each and ...

Memory - Windows 2k3 Ent Ed, SQL 2k Ent Ed Version 2040

Ranga - 6 Mar 2007 4:51 PM - 2 messages

This is my environment: Memory - Windows 2k3 Ent Ed, SQL 2k Ent Ed Version 2040 Have a total of 8 GB of memory. Should I do the following ? 1. /3GB 2. /PAE 3. Enable AWE in SQL Server Thanks, Ranga ...

sql server and dst

mmark751969 - 6 Mar 2007 4:36 PM - 3 messages

just wondering if we need to patch anything on sql server 2000 and 2005(beyond the w2k3 server KB931836 patch) for dst, if we are not running notification services(which we are not). I haven't found anything else with sql server that needs patching(apart from the apps ...

how can I tell if a checkpoint is happening

PamelaFoxcroft - 6 Mar 2007 4:35 PM - 4 messages

Our SQL Server runs fine and then performance will suddenly decline for extended periods of time. I suspect a checkpoint is occuring. Can anyone tell me how I can tell if a checkpoint is occuring? TIA Pam ...

Backup and Restore Events Report

robin9876 - 6 Mar 2007 4:17 PM - 3 messages

In SQL 2005 Management Studio (SP1) at the DB level their is a SSRS Backup and Restore Events Report which does not show any infromation for the database even though the database has been backed up and is showing on the DB properties page. Is their any settings that need to ...

tempdb + DBCC SHRINKFILE

Matze - 6 Mar 2007 3:19 PM - 11 messages

Hello there, I use the command DBCC SHRINKFILE (N'Data' , 500000) to shrink a database file. Now the tempdb grows. Is that correct? How much will the tempdb grow? The file to shrink is ca. 800GB. I've already read the documentation about the tempdb, but I've nothing found ...

Restore master database with SQL 2005 made an error with me

Bishoy - 6 Mar 2007 3:11 PM - 4 messages

- First I made a full backup of master database - Then I stopped SQL Server Service - in cmd: cd C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn then sqlservr.exe -m - I entered that single user mode ---> Problem here: ...

Rebuild clustered index and change filegroup

Ranga - 6 Mar 2007 2:52 PM - 2 messages

How can I rebuild my clustered index and change its filegroup, but don't want to use the drop existing clause, which will drop and recreate all my non-clustered indexes of that table ? Thanks, Ranga ...

xpsmtp for sql server 2005

Jesus Suarez - 6 Mar 2007 2:36 PM - 8 messages

how can i use a xpsmtp in sql server 2005? ...

New SQL2005 SP2

Chris Wood - 6 Mar 2007 2:31 PM - 2 messages

Hi, Bink is saying there is a new version of SP2 [link] The download site now shows version 9.00.3042.01 dated 3/5/2007. It sounds like this version fixes the fact that maintenance plan cleanup tasks now ...

question with sql 2005 named instance port assignment

Derek - 6 Mar 2007 2:26 PM - 3 messages

hi i have a sql 2000 default instance and i just installed a sql 2005 named instance. now i want to assign a specific port to my sql 2005 instance i am trying to figure out the IPAll section of the TCP/IP Properties -- ...

need work around for if/then parsing problem

Trouble Calculating a "score" when the value is Negative

how must i design table(s)

Insert using a case condition

Can't get mirroring working for all DBs?

generated insert statement

SQL 2005 DataType Change

Data recovery service!

Tracking the source of inserts to a table

Temp DB Tables

Date SQL Server job is disabled.

Why use SQL Server 2005 and not Oracle 10g?

Dropping Unused, Duplicate Index

Trace script problem

SQL2k SP4 frozen

Data between 2 dates issue

Bii.exe V1.0-1 Utility for SQL Server 2000

restoring from transaction log backups

SQL 2000 clustered server error Communication link failure

unsigned int data type?

SQL: product without suppressing?

creating a full text index on sql2k

Viewing events as they happen?

Stored Procedure Output

data encryption in SQL Server 2005 - protect from SQL Admnis

XML Data Type

ms-sql 2000 configuration

Row Level Security

Question about selling license

Upsized primary key fields and "aaaaa"

Symantec Backup Exec Database Query Failure: Logical file is not part of database?

2q - Indexs and Optimize...

Select query question

SQL Server Agent Job step Output

How to change upsized primary key index from non-clustered to clustered

"Open table" doesn't show all records (sql server 2005).

Timestamp use? access to sql 2005 upsizing

Timestamp use? access to sql 2005