SQL Newsgroups: Microsoft SQL Server Administration

Can I do this ?

Hassan - 9 Dec 2006 7:24 PM - 3 messages

So I have a Full DB Backup taken at 7am a Diff backup taken at 9am a Diff backup taken at 11am Can I do this ? Restore Full DB Backup of 7am with noreceovery followed by Restore Diff Backup of 9am with noreceovery followed by ...

Who is starting SQLSERVR.EXE?

Chris Shearer Cooper - 9 Dec 2006 5:13 PM - 3 messages

I see that I have an instance of SQLSERVR.EXE in my task manager, and I certainly didn't start it, and can't think of any applications or services that use it. How can I find out who started it? Is there a way to connect to SQL server, ...

Date field in exported excel file

JIM.H. - 9 Dec 2006 3:56 PM - 7 messages

I export a table to excel file by using DTS. It seems the date field show as ###### when I open the excel file. If I expend the column I see the date. Is there any way I export in away that this date field will not show up as #####. ...

Trace to Table

Haki - 9 Dec 2006 8:39 AM - 3 messages

On SQL 7.0 we can use xp_trace_setqueuedestination and we can choice destination table but in SQL 2000 we can't use xp_trace_setqueuedestination. If I run trace from SQL Profiler I could write to table but when I want to ...

Checking a database for physical damage

craigkenisston - 9 Dec 2006 7:09 AM - 4 messages

Hi, Today I had one disk of my server array crashed, it is on raid 5 with hot spare disks. SQL Server reported some errors on event logger but apparently the hot spare disks were used correctly since it is working right now. ...

Copy Stored proc from one DB to other

Sheryl - 9 Dec 2006 6:59 AM - 5 messages

Hi All, I want to copy my stored proc from one DB to other. I am wondering how can I do it???????Can I use DTS to do that?I couldn't find option in to do it in DTS??? ...

Why would bad login attempts not get logged with the source IP?

Henrik - 9 Dec 2006 2:36 AM - 2 messages

Why in the world would bad login attempt not get logged with the source IP? I have checked both system event logs (with bad logins turned on) and the SQL Server default trace logs and neither seem to log the source ...

2005 features not working

Paul - 8 Dec 2006 10:55 PM - 20 messages

I have both sql 2000 and sql2005 installed on a machine and with management studio it seems to show the databases created in 2000 but does not seem to have many of the new features of 2005. It seems as though it is not ...

Importing Data into SQL 2005

ME - 8 Dec 2006 8:09 PM - 5 messages

I tried to import a table from SQL 2000 server to SQL 2005 server. Between SQL 2000 servers I can choose to drop the current table if it exists at destination. However in SQL Server Management Studio there is no option to ...

@@version, add database to a named instance?

bangwo - 8 Dec 2006 7:53 PM - 5 messages

Hi, I have a sql 2000 personal editon(default server) and developer edition (named) installed on a machine (windowsXP). 1) if I do 'select @@version' in query, I always get 'personal edition' version information back. How can I get the version nformation of developer ...

"dbcc dbreindex" vs "dbcc reindex"

xamman - 8 Dec 2006 6:43 PM - 4 messages

are these synonyms? many thanks & seasons greetings ...

Execute permission denied on 'sp_xml_preparedocument'

Sharath Shetty - 8 Dec 2006 6:35 PM - 5 messages

Hello, We have hosted our .NET application on a windows 2003 server runing SQL Server 2000. We have a stored procedure that uses "'sp_xml_preparedocument" to pick the XML values sent in a parameter. It is throwing the following error in one of the testing environment, but ...

Delete previous backup in append mode sql 2000

Arejan - 8 Dec 2006 6:10 PM - 4 messages

i have set backup of userdatabases in append mode every day its possible to remove backups of a previous date using a stored procedure ...

multi instances of sql server

bangwo - 8 Dec 2006 4:12 PM - 2 messages

Hi, if I have 3 instances of sql server 2000 on a machine, how to use Enterprise Manager - sql query analyzer to get a list of them all (name, current status, the databases under each of them)? or have to use some other tool to do it? ...

