Search results for query: *

Hi all, I just installed a new instance of SQL Server 2000 Enterprise Edition on a 2-node cluster. The server has 3 local drives and several SANS drives that have been presented to the server. Everything is working quite well, with 2 exceptions. 1. When I try to create a maintenance plan, 2...

I have a couple of servers where SQL Server 2000 Standard Edition is set to Autostart, but the service is not starting on reboot. The event logs look fine. Any ideas? Works fine on most servers, and starts right up manually. -Chris

Hi all, I need advice on a strategy to create a reporting instance of a database. There are difficulties involved. I am using SQL Server 2005 Enterprise edition. The Situation: 1. The original data is in Oracle 10g. 2. The Oracle data is a star schema. 3. This data needs to find its way...

Hi all, Does anyone know if it's possible to overload a stored procedure in SQL Server 2005 as you can with Sub Procedures in .NET programming languages? I was just thinking that it might be a useful concept in an enterprise architecture environment, but I haven't worked with 2005 yet. -Chris

Hi all, I was wondering if SQL Server 2005 had the ability to overload stored procedures like the .NET programming languages can do with subroutines. I haven't touched it yet, and I was thinking that would be really cool. -Chris

Over the course of time, developers could alter table structure without realizing the implications of doing so. As the result, stored procedures have a tendency to break. I was thinking about a way to overcome such an issue. It seems to me that the only way to find the broken stored...

I am required to disable SQL Mail as part of compliance with policy. I have looked everywhere, but I can't seem to find the way to do it. Can someone point me in the right direction? Thanks! -Chris

Hi all, I recently decided to take a swipe at writing a script to generate stored procedures. I searched the web, and there are programs that do this for you, but none of them had the options I wanted. I wanted a generator that would write a procedure, complete with comments of my making at...

Hi all, I have a strange problem. I looked through all of the solutions listed for the error I am getting, but to no avail. Hopefully someone can shed a little light on the subject. I have a SQL Server 2000 default instance running on a Windows 2003 Server. Developer load is light on this...

Hi all, I am having a problem getting databases to show up in Enterprise Manager, SQL Server 2000 Standard Edition (SP3). I have created a SQL Server authenticated login and made that login dbo for 7 databases. When that user tries to connect, the registration is successful, but no databases...