Hi All, I got some hints on estimating the table size from BOL. But how do I estimate other objects like SP, UDF etc. I want to estimate the disk size required at my deployment SQL Server box. Is there any tool available to estimate the DB size? Thanks in advance, Hari...more >>

We run SQL backup jobs everyday to backup the DB. Our server crashed, so we're trying to restore the database using the backup file (*.bak) However, we noticed that we're unable to restore the DB because the backup file is corrupted. Does anyone have any suggestion how we can restore the DB? I'm...more >>

When clicking on databases in SQL2000 Enterprise Mgr, is there any way to make Taskpad the default view? Even after closing Enterprise Mgr, I would still like Taskpad to be the default view upon reopening and viewing db's....more >>

Hello - if anyone is interested in reading about my SQL Server issues, please feel free to read my posts. http://www.micro-mess.com/forum/viewforum.php?f=35 ...more >>

If i set up my SQL to use Windows Authentication only, does 'sa' become totally useless 'cos obviously one cannot log on with sa in that mode ? ...more >>

I've applied "Hotfix 8.00.0859", which I downloaded from the Microsoft site, and now I get the "Invalid cursor state" error described here http://support.microsoft.com/?kbid=831997 The article says there is another hotfix that fixes what the previous hotfix screwed up, and one should contact "...more >>

The following link mentions the steps of upgrading SQL Server 2000 Evaluation Edition to the retail version. Can I use this method to upgrade the evaluation version to Enterprise Edition in Windows XP Pro? Since Evaluation Edition can be supported by XP, but not Enterprise Edition. http://supp...more >>

Hi How do I change the log shipping monitor to another server without setting up log shipping again? Thanks H ...more >>

omlet@omlet.org wrote in message news:<dc6c1ff0.0406300739.5001ae2a@posting.google.com>... > fitzjarrell@cox.net (David Fitzjarrell) wrote in message news:<9711ade0.0406292055.4bfaa4fe@posting.google.com>... > > omlet@omlet.org wrote in message news:<dc6c1ff0.0406291431.ef3d9f8@posting.google.com>...more >>

How big an SQL database can grow to be? There is any limitation. My database is 4 GB so far (MDF file) every month is growing around 100 MB, what's the limit? Thanks Al...more >>

What we're been doing... We have a scheduled sql backup occur to a specific folder on a seperate hard drive. Then our tape backup software backs up that file. We have never tried to put a backup off the tape an restore it. Is there a better way? Kyle! ...more >>

I've created a customised log shipping process (the servers involved are not Enterprise Edition) that requires that the fail-over database is readonly. Thus the shipped logs are being restored using the standby recovery option. I've just noticed that each restore is adding numerous entries to SQL...more >>

Hi, First of all sorry for my not perfect english. I've got listbox in my .aspx page where the users can make multiple selection. So, Users can select 7 items in listbox, I have to take value from items and pass it to stored procedure to delete 7 rolls in my table. Th...more >>

hi, I am sorting data from all different sources, xml, access, text..etc to my own sql2000 server. (computer name is "testingmachine") atfter I clean up the database, I will give the final database to the client and install in their server (computer name is "SQLS") 1) what's the best way t...more >>

I have a system that came with the MSDE database, because of the 2G limit I am trying to point it to the enterprise version of SQL 2000. All connection strings have been changed to the enterprise (With vendor help). The connection is established and according to a trace from Profiler, all queries ...more >>

Ok, I have read through previous posts but I am trying to figure out exactly what I can do. I am trying to store my transaction logs on another computer. It is UNC, but I have it mapped to the H: drive. Of course SQL is only seeing the local drives. My questions are: 1. Do I have to sche...more >>

Hi all, in query analyzer when using other database than master can't execute following sp_help master..sysdatabases Regards Ajay ...more >>

I am getting the error "Windows cannot load the profile. Please increase the registry size and restart the computer". Can I delete the unused profiles from "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\ProfileList" to make more space available in the registry and maybe o...more >>

We reindexed all of our tables this weekend. We ran the showcontig for all of the tables before the reindex and after and when I was comparing the 2 reports, I noticed that 2 of the tables' (out of about 50) scan indexes actually increased immediately after the reindex. One went from 100% to ...more >>

Hello, Question.. why would the model db transaction log be growing and getting full? No new activity such as adding new databases or user defined data has occurred. Thanks!!...more >>

Is it possible to do an automatic/daily restore of a database to a test box that is being backed up as part of a maintenence plan? Since the backup file contains a timestamp, I'm wondering if the file name is stored in one of the msdb system tables where I can select it into the restore s...more >>

Hi! Is it possible to clone role? Is it possible to retrieve role permissions? Thanks. Dmitry ...more >>

hello, I try to add exchange server as linked server in mssql on SBS2003. I use sp_addlinkedserver : EXEC sp_addlinkedserver 'exchange', 'Exchange OLE DB provider', 'exoledb.DataSource.1', 'file:\\.\backofficestorage\localhost\public folders Now when trying to run a query or listing table...more >>

How Can I Know What is the licensing mode that was installed for SQLSERVER. If the sqlserver was installed per processor Licensing for example, mi contract must be match with this installation type or isn't necessary? ...more >>

Hi all. I'm confused by the deadlock trace posted at the end of this post. If anyone knows where a more complete listing of the information in trace flag 1204 output exists, please let me know - BOL doesn't appear to tell all in this case (maybe my BOL is out of date). My "SELECT @@version" ...more >>

