Search results for query: *

Help, please. I have a location database on my machine (SQL Server 2005) which uses a stored procedure for my dataset. I have a remote database connection (SQL 2000) which has the same exact stored procedure. I go to "Set Database Location" to change which server I'm using. I create the new...

Any assistance that you can give me would be greatly appreciated. I have a label with the word "Detail", stuck in my page header, that I want to show up when someone drills down to the Detail line. The Detail line's property is set to Hide-Drilldown OK. The suppression formula for the Label...

All, I have just been notified about the following problem with SQL Server 2005 Service Pack 2. Hope this helps someone out. I don't think it affects plans created by programs like Litespeed Backup, but I'll post again if I notice that it does. Catadmin - MCDBA, MCSA "No, no. Yes. No, I...

All, Sorry it's been a while. One would think, with the new year, things would slow down for a while. Not so in my workplace. I'm beginning to feel like a fireman. @=) Anyway, I have an SSIS maint. package which does an Update Statistics job (only) on one production database. It's been...

All, I've posted a FAQ with the download site and the internet viewing site of SQL Server 2005 Books Online. faq962-6514 Catadmin - MCDBA, MCSA "No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?" -- Xena, "Been There, Done That"

All, Any references you can give me (books, URLs, or just comments on your own experiences) would be greatly appreciated... My boss has me searching the internet for the recommended hardware (assuming all Microsoft tools) for a data warehouse we're developing. I know the approximate size of...

All, I found a couple of SSIS articles I thought you might be interested in. The first one is about IsSorted property and why it might not be working for you. The second is about an end user created Raw File reader tool that you might want to look at if you need to read raw files...

Okay, this is aggrivating and the threads I found when searching this forum don't help or I don't understand them well enough. I'm using Visual Studio to develop a Windows VB .Net app. I've got two forms: the startup and the child which is opened in front by a button on the startup. I have a...

I have a form with 4 radio buttons in an groupBox that I'm using with the SQL Server SMO object to backup databases. Each radio button represents an environment or SQL Server instance that I am connecting to. I only want one connection at a time, hence the use of RadioButton instead of...

Has anyone else noticed this? I've got a job scheduled to run Weekly -> Every 4 weeks on Thursday from January 4th - February 1st. To me, that translates to run it on January 4th and either January 2th or February 1st (depending of if SQL Server counts the first time it ran in the 4 weeks...

Okay, here's a weird one. I was going through some documents and found some recommended coding practices for Oracle (this does relate to this forum, I promise!). When going through it, I noticed a couple of things which are essentially the anti-thesis of my SQL Server coding practices. This...

All, Found another issue. This one regards sudden and unexplained database growth if you fail over your Database Mirror (SQL Server 2005): http://www.kbalertz.com/Feedback_925277.aspx Catadmin - MCDBA, MCSA "No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again...

All, Here's some info on an error you may get if you're trying to install the Community Technology Preview of SQL Server Service Pack 2 onto a SQL Server Express machine: http://www.kbalertz.com/Feedback_929667.aspx Catadmin - MCDBA, MCSA "No, no. Yes. No, I tried that. Yes, both ways...

All, Need some help here. I can do this through SSMS, but for some reason can't do it through T-SQL and would rather use T-SQL. Restored a database to a QC server. I have an orphaned domain login which belongs only to the Prod server. I need to drop this login and add the QC login. I can...

Here's an article about a known Microsoft issue between Visual Studio 2005 and the Business Intelligence Studio version of VS. Thought you guys might be interested. http://www.kbalertz.com/Feedback_929664.aspx Catadmin - MCDBA, MCSA "No, no. Yes. No, I tried that. Yes, both ways. No, I...

All, Steve Jones, from SQL Server Central, wrote an interesting article on outer joins causing problems for DBAs last year. I just discovered it this morning. It actually explains quite a few things about why you should sometimes put your WHERE clause filters in the ON clause of the JOIN...

All, Just spotted this on a SQLServerCentral.com enewsletter and thought I'd share. If you want to join multiple result sets, there are two ways to do it. UNION ALL TRANSFORMATION (which joins unsorted result sets) and MERGE TRANSFORMATION (which joins sorted result sets). I haven't used...

All, Has anyone run into any problems with Profiler for Server 2k5 killing their applications? We have a clustered Production environment (active/passive). The database is connected to via an MS Access ADP file which in turn the end users open via load balanced Citrix Servers (there are 3 or...

FYI: If you're having problems running BIDS/SSMS on a computer with Analysis Services installed, this might be the reason why: http://support.microsoft.com/default.aspx/kb/926421 Also, found an article that points to links with work arounds...

All, Just an FYI for those of you who use SSAS (Analysis Services). This person claims to have repeatedly reproduced a bug with the deployment wizard: http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!978.entry Catadmin - MCDBA, MCSA "No, no. Yes. No, I tried that. Yes, both ways...