Hi I want to know the Total Memory(Bytes). As there is no such performance counter available in System performance viewer. The performance counter available are: Available Bytes, Committed Bytes, ..... etc... Do we need to add all of these to get the total memory in bytes? Let me know AS...more >>

Is there a "best practice" for shrinking databases? Daily, Weekly, Monthly? Daily do a normal 25% free and weekly Move pages to the beginning before shrinking? I already have Maintenance Plans to backup logs and the database etc. but wondered about automating the shrink process as well. ...more >>

Hello, I am install sql mail, but one error in my configuration, Error 22022. How install the sql mail service? Its necesarry install exchange or outlook is enough. Thanks ...more >>

Hi all, I'm facing a very strange problem. I have two databases (in particular) that are attached to SQL Server 2005 Express (say, #1 and #2), and I have two queries (among others) that I use to access their data. Now, after rebuilding all indexes in database #1, the query to access that da...more >>

I have been asked to do some research into integrating an application which already runs off a SQL Server, but they would like to add SQL Server to Active Directory. What advantages are there in adding a SQL Server to AD? I know very little about AD so I'm not sure what functionality this adds....more >>

Hi I wanted to run a maintenance plan wizard like I am used to in SQL Server 2000 but I can't find the wizards. Are they available in the express application? And if so where? thanks Jonathan =============== Jonathan Crawford jc@tgsi.net =============== ...more >>

What is teh maximum number of characters you can have in one field? ...more >>

Hi, On one of our servers, whenever there is a system reboot the recovery model option on the MSDB database is reset to 'Simple'. This is causing the Transaction Log to fail. At that point I have to go back and change it to 'Full' again. Is there any setting/configuration that I can chan...more >>

Hello, How can I write a view that gets data from different database in the same Database server? ...more >>

We sell a software package that runs on dedicated servers at sites that typically have no db administrator. SQL Server 2000 is the database, and the application is very write intensive – data for 50 to 200 parameters is written to the database every minute, 24 hours a day, 7 days a week. T...more >>

I am trying to process a cube built off 4 smaller cubes in a snowflake schema. The Design Storage process successfully about 1500 aggregations. I get all the way in processing to where partitions are going to be built, and then I get "Relational data provider reported error: [Parsing error o...more >>

I have SQL Server 2005 Developer edition. What is the best way to create a data dictionary for an existing database? Does reporting services or other tools provide canned reports that include all objects including keys, constraints etc? Do I need to write my own queries to generate the meta d...more >>

Dear sir, On one of my page, it often reach a connection time out for the first hit. After the first hit, that page will be much faster for the second visitor. However after a while, that page back to original situation, waiting for the first hit to make it faster. I think this is beca...more >>

Is it possible to run analysis services 2000 and analysis services 2005 on the same computer? I'm looking to migrate, but need to run production in both environments concurrently until we're ready.... ...more >>

Need a little advice, I am creating an application, created two databases, one for building the app. And the other is for when it is running. Is there a simple way of copying the stored procedures to the one that i will be running the app on? All the tables and columns are named the same in both...more >>

Does anyone know what Visio shape can I use to represent an outer join? Help! ...more >>

Hi, We have specific problem here. We have very large database (1TB) on one server, and we need to set up log shipping to another server. Problem is that we don't make regular sql server backups on the source server because of obvious reason (it would take too long). Therefore we cannot resto...more >>

I have two different databases DB1 and BD2. which one table in each. TableDB1: ID, Amount1 and TableDB2: ID, Amount2. Now my sub-report in Reporting Services should report ID and sum of DB1.TableDB1.Amount1 and DB2.TableDB2.Amount2. How should I write my query? ...more >>

Hi, How do I check the table size in a db? thanks, ...more >>

Hi, Can you please direct me to the correct news group. In case this is the correct place....... Problem: I need to extract all employees with state='CA' from a sqlServer 2005. Solution so far: What we have done is created a 1) "DataReaderSource" to the DB 2) Then a "conditional...more >>

