Viewing 15 posts - 76 through 90 (of 126 total)
Niyala (9/24/2008)
September 25, 2008 at 7:17 am
All the more reason for me to read up some more on them! 🙂
September 23, 2008 at 1:10 am
Brilliant article! It just goes to show that there are a whole host of things to consider whenever you're devising a backup strategy for your systems. Thanks to...
September 23, 2008 at 12:49 am
If you look at the cluster resources in Cluster Administrator for your SQL group it should show you which of the resources has not started. Your database engine might...
September 1, 2008 at 4:06 am
An option might be to change the Recovery model of the database to Bulk Logged before you rebuild your indexes, and then change it back to full once that's completed....
August 4, 2008 at 5:12 am
All "&&"s were supposed to be replaced by line feeds, but that somehow didn't quite work out as expected.
I did wonder. My eyes were going a little blurry...
August 4, 2008 at 4:59 am
Sorry, I forgot you were using Express (which is basically a replacement for MSDE). This is taken from MSDN:
Support for SQL Server 2000 DTS Packages in SQL Server 2005...
July 24, 2008 at 1:06 am
Ah if you want to create new ones then that's another limitation. One way I've found of getting around this though is by editing an existing DTS package and...
July 23, 2008 at 1:39 am
Your boss seems very adament about what they don't want to see, so have you asked the question about what they do want to see? 😉 On a bit...
July 22, 2008 at 9:02 am
Forgot to mention something ...
With the SQL 2000 DTS Designer Components, when you're editing a DTS package you won't be able to do anything else in Mgmt Studio (it all...
July 22, 2008 at 5:54 am
If you want to edit your DTS packages through the SQL Express Management Studio then you can access them through Management > Legacy > Data Transformation Services when you connect...
July 22, 2008 at 5:50 am
And then implement a routine to defrag the indexes regularly
July 15, 2008 at 4:43 am
Reports are compiled in Report Definition Language (RDL - a fancy form of XML). You can get the source file from your solution where you'll find the form in...
July 11, 2008 at 6:41 am
OK - I think we might need to distinguish between reports that are being designed/developed, and reports that are deployed/available for users to run.
If you're still developing reports in BIDS/Visual...
July 11, 2008 at 5:18 am
Alen,
Your report definitions are contained within the ReportServer database, and so as long as you back up this database, you will be able to recover your reports.
If your server goes...
July 11, 2008 at 1:57 am
Viewing 15 posts - 76 through 90 (of 126 total)