How to get rid of Ghost Pages

Adam - 8 Dec 2006 3:43 PM - 2 messages

For those of you who may not have heard of ghost pages, when SQL Server deletes all the rows in a data page, it doesn't re-use it untill a seperate process cleans up such pages. These pages are called ghost pages. ...

[SQL 2005] XQuery xs:NOTATION

Mike C# - 8 Dec 2006 3:19 PM - 12 messages

I thought I read in BOL that SQL 2K5's XQuery implementation does not support the XML Schema xs:NOTATION datatype; but I'm having a hard time finding that page again. I was able to locate a page in BOL ...

SQL Server Version

J1C - 8 Dec 2006 3:14 PM - 9 messages

What is the latest version of SQL Server 2000 SP4? Was there a hot fix roll up after SP4? ...

Why won't Service Browser bind to my LAN port

mark.howells - 8 Dec 2006 1:45 PM - 2 messages

Hi, I''m really tearing my hair out here with something I've been working on for a couple of days now. ... :( I have a Server 2003 with SQLServer 2005. I need to allow the access to Browser services from on my LAN. (NIC IP 10.0.0.3). Try as I might, I ...

Insert one row for each day

Lauren Quantrell - 8 Dec 2006 1:23 PM - 4 messages

I have tblConcerts ConcertID PK ConcertName varchar(50) ConcertDate datetime I need to write a stored procedure that inserts one row into tblConcerts for a one-day concert or inserts multiple rows into tblConcerts, one row for each day. What I'm thinking is something that looks like the stored procedure ...

in oracle we have a functionality "cursor" ... do we have some replacement of it in sql server

manish1.agarwal@gmail.com - 8 Dec 2006 11:29 AM - 4 messages

in oracle we have a functionality "cursor" ... do we have some replacement of it in sql server Example of oracle "SELECT 'INVOICES' AS EXT_TABLE_NAME, TRANSACTION_CODE, WAYBILL_NUMBER, CURSOR ( SELECT 'INVOICE_LINES' AS EXT_TABLE_NAME, EXT_REC_ID , UNIT_PRICE FROM INVOICE_LINES ) INVOICE_LINE_ITEM$LINE FROM INVOICES" what wud be its replacment in microsoft sql server ...

How to add document type in full - text search (ifiter)

jp - 8 Dec 2006 6:13 AM - 2 messages

Dear all, I use full-text search in SQL2005, but i discover it only support some document types (.doc \ .xls .. , select * from sys.fulltext_document_types ),i want to it also support PDF type, well then, how i can do it? ...

TempLog growth

cbrichards - 8 Dec 2006 3:55 AM - 3 messages

I am running SQL 2000, SP4, on Windows 2003. For the past week the TempDB log file gradually grows throughout the day from about 2 GB to 8 GB, and then at about 5:00 pm it shrinks back down to 2 GB. ...

Defrag local drive in SQL Server 2005

morphius - 8 Dec 2006 1:41 AM - 4 messages

Are there any considerations that must be taken before defragging the local drives in SQL Server 2005? For RAID and non-RAID drives? ...

Poor Performance after upgrading from 2000 to 2005

Ryan - 8 Dec 2006 1:28 AM - 11 messages

I have a problem that I hope someone will be able to provide some insite into, or some tips to help me. We recently upgraded databases on an SQL server 2000 to an SQL 2005 server. The hardware on both machines is exactly the same. ...

Violation of PRIMARY KEY Constraint Error After Restore from a Backup File

Gary Lou - 8 Dec 2006 1:16 AM - 4 messages

Hello, I just restore a database to a new server from a backup file. The front end application works fine, except it gave me the following error when try to do an insert in the application. Violation of PRIMARY KEY constraint 'PK_RES_LOG'. Cannot insert ...

Delete TempDB Database on SQL Server 2000 EE

Joe K. - 8 Dec 2006 12:17 AM - 4 messages

