Supression by date and field data
I am trying to suppress a text field within a section by both field parameters being null and also by specific time frame. The formulas work independently just fine, but not when placed together. (isnull({DBA.POST})= false or isnull ({DBA.ANNUAL}) = false) and {DBA_DATE.Report_DATE} < DateTime (2012,11,04,00,00,00)

Answer Question   |  November 15, 2012  3:44 PM
SQL 2005, SQL 2005 Database

Restore SharePoint 2003 database/s on SQL Server 2005
I am not sure if this should be addressed by the SQL Server group or SharePoint Server group. Since I am more familiar with SQL Server than SharePoint I started here. We have SharePoint Server 2003 installed on Windows 2003 server running SQL Server 2005. We have been backing up daily, two of the SharePoint [...]

Answer Question   |  July 24, 2012  3:52 PM
Restore Database, SharePoint 2003, SQL 2005

Ageing Report T-SQL
Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for each period The Billing table is pre-populated with the charges per month as per the amortization schedule when a client [...]

Answer Question   |  March 31, 2012  1:29 PM
MSSQL, SAP Aging Reports, SQL 2005, T-SQL

Updating a Date Time Field
I need to update the Confirmation Date Time field to NULL for a specific meeting but am unsure how to insert it.  The script below works for an individual but if they have more than 1 confirmation date it clears then all. Meet_Master.MEETING is where the meeting code AM2011 is. UPDATE   ORDERS SET CONFIRMATION_DATE_TIME = [...]

Answer Question   |  March 31, 2012  4:27 PM
Scripts, SQL, SQL 2005, SQL Server, SQL Server 2005

Update a Date_Time Field
I’m trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I’m missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ‘ ‘ WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value ‘Ê’ to [...]

Answer Question   |  March 31, 2012  3:05 PM
Scripts, SQL, SQL 2005, SQL scripts, SQL Server 2005

Connecting to SQL Database
We are no longer able to connect to our SQL database or open the DB manager on Windows Server 2008. This is SQL 2005 how can we troubleshoot this issue? We have a 2.9gb database and backups from each night.

Answer Question   |  March 31, 2012  5:59 PM
Database management, SQL 2005, SQL 2005 Database, SQL Database, Windows Server 2008

Name Pipe work arounds in SQL 2005 database
I am working on a SQL 2005 data base, the supplirer is telling me that the reason I am unable to find the SQL Data Base when i run there Client install software through a VPN connection is that the Name Pipes are keeping the Data base from being accessed.   Can anyone herlp me with this issue [...]

Answer Question   |  March 31, 2012  12:41 AM
SQL 2005, SQL Express, SQL Server, SQL Server administration, SQL Server security

Run time error 3265 VB6.0/SQL2005
I am making a report inwhich i want to insert some values from a diffrent Table ( By making a module) Coding of Module is:- Public Function Deposit(ByVal M) Set conn14 = New Connection Set rs14 = New Recordset With conn14 .ConnectionString = Connection = “provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=BCS1;Data Source=DEEPAK” .Open End With rs14.CursorLocation [...]

Answer Question   |  March 31, 2012  2:39 PM
SQL 2005, SQL 2005 Database, VB 6.0, Visual Basic 6.0

Optimize SQL 2005 databases on a schedule
How can I optimize my SQL 2005 databases on a schedule?

Answer Question   |  June 28, 2011  6:21 PM
SQL 2005, SQL 2005 Database, SQL Database, SQL Server 2005, SQL Server 2005 Database

System tables in SQL Server
How to view System tables in drop down menu of a database in SQL SERVER 2005

Answer Question   |  June 23, 2011  12:43 PM
Database, SQL 2005, SQL Server 2005, System tables

Stop one database in a SQL 2005 environment
If there are multiple databases ever one unique SQL2005, how can I stop only one of them?

Answer Question   |  May 2, 2011  11:24 AM
SQL 2005, SQL Server 2005, SQL Server 2005 Database

How to install SQL 2005
Hey what was minimum hardware requried for SQL2005

Answer Question   |  April 8, 2011  6:58 AM
SQL 2005, SQL Server 2005, SQL Server Hardware, SQL Server installation

Updating a SQL Server record in a large table
We are using SQL Server 2005 and I have an SQL DB on it with 270,876 records in it. There is a PRIMARY KEY defined on the first field called RecordID (Identity field). The index name is PK_ListOfFiles_as_of_3-7-2011. If I execute the following command from the Query Window on the server it takes a really [...]

Answer Question   |  March 22, 2011  1:42 PM
INSERT statement, SQL 2005, SQL Database, SQL Server

SQL 2005 Database instance
Hi there i have a windows 2003 domain in our school, i have a problem with my sql 2005 database. im trying to uninstall a instance from the database engine. it wont uninstall. i believe that this is corrupt. im trying to reinstall sophos but as the old database will not uninstall sophos wont reinstall. [...]

Answer Question   |  April 12, 2011  12:13 PM
Database Instances, SQL 2005, SQL Server 2005, SQL Server 2005 Database, Windows Server 2003 Domain, Windows Server 2003 SP2

SQL Server 2005 database installation
i installed sql2005 s/w in my system.but i don’t know how to use it.i don’t know how to create database and manage and all.can u help me?

Answer Question   |  February 7, 2011  5:20 AM
SQL 2005, SQL Server 2005, SQL Server 2005 Database, SQL Server database

How to concat SQL Server 2005 data with line feed
I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The [...]

Answer Question   |  February 2, 2011  10:46 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL

Connect Powerbuilder in SQL Server 2005
how to connect the sqlserver 2005 database in power builder

Answer Question   |  February 1, 2011  12:36 PM
PowerBuilder, SQL 2005, SQL Server 2005, SQL Server connectivity

Experience applying SP4 to SQL 2005?
Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I would to [...]

Answer Question   |  February 7, 2011  5:49 AM
Database Instances, SQL 2005, SQL Server 2005, SQL Server database, SQL Server multiple instances

VIEW_TABLE_USAGE SQL 2005
In MS SQL 2005, when I select * from VIEW_TABLE_USAGE, I get incomplete results. At least one object that is used in at least one of the views is not listed. View “PTP__MARA_MARC” uses two tables and one view, but VIEW_TABLE_USAGE only lists one table and one view.  Can you please help?

Answer Question   |  January 26, 2011  2:53 PM
SQL, SQL 2005, VIEW_TABLE_USAGE

Storage Area Network Configuration IOPS
I have a SAN with a RAID 10 (16 Drives) and a stripe size of 512. I want to align the disks for better SQL Server performance, the problem is that the OS is already installed on a non-aligned drive and SQL Server is running in production using non-aligned drives. My current 8 drives starting [...]

Answer Question   |  January 17, 2011  11:10 PM
IOPS, SQL 2005, SQL Server 2005, SQL Server 2005 performance, Storage Area Networks