I picked up the disk writes/sec for a particular physical disk and noticed it shoot to 2800 at times.. What does that mean ? There are 2800 writes to that array that may comprise of 6 disks or so.....more >>

Whats the best perfmon counter to use to check how many bytes are being read and written to disk/sec ? I know most of the read and writes take place within a virtual buffer cache, but what triggers a read/write from disk .. I am currently running SQL 2000 if that helps...more >>

I am experiencing problems with multiple 'phantom' sessions connecting to the master data base. These sessions come in as SQLDMO_1 SQLDMO_2 SQLDMO_3 and so on.. we don't believe this is related to any user activity has anyone seen this before? ...more >>

Hi, Anybody knews how to convert existing ASCII data in SQL 2000 table to Unicode thru import/export process and need not change SQL statements (add N prefix to string) in application. For exm, need not use unicode convertion for following SQL statements. --------------------------------...more >>

I run a FULL backup each morning at 12:00am, Steps are, check db, backup, zip backup and remove, shrink log file. Along with the FULL backup I run Transaction log backups from 7:00am to 11:59pm once an hour. Append the file. The file has grown to over 33gigs by 11:59pm. At 12:30am I zip the file...more >>

Hello, Is it possible to migrate a MSSQL server from one machine to another using some sort of differential utility? Assumptions of a possible scenario: Two machines(Old and New) both with a MSSQL installation in the same location: D:\MSSQL 10 GB of databases that need minimal down time for ...more >>

I need to create a query that returns the number of boxes required per = customer order. The following is an example of what I am trying to = achieve Order No Line No Box Capacity 1 1 .75 1 2 .75 1 3 .35 ...more >>

I have a Win2000 SQL server (SQL7) that has some services either stopping or starting. In fact you cannot manually start or stop ANY services, also you cannot run any installers or un-install programs from add/remove. Does anyone have any ideas as to what could be the cause, additionally...more >>

Hi All, My SQL server's data files all corrupted during a severe power failure, we manage to get back the data files and reinstall the sql server. but unforunately we failed to attaching the database back to the server. The error message indicating it is caused by corrupted MDF or LDF files. ...more >>

Hi All, I get this strange error lately . Did one of you allready got this problem ? I/O error 121(The semaphore timeout period has expired.) detected during read at offset 0x000000c9700000 in file 'c:\sql\base.mdf'.. -- Alexis Comte alexis.comte@capit.net http://www.capit.net ...more >>

Hi all! I take backup of a database every night using "BACKUP DATABASE [Db1] TO DISK = N'\\server\e$\Backup\Databases\Db1\Db1.bak' WITH INIT , NOUNLOAD , NAME = N'Db1 backup', NOSKIP , STATS = 10, NOFORMAT" But some nights a have recived the following error message when I view the j...more >>

I have Windows 2000 Advanced Server with SQL Server 2000 Enterprise with SP3A. I trying to set up a job to import Performance Monitors daily into SQL Server table. How would I set up Performance Monitor to stop at 7AM close the present file, create a new file at 7:01AM start collecting...more >>

Does the datatype nvarchar affect query performance in a negative way as opposed to simply using varchar?...more >>

Hi All I work in a envoriment where i restore lots of master database for specfic reason. The problem i am currently encountering is the following When i attempt to restore the Master database is SQL Enterprise Manager (in single user mode) i get a error box with a title of sql-dmo ...more >>

Dear All, I am trying to migrate SQL6.5 to SQL2000 with Chinese data in the database. I found that those chinese data are become wired after migration. Do you have any idea? Thanks. ...more >>

I want to find the size of the physical disks on a SQL server. I have tried using xp_cmdshell but i cannot find a command that will return the disk size. The closest that i have come is forating the results of chkdsk but this takes time to run. Can anyone offer any other suggestions. Ist t...more >>

Hi How do I change the log shipping monitor to another server without setting up log shipping again? Thanks H...more >>

Anyone know how to install SQL Server Personal Edition from Enterprise Edition CD?? I can't find the installation option.But someone tols me that it is available in the Enterprise Edition CD. ...more >>

Hi I have a database with a whole lot of secondary data files (*.ndf's). What do I run to merge all of those into the Primary data file (*.mdf)? Thanks H...more >>

Hi, I've been recommended a server spec by an application vendor. I plan to buy and start using this app, and it runs on SQL Server. The server spec is for a single processor model. There will be a core of about 25 users on the system with a maximum of 40. How can I decide if I should buy a d...more >>

Anyone tried the evaluation edition of SQL Server 2000? Website mentions it can be used for 120 days. Can I continue using it after the evaluation period?...more >>

I have a unix system with an informix data, How many options there are to link this informix data with MS SQL? Is there a "best way"?...more >>

Can anyone suggest what types of hardware I should be using to backup my SQL database. I currently do a differential each night to a file share, which works well, and there is no concern for network usage. I wonder if using a tape or perhaps DVD is a better method. Is a differential backup to DVD ev...more >>

I am getting this error: Internal I/O request 0x05097428: Op: Write, pBuffer: 0x07400000, Size: 851968, Position: 4294580736, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFFA1A00, OffsetHigh: 0x0, m_buf: 0x07400000, m_len: 851968, m_actualBytes: 0, m_errcode: 112, BackupFile: i:\backups\wa...more >>

There is an application running SQL Server 2000. The software vendor suggests upgrading the application to a later version at the end of this year (May be Novemeber). Is it a good idea to postpone the upgrade until MS releases SQL Server 2005 ? Thanks...more >>