I inherited a SQL Server 2000 Enterprise Edition database server that has system databases that do appear in the SQL Server 2000 Enterprise Manager GUI. How can get the system databases to appear in the SQL Server 2000 Enterprise Manager GUI? When I opened the Query Analyzer the system ...

Restoring deleted records with out of row blobs?

Andrew Meinert - 7 Dec 2006 10:47 PM - 4 messages

I have a database that had a number of rows in multiple tables deleted - fortunately there was very little activity after these deletions (mostly more deletions a few days later). I have the log files, but the original inserts just have the pointer to the ...

Trigger to update field based on criteria

Keeper of the Bits - 7 Dec 2006 9:40 PM - 2 messages

I have a table with contact info for clients and vendors. We have been "asked" to not contact various people in the table. I am trying to setup a trigger to set certain phone, fax, mobile etc fields to null if ...

standard or enterprise or developer edition?

bangwo - 7 Dec 2006 9:18 PM - 3 messages

Hi, we had SQL Server 2000 installed on a machine long ago. Now we don't remember which version it is (it's standard, or enterprise, or developer edition?). Could you help us on this? Thanks ! ...

Asymmetric communication from ms-sql-m protocol from an SQL Cluster

ddnash - 7 Dec 2006 8:49 PM - 3 messages

We are installing an application that requires access to the ms-sql-m protocol (UDP/1434) as well as the data port (TCP/1433). The SQL Server we are using is part of an N+1 cluster. The issue is that when we try ...

Quoted Identifier ON as default

cbrichards via SQLMonster.com - 7 Dec 2006 8:47 PM - 3 messages

