Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Posted by ipramod NO[at]SPAM gmail.com at 2/22/2006 11:01:27 PM
I want to know the Total Memory(Bytes). As there is no such performance
counter available in System performance viewer. The performance counter
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 >>
Best practice for shrinking Databases
Posted by Dan at 2/22/2006 5:25:11 PM
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 >>
Posted by Jesus Suarez at 2/22/2006 5:13:10 PM
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.
Rebuild indexes affects other databases?
Posted by jonathanve NO[at]SPAM gmail.com at 2/22/2006 4:03:21 PM
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 >>
SQL Server and Active Directory Benefits
Posted by dwyer.bill NO[at]SPAM gmail.com at 2/22/2006 3:52:49 PM
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 >>
SQL 2005 Express: Where have all the wizards gone?
Posted by Jonathan Crawford at 2/22/2006 3:48:08 PM
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
MAX number of characters
Posted by Johnfli at 2/22/2006 2:34:13 PM
What is teh maximum number of characters you can have in one field?
MSDB Recovery Model Option
Posted by helpplease at 2/22/2006 1:30:26 PM
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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
Q: view over databases
Posted by JIM.H. at 2/22/2006 12:56:28 PM
How can I write a view that gets data from different database in the same
Advice on RAID
Posted by KMP at 2/22/2006 12:11:27 PM
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 >>
Parsing error processing cube in SQL 2000 AS SP 3
Posted by Andy S. at 2/22/2006 12:07:10 PM
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 >>
Best Method to Document Database?
Posted by Simon Shutter at 2/22/2006 12:03:34 PM
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
cache of stored procedure
Posted by guoqi zheng at 2/22/2006 11:50:05 AM
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 >>
running AS 2000 and AS 2005 on same hardware...
Posted by eric.schleicher NO[at]SPAM gmail.com at 2/22/2006 11:34:15 AM
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....
Moving of Stored Procedures
Posted by Thomas Beyerlein at 2/22/2006 11:26:38 AM
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 >>
Posted by docsql at 2/22/2006 10:19:37 AM
Does anyone know what Visio shape can I use to represent an outer join?
log shipping without backing up and restoring the whole database
Posted by Pedja at 2/22/2006 10:19:31 AM
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 >>
Q: reporting from two different database
Posted by JIM.H. at 2/22/2006 10:15:21 AM
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
DB2.TableDB2.Amount2. How should I
write my query?
sql 2k table size
Posted by mecn at 2/22/2006 10:07:37 AM
How do I check the table size in a db?
Hi, where do I ask SSIS related questions
Posted by Nalaka at 2/22/2006 9:22:44 AM
Hi, Can you please direct me to the correct news group.
In case this is the correct place.......
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 >>
ss2005 remote connection part ||
Posted by Steve at 2/22/2006 8:37:58 AM
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 >>
Server 2003 SP1
Posted by Bill at 2/22/2006 8:32:32 AM
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 >>
Posted by ChrisCB at 2/22/2006 8:18:29 AM
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 >>
How to reset SQL Job Status
Posted by Oscar at 2/22/2006 8:10:26 AM
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.
Maintenance, indexes, fragmentation & file groups
Posted by kghammond at 2/22/2006 7:54:00 AM
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 >>
3 Basic SQL 2000 Profiler Questions
Posted by Dave at 2/22/2006 7:11:33 AM
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 >>
performance on query analyzer and .NET
Posted by guoqi zheng at 2/22/2006 5:33:29 AM
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?
Posted by bhagvativ NO[at]SPAM yahoo.com at 2/22/2006 2:44:46 AM
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
Maximum databases per server
Posted by santoshmahale NO[at]SPAM gmail.com at 2/22/2006 2:20:36 AM
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 >>
Posted by rs232 at 2/22/2006 2:20:30 AM
I search the hotfix 986 for Analysis Services but i don't find the donwload
Thank's for you help...more >>
Large LDF File
Posted by Boxwell at 2/22/2006 1:17:28 AM
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 >>
SQL Server Management Studio and
Posted by orefors NO[at]SPAM gmail.com at 2/22/2006 1:01:43 AM
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 >>
Help with backup (Full, differential and transactional) process
Posted by steve at 2/22/2006 12:51:53 AM
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
note, each backup process (full, diff and trans) will be plac...more >>
Error while linking server to Active Directory service
Posted by Pasquale at 2/22/2006 12:06:49 AM
I need to retrieve information from LDAP in SQL Server 2000.
I have installed SQL Server 2000 on a machine with Windows XP Professional
When I execute this script inside Query Analyzer:
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
'ADSDSOObject', 'adsdatasource'...more >>
New to SQLServer 2005
Posted by Jonathan Crawford at 2/22/2006 12:00:00 AM
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
How can one edit the sysusers table under SQL 2005?
Posted by API Conektia at 2/22/2006 12:00:00 AM
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?
Posted by Asking at 2/22/2006 12:00:00 AM
how to know simultaneous connected count to a Database?
DTS in SQL Server 2005
Posted by Mark Rae at 2/22/2006 12:00:00 AM
I'm in the process of migrating several systems from SQL Server 2000 to SQL
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 >>
using 2000 and 2005 at the same time
Posted by usenetjb at 2/22/2006 12:00:00 AM
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 >>