CASE sintaxis error in SELECT
In the middle of a large storage procedure I have a working SELECT 01 (see below) which at a couple of points uses CASE statement. I need to expand the most inner CASE to get SQL Server check for several values instead of one. Currently CASE I am talking about looks like (it is in [...]
Answer Question
| July 19, 2008 7:46 PM
CASE statement, SELECT statement, SQL Server 2005, T-SQL
In the middle of a large storage procedure I have a working SELECT 01 (see below) which at a couple of points uses CASE statement. I need to expand the most inner CASE to get SQL Server check for several values instead of one. Currently CASE I am talking about looks like (it is in [...]
Answer Question
| July 19, 2008 7:46 PM
CASE statement, SELECT statement, SQL Server 2005, T-SQL
Creating a database on two nodes in a SQL Cluster
I have set up a SQL Cluster for three nodes, but I need to create a database on only two nodes. How would I do this?
Answer Question
| July 18, 2008 6:54 PM
Clusters, SQL Database
I have set up a SQL Cluster for three nodes, but I need to create a database on only two nodes. How would I do this?
Answer Question
| July 18, 2008 6:54 PM
Clusters, SQL Database
The purpose of an “undo” file in SQL Server
I performed a full backup on a development database (Full Recovery Model) in SQL Server, made some changes, backed up the transaction logs, made some more changes and backed up the transaction logs again. Now, when I restore the database using WITH STANDBY, it puts the database into a read only mode. I’ve noticed that [...]
Answer Question
| July 18, 2008 6:49 PM
Backup, SQL Server backup, SQL Server restore, Transaction logs, WITH STANDBY
I performed a full backup on a development database (Full Recovery Model) in SQL Server, made some changes, backed up the transaction logs, made some more changes and backed up the transaction logs again. Now, when I restore the database using WITH STANDBY, it puts the database into a read only mode. I’ve noticed that [...]
Answer Question
| July 18, 2008 6:49 PM
Backup, SQL Server backup, SQL Server restore, Transaction logs, WITH STANDBY
Error in the installation of SQL Server 2005 (64-bit)
We are trying to upgrade our installation to SQL Server 2005 (64-Bit) Edition, but we cannot get past the following error reported in the Event Log: *********************************** Event Type: Error Event Source: MsiInstaller Event Category: None Event ID: 11706 Date: 17/07/2008 Time: 14:01:43 User: KELTONJames.Marley Computer: SQL-SRV-1 Description: Product: Microsoft SQL Server Native Client — [...]
Answer Question
| June 1, 2010 6:45 PM
Event log errors, SQL Server 2005, SQL Server 2005 (64-bit)
We are trying to upgrade our installation to SQL Server 2005 (64-Bit) Edition, but we cannot get past the following error reported in the Event Log: *********************************** Event Type: Error Event Source: MsiInstaller Event Category: None Event ID: 11706 Date: 17/07/2008 Time: 14:01:43 User: KELTONJames.Marley Computer: SQL-SRV-1 Description: Product: Microsoft SQL Server Native Client — [...]
Answer Question
| June 1, 2010 6:45 PM
Event log errors, SQL Server 2005, SQL Server 2005 (64-bit)
SQL Server
What is a tempDB in SQL Server?
Answer Question
| July 19, 2008 8:50 AM
SQL Server 2005, TempDBs, Visual Studio 2005, Windows XP
What is a tempDB in SQL Server?
Answer Question
| July 19, 2008 8:50 AM
SQL Server 2005, TempDBs, Visual Studio 2005, Windows XP
Creating SQL databases for customer data
I am creating an application that potentially has quite a lot of rows of data for hundreds of customers. Each set of customer data is only for that customer. There may be some future requirement to summarize the data for all customers, but that is not currently needed. Would it be better to place all [...]
Answer Question
| July 17, 2008 4:52 PM
SQL Database
I am creating an application that potentially has quite a lot of rows of data for hundreds of customers. Each set of customer data is only for that customer. There may be some future requirement to summarize the data for all customers, but that is not currently needed. Would it be better to place all [...]
Answer Question
| July 17, 2008 4:52 PM
SQL Database
VB.NET code ideas on a SQL Server
What VB.NET code would I use to populate a ComboBox with all SQL Server names and IDs in a network? Also, what VB.NET code would I use to backup my SQL database using parameters?
Answer Question
| July 17, 2008 4:50 PM
Code, ComboBox, SQL Database, VB.NET
What VB.NET code would I use to populate a ComboBox with all SQL Server names and IDs in a network? Also, what VB.NET code would I use to backup my SQL database using parameters?
Answer Question
| July 17, 2008 4:50 PM
Code, ComboBox, SQL Database, VB.NET
Password policies for SQL Server 2005 (Yukon)
What are the password policies within SQL Server 2005 (Yukon)?
Answer Question
| July 17, 2008 4:44 PM
SQL Server 2005, SQL Server permissions, Yukon
What are the password policies within SQL Server 2005 (Yukon)?
Answer Question
| July 17, 2008 4:44 PM
SQL Server 2005, SQL Server permissions, Yukon
How do I write the code to connect an .aspx webform to a MS SQL server and database
This was done in VS 2008 the web forms are registration and log in forms with aspx controls. I created the database and the tables ( but am having issues with the constraints for 3 columns). I am trying to find out how to connect the 2 and where would I put the code. I [...]
Answer Question
| July 17, 2008 1:47 PM
Server errorlog, SQL Server 2005, SQL Server errors, VS 2008
This was done in VS 2008 the web forms are registration and log in forms with aspx controls. I created the database and the tables ( but am having issues with the constraints for 3 columns). I am trying to find out how to connect the 2 and where would I put the code. I [...]
Answer Question
| July 17, 2008 1:47 PM
Server errorlog, SQL Server 2005, SQL Server errors, VS 2008
Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it
Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it? Hey i have Zip file which i want to extract using the sql script or using DTS Packages. and also want to run the Batch file from DTS Packge. its possible or not ? and yes then [...]
Answer Question
| July 17, 2008 8:27 AM
Batch files, DOS Batch, DTS packages, SQL scripts
Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it? Hey i have Zip file which i want to extract using the sql script or using DTS Packages. and also want to run the Batch file from DTS Packge. its possible or not ? and yes then [...]
Answer Question
| July 17, 2008 8:27 AM
Batch files, DOS Batch, DTS packages, SQL scripts
SQL Server 2005 Reporting Services (Web Service)
I have installed SQL Server 2005 reporting services, its works fine but the web service is not working. my web service is running under network service and its as priviledge to run. When i browse it after a few minutes it says page cannot be displayed. Any help would be appreciated.
Answer Question
| July 18, 2008 8:48 PM
M-Business Anywhere, SQL Anywhere Studio, SQL Server 2005, SQL Server Reporting Services
I have installed SQL Server 2005 reporting services, its works fine but the web service is not working. my web service is running under network service and its as priviledge to run. When i browse it after a few minutes it says page cannot be displayed. Any help would be appreciated.
Answer Question
| July 18, 2008 8:48 PM
M-Business Anywhere, SQL Anywhere Studio, SQL Server 2005, SQL Server Reporting Services
Implementing access from a remote site to a SQL Server 2000 database
I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have any suggestions [...]
Answer Question
| July 17, 2008 8:23 PM
.NET, Remote access, SQL Server 2000, SQL Server database
I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have any suggestions [...]
Answer Question
| July 17, 2008 8:23 PM
.NET, Remote access, SQL Server 2000, SQL Server database
Running a lengthy query on SQL Server 2005
We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it [...]
Answer Question
| May 28, 2009 8:21 PM
Query, SQL Server 2005, SQL Server performance, Windows Server 2003
We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it [...]
Answer Question
| May 28, 2009 8:21 PM
Query, SQL Server 2005, SQL Server performance, Windows Server 2003
SQL Server 2005 Maintenance Plans – overwrite vs. append
I am trying to create a maintenance plan, but when I use the backup database widget, it defaults to ‘append existing…’. I want ‘oversrite existing…’. Can anyone help me find where that is set? Thank you Carla
Answer Question
| July 16, 2008 3:50 PM
SQL Server 2005, SQL Server administration
I am trying to create a maintenance plan, but when I use the backup database widget, it defaults to ‘append existing…’. I want ‘oversrite existing…’. Can anyone help me find where that is set? Thank you Carla
Answer Question
| July 16, 2008 3:50 PM
SQL Server 2005, SQL Server administration
Could you please advise the command to print hardware config. from AS/400
Could you please advise the command to print hardware config. from AS/400
Answer Question
| May 4, 2010 7:19 AM
AS/400 printing, Config
Could you please advise the command to print hardware config. from AS/400
Answer Question
| May 4, 2010 7:19 AM
AS/400 printing, Config
Writing a specific query in SQL Server 2005
I have a table called “ticketing” and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?
Answer Question
| July 16, 2008 8:28 PM
Query, SQL Query, SQL Server 2005
I have a table called “ticketing” and I want to bring from that table the record with the most current date. What kind of query should I write in SQL Server 2005 to bring up that result?
Answer Question
| July 16, 2008 8:28 PM
Query, SQL Query, SQL Server 2005
Backing up a SQL Server 2000 database through VB.NET 2005
How might I backup a SQL Server 2000 database through VB.NET 2005?
Answer Question
| July 16, 2008 6:53 PM
Backup, SQL Server 2000, VB .NET, VB.NET 2005
How might I backup a SQL Server 2000 database through VB.NET 2005?
Answer Question
| July 16, 2008 6:53 PM
Backup, SQL Server 2000, VB .NET, VB.NET 2005
Catching an uncaptured error in SQL
This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM ‘Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting’ WITH ( MAXERRORS =1000, FIELDTERMINATOR = ‘^’, ROWTERMINATOR = ‘|n’ ) end END TRY BEGIN CATCH SELECT ‘Error Caught’ SELECT ERROR_MESSAGE(), ERROR_NUMBER() END CATCH Why would an error from this statement not be captured by the catch [...]
Answer Question
| July 16, 2008 6:52 PM
CSV, SQL, SQL Server errors
This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM ‘Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting’ WITH ( MAXERRORS =1000, FIELDTERMINATOR = ‘^’, ROWTERMINATOR = ‘|n’ ) end END TRY BEGIN CATCH SELECT ‘Error Caught’ SELECT ERROR_MESSAGE(), ERROR_NUMBER() END CATCH Why would an error from this statement not be captured by the catch [...]
Answer Question
| July 16, 2008 6:52 PM
CSV, SQL, SQL Server errors
failure to register an SPN
Event Type: Information Event Source: MSSQLSERVER Event Category: (2) Event ID: 26037 Date: 07/07/2008 Time: 07:37:40 User: N/A Computer: Computer name Description: The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0×2098, state: 15. Failure to register an SPN may cause integrated authentication to fall [...]
Answer Question
| July 15, 2008 11:50 AM
SPN, SQL Server errors
Event Type: Information Event Source: MSSQLSERVER Event Category: (2) Event ID: 26037 Date: 07/07/2008 Time: 07:37:40 User: N/A Computer: Computer name Description: The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0×2098, state: 15. Failure to register an SPN may cause integrated authentication to fall [...]
Answer Question
| July 15, 2008 11:50 AM
SPN, SQL Server errors
How to find out what is happening in a Database?
We have an old server that runs SQL Server 7 on an NT system. One database has processes running that are not documented. I have written triggers to report any deletions, inserts or updates made against the database’s tables. All I can report is that an insert, update or delete has occurred, the Date and [...]
Answer Question
| July 15, 2008 11:01 PM
SQL Server, SQL Server logs, Temp Tables, Triggers, Unknown processes
We have an old server that runs SQL Server 7 on an NT system. One database has processes running that are not documented. I have written triggers to report any deletions, inserts or updates made against the database’s tables. All I can report is that an insert, update or delete has occurred, the Date and [...]
Answer Question
| July 15, 2008 11:01 PM
SQL Server, SQL Server logs, Temp Tables, Triggers, Unknown processes
