Greetings. I want to create a tree control which will list all the employees in an employee table in the correct hierarchy like <company> managers sub managers employees For that, how can I setup reflective linking (linking ot the same table) in ...more >>

Is it possible to use active directory to maintain the login activities of SQL Server 2K? Thanks, Jessy ...more >>

I am trying to improve performance on my sql server by moving the log files to a different drive than my mdf files. I have done this sucessfuly with my user databases, but wanted some reassurance before trying the system databases (i.e. Master, Model, MSDB and TempDB). I have done this with a ...more >>

Hello, I heard if I define a field nvarchar(255), SQL Server optimize this and reserve only the amount of the characters entered. If that is true, do you see any problem if I set nvarchar(255) for all my text fields in the database to avoid any future problems regarding requiring more charact...more >>

I had a backup scheduled for a a time when people are using the website. I got this error... 59System.Data.SqlClient.SqlException: General network error. Check your network documentation Shouldn't you be able to backup while people are using the database ? It is about 4.5 Gigs in size --...more >>

Hi friends! I have installed SQLH2 reporting and collector services and all of them work fine. I configured IIS WIth Reporting services with SP2 and uploaded the reports pages, the connection to the database seems to be well, but when i try to see some data (not happens with all reports) a...more >>

Hi I have a quick question about renaming an instance. I used sp_dropserver and dropped the instance name I used sp_addserver '<servername>, 'local' and changed the local instance name. After stopping and restarting the instance, i was able to connect to the new instance name. But i...more >>

Hi, What the best and fast way to check if a table has rows? Thanks...more >>

I have a question. A bit new to SQL Server, but how does one determine the row size of a given table. Here is my issue: I am a CRM user and I understand that CRM uses SQL Server for its database. When using SQL Server on its own, it will only allow ~8k of DATA to enter the database and wi...more >>

Hello. I'm having problems moving a database from SQL 7 to SQL 2000. The way I did it was copy the .mdf and .ldf files over to SQL 2000. Both SQL servers are using different computer names. But I'm missing some views, stored procedures, jobs, and user accounts. I'm assuming this must be the wr...more >>

I have a couple performance counters logging data to a sql 2000 database. The date column has a data type of varchar and I am not able to perform any date functions against this column in my sql queries. I am trying to use the DATEADD function and the BOL reference states that character data...more >>

Hello: We are on SQL Server 7.00.1063 (SP4) and Windows 2000 5.00.2195 (SP4). I had to reboot our server this AM as SQL Server was not responding. It seems to be fine, now. Afterward, I reviewed the Windows 2000 Server Log in Event Viewer and ran across a couple of things. Could som...more >>

Periodically our server gets into a "state", typically because Access died with a query running. The result is a blocking process, typically on a heavily used table. In theory I should just kill that process, but it never works. I click on it to view, hit Kill Process, and... nothing. Do...more >>

I support a server that has over 200 databases on 1 instance. Each database is about 2 megs. Does anyone know how I can automate a script that will increase the size to 500 megs for ALL DBs. I want to run this script during the evening hours. Ishu ...more >>

Hi What is the feature comparison of sql server 2005 full and the express product? If an application is developed on one, will it run on the other? Can we say that express is for clients who have previously gone for ms access? Thanks Regards ...more >>

I know If I store the DTS packages in SQL Server it will be stored in the msdb database. Also all the job scheduling information is stored in the msdb database. Even though I am taking backup of system databases, I would like to know if is there any way I can export all the DTS packages and ...more >>