Currently my user databases, and model database, all have QUOTED IDENTIFER set to false. I want to help ensure that QUOTED_IDENTIFIER is set to ON under the following conditions: 1. When a stored procedure is created (assuming the connection that is ...

SQL2005 & Small business server2003 R2

Fred Nygaard - 7 Dec 2006 6:58 PM - 5 messages

We are currently running SBS2003 premium. SQL2000 SP4 is running a couple bussiness apps. One of these apps now requires SQL2005, the other does not support it and must be run on SQL2000 Now the question. We have purchased the new SBS2003 R2, is it possible to have SQL2000 ...

Drive space for db and log backups

Gerald Hopkins - 7 Dec 2006 6:09 PM - 9 messages

Hello all, Can anyone tell me what is the ideal free space on a disk to allow for db and log backups on a Full Recovery Model? My db is 4GB, and my log is 2.5GB. How much free space should I keep to safely run regular backups? ...

Table updates from server

omaris - 7 Dec 2006 5:47 PM - 4 messages

Hi all, I am currently designing an analysis services project for my company and have completed about 95% of it. I was recently asked however if the tables are able to get new information from the server where the tables ...

retrieve Datetime

db-x - 7 Dec 2006 5:30 PM - 3 messages

I have a table with a column tradedate of type datetime in which date is stored in the format mm/dd/yyyy hh:mm:sssAM. How do I retrieve this using Java resultset I tried data, time and timestamp but I do not seem to get the exact ...

xp_sendmail permission issued from a job

thejamie - 7 Dec 2006 4:36 PM - 4 messages

Not sure if I have this right. xp_sendmail requires an admin account be present to use the sendmail function (SP4 SQL 2000). This means a job that runs xp_sendmail must have the admin permission or must be owned by the sa. ...

Recover Transaction Log

labsRcool@community.nospan - 7 Dec 2006 4:22 PM - 5 messages

Hi - I'm requesting help to understand a concept: Can you restore a Transaction Log Backup only Transaction Logs backed up AFTER a Full Backup? EXAMPLE: Setup assuming 2 hard drives: * Database MDF files stored on hard drive (A) ...

SQL Time Specific Daily Query

CRS_UK - 7 Dec 2006 3:12 PM - 3 messages

Hello. I need to write a query that is time specific. This query will be run daily and needs to pick up all orders that have an update date between 2:00 AM and 3:00 AM. If it were just for one day, I would know how to ...

Max Degree of Parallelism - clearification

Jaski - 7 Dec 2006 3:04 PM - 9 messages

I am somewhat confused on how this works. I have searched MS and many other forums with no answer. BOL states "Use the max degree of parallelism option to limit the number of processors (a maximum of 32) to use in parallel plan ...

What happens when when a row is inserted into a table with indexes?

Simon Harvey - 7 Dec 2006 2:53 PM - 7 messages

Hi all, I'm hoping someone could offer some insight into the following. I'm quite interested in database performance. I know a fair bit about indexes - their pro's and cons, which type to use and so on. I'm not ...

SQL 2005: Service Pack 2: Timing?

Dr. Network - 7 Dec 2006 2:38 PM - 2 messages

SQL 2005 SP2 is currently in CTP. Has anyone heard clues or hints about when it is expected to be released? We are working on product release timing and trying to factor this in. Thanks, Chuck ...

64 bit SQL 2005 memory problem

thejamie - 7 Dec 2006 12:55 PM - 20 messages

Large Query immediately eats up all available memory in Server 2003 Server XP1 SQL 2005 64 bit (8 gig ram). CPU pegs at 99% and nothing else appears to be able to access SQL Server. Query is attempting to delete possibly as many ...

ado-sql-oledb

Meelis Lilbok - 7 Dec 2006 11:52 AM - 4 messages

Hi Im using VB6,ADO, OLEDB and SQL Server 2000/2005 On any SQL error the error number from Error is -2147221504 How to get the "real" error number to specifiy error For example if "Time Out" happens then error is 10021 or something ...

Info Isa 2006?

Cyber-Guy - 7 Dec 2006 11:37 AM - 2 messages

Greetings, Does anyone know when will Isa 2006 be available for retail and is there any dates set yet for the examination? Thanks in advance ...

SQL ODBC not listing database.

hugostyles - 7 Dec 2006 10:51 AM - 2 messages

A user is setting up a SQL ODBC connection in the system DSN. On the screen where you select your default database "change the default database to...", the user is able to select one database but another database with the same permissions is not shown in the list. ...

Urgent case- Error: 17803, Severity: 20, State: 12 Insufficient me

David Law - 7 Dec 2006 9:53 AM - 6 messages

In this year, we upgraded our SQL Server from SQL Server2000 standard version to SQL Server Entperise 2000, and we applied the SP4 to it. but we now encountered the below problem periodly. Users can't connect to the SQL Server and the SQL Server report " Error: ...

Does SQL Server handles time zone difference?

Lalit - 7 Dec 2006 6:53 AM - 2 messages

Hi Does SQL Server 200 handles time zone? We want to transfer all data to another server periodically that is situated at a different time zone. Also some time we restore complete database to second server. we want to keep correct time stored with the data as per the time zone where ...

Starting up the database XXX (Error ID 17137)

ghostwolf - 7 Dec 2006 4:57 AM - 5 messages

Hi all, I've experienced a problem for accessing the MSDE 2000 by using the store procedure. The problem is, while the store procedure is started to run, there is are Error Log entry in my Profiler "Starting up the database XXX" ...

Compare Databases

morphius - 7 Dec 2006 3:51 AM - 2 messages

I replicated two databases. How do I find out the data from one database is copied over to the other DB? ...

Incorrect LicenseType & NumLicenses returned by SERVERPROPERTY fnc

DBADave - 7 Dec 2006 3:43 AM - 5 messages

I am attempting to poll my inventory of multiple SQL 2000 Servers to detemrine their license model and # of licenses. Each of these SQL 2000 Servers are running either SQL 2k SP3a or SQL 2k SP4 and they are all either ...

MS DTC timeout

00MichaelJordan - 7 Dec 2006 2:59 AM - 3 messages

Is there a way to set up MS DTC timeout? THanks. ...

SQL Server 2000 server time question

Jason Huang - 7 Dec 2006 1:58 AM - 3 messages

Hi, In my SQL Server 2000, how do I know the SQL server's current time ? Thanks for help. Jason ...

grant select to public

klabu - 6 Dec 2006 11:25 PM - 3 messages

I'm NOT the dbo but I am allowed to create table/views/UDF But I can't not do this: grant select on vw_I_created to public got this error: SQL Server Database Error: Grantor does not have GRANT permission. ...

Recover data from corrupt DB

John - 6 Dec 2006 11:25 PM - 3 messages

Hi all: I have MSCRM running in a VPC setup, so since I had 4 backup copies of the VHD files, I never backed up the DBs themselves. Now for some reason all of the images have an error in the MSCRM Metabase database, and I cannot ...

SQL 2005: Querying a table or view

Conan Kelly - 6 Dec 2006 10:52 PM - 2 messages

Hello all, Am I just missing something here? In SQL Server 2000 EM, I could right-click a table or view, point to Open, then select Return all, Return Top..., or Query. In 2005 Management Studio, I right-click the table/view and the only option I get is Open. What if I want to query it? I open it, ...

Need to transform table data to excel 2003 files

Maxwell2006 - 6 Dec 2006 8:46 PM - 5 messages

Hi, Can I use SQL Server Integration Services to generate Excel 2003 spread sheets based on or database data? We already have Excel 2003 templates and we need to generate excel 2003 xls files based on our database table data. What would b the best way to do ...

SQL errors on running stored procedure...

Mrpush - 6 Dec 2006 8:15 PM - 5 messages

Hello, SQL 2000 running in Windows 2003 server enviroment. Run our app from Termainls server to SQL DB back end box. SQL box is Dual 3.0 Ghx, 1GB RAM. Lots of disk space In our app one stored procedure runs a query to get records that match a ...

Transaction log files get smaller

JayKon - 6 Dec 2006 8:05 PM - 8 messages

SQL Server 2000 (8.00.761) (SP3), on Windows Server 2003 (SP1) I am monitoring the physical size of the transaction log files and I see them getting smaller once, or maybe twice a week. I've checked to make sure ...

data export to flat file

jchampion728 - 6 Dec 2006 7:51 PM - 2 messages

Hi, I hope you can help, and thank you. SQL 2000. I need to generate a flat file export from a single table. I need a line feed between select fields. I've tried using bcp and Bulk Insert with ...

parsing sql statement in export wizard time out

myao2005 - 6 Dec 2006 7:46 PM - 3 messages

Hi, I'm using sql server 2005 to export some data into ms access mdb file. However, i kept on getting following error when i try to parse the sql statement: "The statement could not be parsed". Additional information: Deferred prepare could not be completed. ...

Jobs and logins

rgn - 6 Dec 2006 7:37 PM - 3 messages

Hello All, One of our DBAâ€™s left and he had owned some of the Jobs that he had setup. I changed the owner of the Job to sa and deleted his account - "Portfolio\mpaul " (Windows Authenticated) from the SQLServer Logins. This account is also ...

Update Statistics with fullscan blocks myself

Ian Boyd - 6 Dec 2006 6:58 PM - 4 messages

i run UPDATE STATISTICS Transactions WITH FULLSCAN and it reliably blocks myself every time. The locks i have are: WinFundSQL DB S GRANT Sess WinFundSQL.dbo.sysindexes KEY S GRANT Xact sysindexes ...

Unable to deallocate a kept page

morphius - 6 Dec 2006 6:52 PM - 2 messages

We have SPs that create our reports tables. Every 3-5 days we get the "unable to deallocate a kept page" Any insights to this error is highly appreciated.. ...

Need help w/ scripting tables

tootsuite - 6 Dec 2006 6:51 PM - 3 messages

Hi, Every month I am tasked with scripting out all the tables for several databases. Using SQL Server 2005's Mgmt Studio, scripting by hand takes *forever* and is very tedious. I would rather find a way to do this automatically using some kind of ...

What is good and what is bad in the Graphical Exec Plan?

ChrisR - 6 Dec 2006 5:53 PM - 5 messages

Howdy all. I'm looking at the Graphical Exec Plan on a sproc right now and I see that 90% of the resources are going towards a Hash Match/ Right Outer Join. How do I determine if that is good, bad, or indifferent? ...

Third party tool backup not Supported by Microsoft?!!!!

Hate_orphaned_users - 6 Dec 2006 5:40 PM - 8 messages

Hi all :) Here is the story, i'll try to keep it short. I justed started as a DBA at company X. They have SAP running on a clustered SQL2000 database connected to a SAN. The problem is that the SAP backup from SQL server to DISK(BAk file) takes 7 ...

