Multiple SQL For (AS/400)
For (AS/400) I need to create a source member with multiple sentences of sql:i.e.update aa....update bb....update cc...., and then run these source member with runsqlstm.Is it possible? which is the character to separate between sentences? Thanks in advance
Answer Question
| Jul 24 2008 7:42 PM GMT
| asked by
WSCST
SQL Server administration, AS/400 and SQL
SQL Server 2005 Maintenance Plans - overwrite vs. append
I am trying to create a maintenance plan, but when I use the backup database widget, it defaults to 'append existing...'. I want 'oversrite existing...'. Can anyone help me find where that is set?Thank youCarla
View Answer
| Jul 16 2008 3:50 PM GMT
| asked by
Cecrane
SQL Server administration, SQL Server 2005
Archiving and Purging Data
We deal with a very large database that grows at an avrage of 50GB a month. The current database size is 700 GB. All the transaction tables are horizontally partitioned to seperate filegroups assigned to a individual data files holding each months data. What would be the best strategy to retain...
View Answer
| Jul 2 2008 10:24 AM GMT
| asked by
Roops
SQL Server administration, SQL Server archiving
SQL 2005 Transaction Logs
I am by no means very good at SQL. I know the basics. I am a network engineer but was recently asked to do a few tasks in a SQL 2005 environment. I currently have a database that is residing off-site and I was asked to import the database and transaction logs so that this server can be used for...
View Answer
| Jun 9 2008 4:17 AM GMT
| asked by
Danyluk
SQL Server administration, SQL Server transaction logs, SQL Server 2005
Don’t run the SQL Server Account as Local Administrator or member of the Administrator Group?
Based on the advice "Don't run the SQL Server Account as Local Administrator or member of the Administrator Group"Will this setup prevented you from using critical features? How did you get around this? The link below makes reference as to how a critical feature "Automatic Server Restart Feature"...
View Answer
| Jun 9 2008 1:09 AM GMT
| asked by
Aswad
SQL Server security, SQL Server administration, SQL Server
run DBCC SQLPREF on linked server.
I want to run DBCC command on linked server remotly
View Answer
| May 16 2008 10:05 AM GMT
| asked by
Mangesh jadhav
SQL Server administration, Database Consistency Checker, DBCC
disk activity is running at 100%
24 hrs ago disk i/o and activity shot up to 100* with quues grwoing. our average i/o queue is normally around zero with disk activity at <15% we have had this before - lasts a couple of days and then stops. we have never found out why? can anyone help?
View Answer
| May 15 2008 2:52 AM GMT
| asked by
Salmonthefish
SQL Server administration, SQL Server performance, SQL Server security
In an effort to free up SQL Server disk space, how can a DBA know when it is time to drop developers test databases from local servers?
Apart from maintaining a SQL Server checklist to check in with developers, how can a DBA know if restored databases on local servers - that were gotten for developers to test – can be dropped after a few days? This would help increase the available SQL Server disk space.Let’s say about 7 user...
View Answer
| Apr 25 2008 2:23 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server administration, disk space
Replication
Can I have multiple Distributors configured on one SQL Server instance? Also, can I have multiple Distributors configured on one SQL Server instance? Finally, can I have multiple Subscribers configured on one SQL Server instance?
View Answer
| Apr 14 2008 3:40 PM GMT
| asked by
Consultant1653
SQL database replication, SQL Server administration, SQL Server
jobs runing on the server
hi every 1,i am having a real tough time to figure this one out .i need to find out what jobs are schedule in the server that sends data out to ever .we are doing the migration from 2000 to 2005 and need to know which jobs send data to the another server .i looked at the sysjobs_view , it tells...
View Answer
| Mar 31 2008 3:08 AM GMT
| asked by
Deal11deal1
SQL Server administration, SQL Server migration, SQL Server 2000
SQL Server 2005 multi-instance cluster
I need to set up a 2 node multi-instance SQL Server 2005 cluster (active/active). Since each node will failover to the other, can I use SQL Server 2005 Standard Edition on each node or do I need to use Enterprise Edition?
View Answer
| Mar 18 2008 8:04 PM GMT
| asked by
DbaDave2
SQL Server administration, SQL Server 2005, SQL Server clustering
Merge Replication Identity Ranges
What should the publication range and subscription range be set to for each table with identity ranges, bearing in mind thousands of changes can go into some tables each day. I have 1 Publisher and 9 Subscriptions (Merge) and have started getting "The Publisher failed to allocate a new set of...
View Answer
| Mar 11 2008 4:41 PM GMT
| asked by
Ramapa
Merge replication, Replication, SQL Server administration
In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?
In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?
View Answer
| Mar 4 2008 11:36 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, SQL Server administration
sql server 2000
i have booted my system with windows xp as user xyz with limited rights not an administrator now problem is i am not able to run sql server.please tell me what should i do to run sql server 2000 in user xyz.*it works with administrator login.
View Answer
| Feb 14 2008 4:14 AM GMT
| asked by
Css
SQL Server administration, SQL Server 2000
SQL
How to find out if database are crypted
View Answer
| Jan 31 2008 9:54 PM GMT
| asked by
Mike6454
SQL Server administration