I managed to connect via TCP/IP on the local machine that has the instance running. My connection string would look something like this: SQLCMD -S 192.168.1.103\SQLEXPRESS -U username -P password This works. On my firewall I have forwarded the correct ports: TCP port 1433 -> 192.168.1.103...more >>

I am currently running SQL 2000 standard SP3a on WIndows Server 2003 standard edition. I wish to update Server 2003 to Service Pack 1. Has anyone had any problems doing this, or is it better not to?...more >>

Hello I'm trying to make a connection from Web developer 2005 express to a sql database (sql server 2005 express), which has worked for me a dozen times before but now I'm getting the error 26 message....error locating server. My web site is file based on my computer. I'm unable to resolve th...more >>

I need to be able to reset failed job status to "success" on a SQL Job without re-running the job. What's the correct T-SQL to accomplish this? Thanks in advance for your help. Oscar Elleseff ...more >>

I am trying to get my head around many of the issues related to maintaining some of our larger databases. Our largest database is roughly 10 GB. Our largest table in the database has 15,783,725 rows with a size of 9.8 GB and an index size of 2.8 GB according to the taskpad view. It has one c...more >>

1. Is it possible to capture only those events that are associated with a particular table? When I try to filter on object name or id it appears to have no effect. 2. I am trying to capture all stored procs calls without redundancy (e.g., so that the same call is not recorded twice). It ...more >>

Dear Sir, I used dynamic SQL on stored procedure to do the paging in my site. I often hit a connection with that dynamic SQl when I call it from .NET code. However if it run it under query analyzer, everything works fine. Who can explain this to me and what should I do in this case? ...more >>

i'm new to SQL Server 2000. i had install it successfully, but can't configure ODBC settings, so whenever i try to create database using Enterprise Manager it gives error. anybody pl help me ...more >>

Dear All, We are planning an application where we need to maintain separate databases for each customers. Now, the number of customers in one year would be 50,000. I read that theoretically it is possible to maintain 32000 databases in a single instance of SQL Server, but I can guess that it wou...more >>

Hi, I search the hotfix 986 for Analysis Services but i don't find the donwload url's. Thank's for you help...more >>

My LDF file is 1.8GB big and my data file is only about 100mb big. I have had the recovery model set to full until recently which is probably why it has ended up so big. I have now changed that to simple. Now no matter what I do the LDF file stays at exactly 1,785,856 KB in size. I have tried ...more >>

Hello, this is the scenario. I have SQL Developer (VS 2005 Pro) installed on my local computer where I am developing a ASP 2.0 solution that I also upload to a remote server / database server. Until recently I could connect to the remote db using Server Management Studio, SMO, DMO etc, b...more >>

Hi everyone, i was hoping to obtain some help with my backup process. Ideally I wish to make a weekly full backup, with a differential at the end of each day, and transactionals every hour during business hours. My code is below note, each backup process (full, diff and trans) will be plac...more >>

I need to retrieve information from LDAP in SQL Server 2000. I have installed SQL Server 2000 on a machine with Windows XP Professional (SP2). When I execute this script inside Query Analyzer: EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'adsdatasource'...more >>

Hi I am new to SQL server 2005 I have installed it on a remote machine (which also has sql server 2000 on it working fine) I have enabled TCPIP but still cannot link (error 26) There is a link to the ms site which is a dead end. This is a simple issue, but I already have that feeling o...more >>

ur database needs to run under a specific user, so we have it under sysusers table. When we do a restore or a copy, we used to go into that table rename the user and go into SQL security and create that user and assign the DB, we no longer can do that. How can one edit the sysusers table under S...more >>

how to know simultaneous connected count to a Database? Thank you ...more >>

Hi, I'm in the process of migrating several systems from SQL Server 2000 to SQL Server 2005. On the existing SQL Server 2000 server, I have several DTS packages, one of which uses the Copy Database feature to synchronise data on the live box with my development box. This is an ad-hoc functi...more >>

we want to use 2005 on our dev and staging boxes and eventually roll out 2005 to prod later this year. so are there any issues with doing our db related development/testing work in 2005 but keeping our prod instances on 2000? say for instance data model changes done in dev that are prop...more >>