loading status after restore database

Iter - 6 Dec 2006 5:14 PM - 3 messages

Hi Guys, I got a trouble after I restored my database. I forgot disconnecting all connection when I restored my database. I continued to restore my database after I disconnected all connection, then it was successfully restored. But I found the database was marked as loading and database was as unsuspected mode ...

SQL 2005 Encrypted columns

DXC - 6 Dec 2006 4:09 PM - 5 messages

Does any one know what are the column limitations when encrypting data in SQL Server 2005 ? Can primary key, index columns be encrypted ? Thnaks. ...

attaching to msdb db

Roy Goldhammer - 6 Dec 2006 3:50 PM - 3 messages

Hello there On the business i;m working on, I've installed MSDE on my client computer. So far i've worked with SQL sever 2000 now i transfered to sql server 2005. and i tried to attach one of my files. It gave me Error because my DB i;m ...

SQL 2000 and awe memory

paul - 6 Dec 2006 3:38 PM - 6 messages

Hello, anyone here with large memory and AWE experience? We have a server with 32GB RAM, enabled AWE option, and /pae switch in boot.ini. I'm looking for ways to verify if SQL Server is using all that extra RAM (which ...

Max Memory SQL2K EE on W2K3 EE

Paul Ward - 6 Dec 2006 3:35 PM - 7 messages