Hi, All. I am wondering if anyone has seen this error before: dbcc checkdb ("EMIOPER") Server: Msg 2574, Level 16, State 1, Line 1 Object ID 1112703362, index ID 1: Page (1:1688519) is empty. This is not permitted at level 2 of the B-tree. DBCC results for 'EMIOPER'. select object_name(1...more >>

SQL Server 2000 Windows 2000 Server I need to add a new column to a table that will likely have millions of rows at most customer sites. The table currently has one FK and 2 unclustered indexes. The new column is an int column. When I run the script to add the column on our test server ...more >>

Hello, I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have a white paper or instructions on recommended hardware specs and/or server 2003 tweaks? Thanks....more >>

Hi, I'm finalizing a backup strategy for a production SQL Server with several databases. I intend to use the same setup for several new production SQL Servers. Please let me know if there are any "holes" in this plan or if you have any suggestions. I've been advised not to use remote b...more >>

Hi Let's say I've placed my database's transaction log on a separate RAID1 volume on a separate RAID controller. Does it make sense to dedicate the cache on that RAID controller only for writes? Wouldn't that speed up log writes for transactions? -- Many thanks, Oskar ...more >>

Hi , i want to set up a SQL server with 4 hd c:\ --> OS & SQL servedr d:\ Mirror of C:\ e: data files f: txn files is this set up feasible and will it improve performance ? if c:\ is down , i believe D:\ is able to take over immediately the task of connecting to the sql server ? appr...more >>

I have been deleting records over a weekend on our 24/6 OLTP system. (SQL 2K Enterprise, SP3a) Last week I ran scripts that removed over 10million rows from one table, I then ran the DBCC DBREINDEX (with a FILLFACTOR of 100%) command against that table to rebuild all the indexes on that table (1...more >>

Is it possible to change the default collation on SQL2L post install, and if so how? ...more >>

Hello, I have installed IBM AS/400 Client Access on my machine and then added a new ODBC Data Source. I have been working with this ODBC connection on several DTS packages and everything has worked just fine. Right now, I need to access some information on my AS/400 server from severa...more >>

One of our Dbs, 18GB in size, has a weekly optimization scheduled via a maintenance plan. On those nights, we also seem to get huge transaction log file build-ups, almost equal in size to the whole DB. Could the optimization cause this? None of our regularly scheduled jobs seem to do this d...more >>

I need to re-install a server to have it use the same default collation as a previous server. I need to pick SQL_Latin1_General_CP1_CI_AS. However, in the "Collation Settings" step of the SQL Server installation, I only have a choice of Binary Order, Dictionary order, etc... How do I pick t...more >>

Hi I have an ms access background. After hearing all the good stuff about vb2005/sql2005 I am aiming to switch over. My problem is that I am not very familiar with features of sql server that are not found in access such as triggers, stored procedures etc and am not sure when these should be u...more >>

Hi I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my hand. The SQL Server is configured for dynamic memory allocation. The machine had 2GB of RAM in it when I installed the SQL Server. Now I've installed two more gigabytes of RAM into the machine and I want to allo...more >>

Hi, I've had this same issue on two machines, one Win2k3 Server and a XP SP1 machine. The problem is that after installing SP3 opening any SQL Gui tool (I think it's only that as osql.exe don't cause this) including the SQL Service Manager causes CSRSS.EXE to spike at 100% and basically...more >>

Hi I wanted to send an email through sql server 2000.Before sending i need to configure a profilename in Sqlmail from enterprise mananger. And i took profile name from controlpanel>mail While entering MAPI profile name and click on test button i get the below error xp_test_mapi_prof...more >>

Hi, I have the script below and it is working find if I tried to restore the backup on one database only i.e. MYDB1 but if I execute the script below and change MYDB1 to MYDB2 I got the error below. It seems that it is still trying to restore to MYDB1. Any idea why? Msg 3101, Level 16, Stat...more >>

I need help with stored procedure, where do I post my question? The question is related to syntax and how to so it is not really fit in this topic. Thanks -- Message posted via http://www.sqlmonster.com...more >>

Hi! Does anybody know how SQL server behaves when below event is logged? Will it stop or only part of its functionality will become unavailable? Error: 9002, Severity: 17, State: 6 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log ...more >>

Hi all, I need a UDF that converts numbers to letters (ex: 22 -> twenty two). any help is very appreciated. Regards jouj ...more >>

Hi gurus I try to detached a database but the detach entry is gray out thus I cannot detach the database. I am logged in as sa , mssql2000 . Right click on the database -> All tasks -> Detach database ( Gray out )..... Any idea what is wrong? Why is it gray out?...more >>

Hi, I have a sql server database (1 table, 500.000 records with 10 fields and full text search index) and an ASP.NET website (IIS). What is a good harware configuration ? A P4 3.2 Ghz and 1 Go RAM is enough for sql server and IIS or do i need to have sql server running on is own server ? Or 2...more >>

Does anyone know how to track the actual execution plan the server uses? I have one query designed for a frequently run report that normally takes about 3 seconds to return. However, the Profiler logs show me that in certain cases, it took more than 3 minutes to return and it cost a huge amoun...more >>

Hi, I have Sql Server 200 Entreprise (FR) running under win XP (FR) sp2. I had never install previous sql service pack. I have tried to install sp4 using SQL2000-KB884525-SP4-x86-FRN.EXE and SQL2000.AS-KB884525-SP4-x86-FRN.EXE. After I reboot and still show the older version when I'm runnin...more >>

Good afternoon, I have to inquire about if it's feasible to restore a SQL Server v.6.5 database just from a SQL 6.5 .dat file. The company was doing operation system file backups of the directories but they never made any SQL Server backups or dump files(.bak files) and lost everything. ...more >>

http://www.eweek.com/article2/0,1759,1820667,00.asp The database market grew by 10.3 percent in 2004, fueled largely by hunger for business intelligence and analytics, according to numbers released by the Gartner Group on Monday. With 34.1 percent of the overall market, IBM holds a slim ...more >>

Can I get a list of all files a database comprise of and whether the autogrowth option for the file is turned on or off Output should be DbName FileName Autogrowth_on_off ABC c:\abc.mdf on ABC d:\abc1.ndf off ABC d:\abc2....more >>

Hello MS-Support, Please help with the following problem: I want to change the service account under which sqlserver runs to another local user with less privileges. My problem is that the following error raises in Enterprise manager: Error 22042: xp_setsqlsecurity() raises error -21470...more >>

Hi, I want to write a BCP format file, which uses one data column Value to map to Two Column Fields in the table. For Example: Data File: Pin Value – “5600055” Table Columns 1) tmp_pin 2) per_pin Is the above possible to specify in the format file? Does this flexibility...more >>

