Hello, I am pretty new to Sql. I had setup a SQL Express 2005 Advanced on a computer w/ xp on it before and had no problems. I recently purchased a installed a new computer (the other one died) w/ Windows Vista. As before, I downloaded and configured Sql Express per instructions for the software [...]
Answer Question | May 14, 2008 11:16 AM
Network connectivity, SQL Server 2005, SQL Server Express
i need a list of encrypted store procedure name,encrypted trigger ,encrypted functions from sql server 2005.
Answer Question | May 14, 2008 7:50 AM
Encrypted stored procedures, Encrypted triggers, SQL Server 2005
Hello, I’m using Ms SQL Server 2005. I’m connecting server via ADO. I have a question about access rights. Let me tell this with an example. Let’s say I have a database named as DB. In DB there are 3 tables. TBL_1, TBL_2, TBL_3. I want to create a SQL user which will have all [...]
Answer Question | January 7, 2010 7:49 PM
ADO, SQL Server 2005, SQL Server security
Via Crystal Report2008 I have to produce a number of reports collecting data from a SQL2005 database running on another computer(2). This computer is not in my domain, but in a workgroup. However, the computer has the same IPaddress category. Anybody can help me with the steps to connect to the SQL database? Thanks Edgar
Answer Question | May 12, 2008 11:14 PM
Crystal Reports, Crystal Reports 2008, SQL Server 2005
using sql 2005, management studio,, how to schedule a daily database and restore plan.
Answer Question | May 8, 2008 1:58 PM
SQL Server 2005, SQL Server backup, SQL Server Management Studio, SQL Server restore
I’m setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.
Answer Question | May 7, 2008 4:12 PM
Database mirroring, SQL Server 2005, SQL Server alerts
I’m in a test phase and would like to connect to a Sybase ASE 15 server in much the same way as linking tables in access. How would I accomplish that?
Answer Question | May 14, 2008 9:06 PM
SQL Server 2005, Sybase, Sybase ASE 15
Has sql 2005, using management studio to do a full backup of my database. Using maintenance wizard to set the backup. I only see my local drive and not my share folder created onthe other server where i want to place the .bak file. Any idea will be helpfull.
Answer Question | May 7, 2008 2:10 PM
SQL Server 2005, SQL Server backup, SQL Server Management Studio
I will be upgrading a number of SQL Server 2000 databases to SQL Server 2005 and was wondering what database objects I have to worry about? I believe to run Data Transformation Services (DTS)in 2005, I will have to have legacy installed. Is that correct? Other than that, should there be any problems with stored [...]
Answer Question | May 2, 2008 5:51 PM
DTS, SQL Server 2000, SQL Server 2005, SQL Server upgrades
What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?
Answer Question | May 2, 2008 5:23 PM
Clusters, SQL Server 2005, SQL Server clustering, SQL Server installation, Windows Server 2003, Windows Server 2003 SP1
I want to know how to Export BLOB data to a JPG File at the SQL Server end … NOT USING C# or VB
Answer Question | May 2, 2008 2:46 PM
BLOB, Database, SQL Server 2005
Is there any Load Balancing in SQL Server 2005 to distribute CPU load between more than one server?
Answer Question | February 11, 2012 11:07 AM
Load balancing, SQL Server, SQL Server 2005, SQL Server clustering, SQL Server performance
I just patched my servers to this build and noticed that the time used to ‘Delete files based on the age of the file at task run time’ within a maintenance cleanup task is screwed up. Hours become days, days become weeks, weeks become months when the Maintenance Plan executes. Anyone else noticed this with [...]
Answer Question | April 25, 2008 5:53 PM
Hot fixes, SQL Server 2005, upgrades and patches
We have 1 server Proliant ML570T04 with 16GB di ram and 11 SAS Disk 70 gb. The software installed is SQL Server 2005, 32-bit and the application is Navision. With < 15 clients, the response time is slow because the SQL Server utilizes only 4 GB of ram. Is it possible to utilize the remaining [...]
Answer Question | April 25, 2008 2:27 PM
SQL Server 2005, SQL Server memory, SQL Server performance tuning
hi.. i have tried UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableB WHERE TableA.A3 = TableA.B3 this query but it is not working.. plz any one suggest me.. thx in advance…
Answer Question | April 25, 2008 4:47 AM
BULK UPDATE, SQL Server 2005
HI would like to know if we need to apply patches for a newly created instance if the default instance has already been patched to SP2 Thks for any info
Answer Question | April 25, 2008 3:31 AM
SQL Server, SQL Server 2005
After (successfully???) attaching a database to a VM Ware instance of MS SQL Server 2005 and setting what appear to be appropriate access to the SQL server itself and the database involved, and making sure that sharing and security are properly set on the SQL server, I am receiving the following error when attempting to [...]
Answer Question | April 25, 2008 9:21 PM
Database, Servers, SQL, SQL Server 2005
I need to update Column A1, Column A2 data in table A with Column B1, Column B2 data in table B for over 100,000 rows. How do I write a procedure to accomplish this in SQL Server 2005?
Answer Question | April 19, 2013 9:49 PM
BULK UPDATE, SQL Server 2005
We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster. Because the cluster is [...]
Answer Question | April 24, 2008 6:23 PM
SQL, SQL Server 2005, SQL Server clustering
Category: SQL Server 2005, T-SQL I have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don’t want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved? I don’t [...]
Answer Question | April 23, 2008 5:34 PM
SQL Server, SQL Server 2005, T/SQL, Triggers