This is what I have Windows Server 2003 Enterprise Edition (x86) SQL Server 2000 Enterprise Edition (x86) What I'm trying to clarify is if I have a W2K3 EE system with 32GB of RAM can a single instanace of SQL2K EE access the entire 32GB ...

Question on Backup/Restore

DataPro - 6 Dec 2006 3:03 PM - 7 messages

New to SQL Server. is it true, as it seems to be, that SQL Server cannot do a point in time recovery to a point in time that would exceed the time of the last transaction log backup? That is, it cannot use the active log in conjunction with the archived ...

What is the difference between dbo schema and db_owner?

Peter - 6 Dec 2006 9:13 AM - 4 messages

I am new to SQL Server 2005 and according to the installation guide, we have to link a database user to dbo. It suggests us to choose in schema mapping. We would like to know what is the difference between dbo schema and db_owner ...

Exporting Datas to Excel File

retheeshnewage - 6 Dec 2006 8:30 AM - 2 messages

I have a server where I have installed SQL Server.I am running a Visual Basic Software in a Client computer.I want to execute a Sql Query which exports all the datas of a sql server table to that client machine as a ...

Script to peg all CPUs

Hassan - 6 Dec 2006 7:00 AM - 4 messages

I'd like to get a script/application that would peg all the CPUs. I just want to do some load testing, but dont really know how to get my CPUs pegged. Can someone help ? I just want to max them out for like a couple of minutes. ...

How to allow null by SQL

ad - 6 Dec 2006 6:02 AM - 3 messages

I have a field in a table, which is not allow null. How can I set it to allow by SQL? ...

OLE automation

00MichaelJordan - 6 Dec 2006 3:32 AM - 2 messages

How do I start OLE automation in SQL 2005? Thanks. ...

Transaction log backups way bigger than differential backups?

Nasser - 6 Dec 2006 2:48 AM - 4 messages

Hi, Environment is 10gb db, SQL Server 2000 SP4 running on Win 2K3. We backup our database fully every evening, and recently in the hope of log shipping to a remote site, we moved from doing a differential a few times a ...