Hi, If I have 16GB RAM on my 4 CPU box for my SQL Server, do I still need pagefile? Thanks! John ...more >>

Hi @ll Currently we use an OLE DB Provider for our LINKED SERVER to a couple of Oracle SERVER During big problems with the Provider and a lot of testing we looking for a way to change the LINKED Server to an ODBC Connection! Is there any way to do this?? For any kind of informat...more >>

Hello, I must save up to 20GB of Image and Pdf's in a sqlserver db. Is it better to hold the table with these BLOB's in a seperate DB or in the same db where all the other tables are present (100 tables)? Are there a performance problem if the BLOB table ist in the same as the other data?...more >>

Dear All, After I changed the logic of several stored procedures, my application receives time out errors. I used system monitor to analyse it and here the result: SQLServer:AccessMethod: Full scan/sec : 0.000 Index Searches/sec : 5782.898 SQLServer:CacheManager Adhoc sql p...more >>

Dear All My SQL Server is contains 2 databases. Both of them are used by different client/server application and each application uses several stored procedure to query and update its database. The problem is my users reports that those two application respond slowly. I used SQL Profile, a...more >>

Dear All, I have 2 SQL Server 2000 computers. Each server contains data for one of regional divisions. Company employees currently use a single data entry application on client computers. After the new application is installed, query response times slow. My IT Manager ask me to monitor ser...more >>