I installed some software that had a prerequisite that SQL Server 2005 had to be installed. I want to get rid of the SA account on my SQL Server. How can I verify that the software that I down...
I have a table with the following definition
case_id int
call_return_date (datetime)
the case_id is in sequentail order and should also have a call_return_date that is in sequential or...
I have a temp table which I'm populating with customer records:
#tblTempRespondents
lngTempId int,
lngGroupId int,
strFirstName varchar(55),
strLastName varchar(55),
strAddress varchar...
I have production server 'A' and virtual server 'B'. I took the master, msdb, model, and db1 backups from server 'A' and restored them to server 'B'. I then ran the sp_drop server 'a' and th...
I have a database linked to a form. I already have sql server set up to send an email to the administrator whenever a new record is added to the request table. I now want to be able to send ...
We have a server that we are going to install SQL 2005 on. It has 3 RAID 1 partitions (1 System and 2 Data). Because the server is going to serve two different audiences, I was going to sepe...
I had to reinstall SQL Server 2000 on my server (running Server 2003) for an ADO.Net application. I already have SQL 2005 on this. My SQL Server Management Studio on my server will allow me to...
I have a table called business_contact_alliance
. There are 3 columns in that table business_id, contact_id, alian_id.
Now I want to display all the business that have more than one alian_i...
I am trying to determine what user started the SQL service 2005. I am trying to add this user to our backup server so that I can write directly from the sql 2005 server to the backup folder on...
Hi, I have a table with a few columns (The columns of interest are key, ssn, timeofentry
key, ssn, timeofentry, D1, D2, D3....
I want to get rid of all rows within this table, but keep t...
I have a stored procedure A which i want to call when I run the stored procedure B
Stored procedure a returns multiple values and not a single value.
And stored procedure B takes all th...
We have been running an ASP.NET 1.1 application on a webserver for the last 5 years that was Windows Server 2000 running SQL Server 2000. It never had a single issue. The box failed so we mi...
Initially had a table with 653 columns and needed to add 16 more to that bringing the total to 669. I'm getting an Exception error when I try to view this empty table. If I remove the added ...
I have transactional replication set up between a SQL 2000 (Publicsher) and SQL 2005 (Subscriber). If I index the replica on the SQL 2005 server will it be overwritten by the next replication...
I have been using the default 'SA' account for testing a variety of websites and software and am going to BETA which means customers and others i do not trust. I am a newbie to most aspects of...
Hi I am currently building a 3 node cluster and have hit a snag. i have a sql server 2005 setup with 3 nodes in the cluster using MSCS.
The cluster is built and all looks OK. I have node 3 a...
Any good resources people know of out there for importing two columns from one sql server table into another sql server table but be able to map it over so the information goes to certain dest...
I have a MS SQL 2005 table with around 20 columns that I'd like to run across a spelling and grammar checker. Do you know of any software where I can do this? Ideally it would highlight spel...
Hi, I have a table with a column of type "smallint". I have numbers from 0 to 435. The thing is, some numbers are deleted from the set. Example, there are no rows corresponding to values 8, 43...
I have a question regarding sql 2005 and my database setup. This is what it looks like
Database: DBX
Tables : table1 ... tableN
Users: domain\user1 .. domain\userN
Roles: roleX
Applicatio...
Greetings,
I am trying to create a script using XP_FIXEDDRIVES that will page staff when disk drives exceed 70% usage . I also want a script that can be used as a daily report on current di...
Given:
- 2 instances of SQL 2005 Standard connected to each other over a secure 1Mb WAN link
- Instance "A" is production now and has been for a few months
- Instance "B" is fresh and has n...
Hi,
I have two tables:
EarliestMedDate (patientID, Source, MedDate, MedPeriodNum) where the period number corresponds to the MedDate
e.g.
patientID, source,medDate, PeriodNum
1,C,2001-...
I am trying to understand a software suppliers claims that there is a significant performance difference between MS SQL 2005 Express, Workgroup and Standard versions for the same application r...
Hello,
I'm trying to run a transitional replication between two SQL Server 2005 databases located on 2 different virtual servers (Production and Development) but everytime the snapshot agen...