Moving SQL Server

Tedmond - 6 Dec 2006 1:40 AM - 3 messages

Dear all, I have two questions 1. What is the best way to move a whole SQL server to another machine with different machine name? 2. I tried backup all DB including master from one server then restore all ...

SQL 2005 WORKGROUP Installation Problem Please help!

Newbie - 6 Dec 2006 1:14 AM - 3 messages

I have been trying to upgrade from SQL Express to SQL Server Workgroup Edition 2005. When I try to install the database, this error message pops up. Error 1706. Setup cannot find the required files. check your connection to the network, or CD-RoM drive. For other potential solutions to this problem, ...

Import multiple .DBF files w/SSIS - OLE DB

SQLNewbie - 6 Dec 2006 12:27 AM - 2 messages

Hi all, New to SQL Server - trying to create an SSIS package that will look for and import a series of Visual Foxpro tables (.DBFs) when they appear in a folder. The tables are/can be all different fields, field widths, etc. With ...

NTBackup

Diane Walker - 5 Dec 2006 11:02 PM - 3 messages

We are running SQL 2000, Enterprise Edition on Windows 2003 Standard Edition server. We setup SQL database backup from the Enterprise Manager and we plan to use NTBACKUP utility to backup the entire serve to a tape drive. My ...

Database on SQL Ent Trial buying Standard Edt

Paul - 5 Dec 2006 10:36 PM - 2 messages

We have developed our Database on SQL 2005 Ent. Trial edition. We are buying Standard editon - can we import the DB from Ent. edition into standard edition ? Also any docs on upgrading from the trial edition to Standard edition would ...

Telling if SQL2005 is running

Chris Wood - 5 Dec 2006 9:52 PM - 9 messages

Hi, In SQL2000 I had to change permissions to scmanager to tell if SQL2000 was running on a server after the server was upgraded to W2K3 SP1. This was due to SP1 security changes. Now I have SQL2005 Management Studio and I cannot see the status of any of ...

Does Sql 2005 allow ORDER BY @Variable ?

Dan E - 5 Dec 2006 8:01 PM - 3 messages

I am writing a stored proc and do not want to use dynamic sql. Does Sql 2005 allow ORDER BY @Variable? The query compiler accepts it, but it doesn't work. My @Variable is a VARCHAR(50). ...

error running a vb script on servr 2003

pr0f1t - 5 Dec 2006 6:53 PM - 3 messages

I have a script that I am trying to run locally on one of my 2003 machines. I will be the first to admin that I am not a programmer, and no very little about VB. My issue is that when I run the script I get ...

Windows 2003 SP1

Paul Charleston - 5 Dec 2006 6:28 PM - 2 messages

I am running SQL 2000 on a Windows 2003 server with no service pack. I need to upgrade the server to SP1. On Microsoft document listing compatibilities with Windows 2003 SP1, they mention SQL Server 2000 SP3a is compatible. ...

Error Connecting to Database (SQL Server 2005)!

Mohd Al Junaibi - 5 Dec 2006 5:56 PM - 5 messages

Hello all, I'm encountering an issue with regards to the default REMOTE LOGIN settings to my database instance on SQL Server 2005. The message I am recieving is as follows: "An error has occurred while establishing a connection to the server. ...

Slow hard disk?

nkw - 5 Dec 2006 5:48 PM - 8 messages

I have a dual cpu server, windows 2000, 4G memory, RAID 5 hard disk array The server is very slow, Avg. Disk Bytes/Read 47xxx.xxx Avg. Disk Read Queue Length 78.xxx Avg. Disk sec/Read 1.7xx Disk Read Bytes/sec 2M ...

Managing Large Views on Large Tables

thejamie - 5 Dec 2006 5:09 PM - 5 messages

An indexed view appears to be a solution to managing huge tables, but my efforts for this have missed the mark and there may be better solutions anyhow. In a table of roughly 500 million records, 50 million may belong to ...

Problem creating a Maintenance Plan

robin9876 - 5 Dec 2006 4:32 PM - 4 messages

