Why might a maintenance plan fail to generate a SQL Server job?
I was reading the article “Use the database maintenance plan wizard” on SearchSQLServer.com and wanted to ask, why in some cases, a maintenance plan would fail to generate a SQL Server job. I currently have cases where a maintenance plan was saved but jobs were not created at all or, in one...
Answer Question
| Apr 28 2008 3:34 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server performance tuning, SQL database
Moving a SQL database from one host to another
I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site.Can anyone...
View Answer
| Apr 28 2008 2:54 AM GMT
| asked by
Kwoodall
SQL, ASP, SQL database
How can I restore my old data into the new design in SQL Server 2000
The SQL Server 2000 application I was using was badly designed. Now that there has been a rework of my database design, so many more tables and columns are being added. How can I restore my old data into the new design?
View Answer
| Mar 17 2008 2:34 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, SQL database, SQL Server
Accessing MS SQL Server database from the iSeries
How to set up TCP/ IP on both ends( SQL server and AS/400)?I keep geting "host name not found" on as400.Thanks,Lan
View Answer
| Nov 2 2007 5:26 PM GMT
| asked by
Lan123
AS/400, SQL database, SQL Server
database sql,with vb coding,first time running not fast
we have an accounting package written in visual basic 6.0 and sql database,the problem is when we open the database the first time,it takes lot of time,but when we open it after, it will be very fast and remain fast ,even when we quit the application and restart it.
View Answer
| Oct 2 2007 8:40 AM GMT
| asked by
Micus2005
Visual Basic 6.0, SQL database