When trying to create a maintenance plan using the wizard to backup the system databases in SQL 2005 the following error is displayed. How can I find what is causing this problem with a simple maintenance plan? Maintenance Plan Wizard Progress ...

begin transactions

KristinaDBA@gmail.com - 5 Dec 2006 4:00 PM - 14 messages

Hi I am a DBA and am having a dispute with a developer. He insists on coding like this: Begin train 1 insert statment Check for error Commit or rollback. Since SQL Server 2000 an d 2005 has implicit transactions, my standard ...

perf question

SalamElias - 5 Dec 2006 3:58 PM - 5 messages

Is it true that switching to "Simple" mode contribute to increase performance? I undersatnd that in whatever mode the DB is, logging is to transaction is done withe the difference that sql truncates the transaction log when the DB is in "Simple". ...

Can 32 bit webserver work with a 64 bit db server?

Hurme - 5 Dec 2006 3:41 PM - 2 messages

Is it possble for a W2K3 32-bit webserver running IIS6 access a SQL 2005 server running W2K3 64 bit? tia ...

Could not create tempdb - SQL Server 2005 with SP1

Keith Kratochvil - 5 Dec 2006 2:44 PM - 4 messages

I am receiving the following message within the Application Event Log on one of my servers. Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then ...

SQL Server Database Size/Free Space Query

ChrisP - 5 Dec 2006 2:17 PM - 3 messages

I administer 70 separate databases on 3 different servers. Of these 70, 17 are production databases that I must keep the space used to between 80-90 percent of the space allocated. If these databases exceed 90% then I increase the allocated space. ...

What type of replication should i use?

stuckish - 5 Dec 2006 2:08 PM - 6 messages

We need to provide a external company with a copy of our database on a regular basis, probably about once every night. Our database is a SQL Server 2005 Ent edition and we assume the external company will use the ...

Difference between SQL Server Express Utility and SQL Server Server Management Studio Express

J.S. - 5 Dec 2006 1:36 PM - 6 messages

What is the main difference between SQL Server Express Utility and SQL Server Server Management Studio Express? Can they both be used to connect to SQL Server 2005 databases? Which one do you folks prefer? Thanks, J.S. ...

How can i access internal row id of sql server

khaleek_ahmad - 5 Dec 2006 10:58 AM - 2 messages

I want to access nth row from a table in sql server without use of row_number(),rank() and even without top keyword. May any one help me. Please mail me the solution at khaleek_ah***@yahoo.com. ...

Using current time as parameter for a stored procedure

Ib Schrader - 5 Dec 2006 10:24 AM - 8 messages

Hi there I have a stored procedure that calculates no. of calls handled in a helpdesk within a given interval. The stored procedure accepts the paramaters @start and @end which tells it the endpoints of the interval. I'm trying to create a web page that shows the no. of calls handled today up ...

backuping to tape

Schema versioning

AWE Enabled for 4gb but sqlsevr.exe only uses 74,172k

FULL and Tran Backup

Easy way to find size of data returned in SQL 2005 ?

Data Encryption

Transaction log

Application Server to Point to Mirror Server

How to alter the data type of a field

Alter Index issue & Try/Catch question

disable external connections to sql server 2000

include .mdf, .ndf, and .ldf files in exclusion list

SQL2K5 XQuery data types

mirror db blocking issue

How do I add an AS400 system as a Linked server??

Enabling service broker

User access right:

Determine When/Who Deleted Database

Fastest way to delete to huge datarow?

Encrypt sproc still returns NULL's to non DBO's.

User security setting in SQL Server 2000

Reserved words etc.

RAID 5 vs RAID 10 for reads

Restoring Master DB to a clustered server

Error Msg 701(on sql2000)---no insufficient system memory to run q

Grid computing as it applies to SQL Server..

dbcc inputbuffer equivalent in SQL 2005

List DMVs

ProSQL

How to shrink db

Restore execution sequence?

Database corrupted

SET ANSI_NULLS ON/OFF