Get your FREE ITKnowledgeExchange.com sticker
Be proud to show off you are part of the community with your free ITKnowledgeExchange.com sticker. All you have to do is answer a question and email me your handle and address and we will get one out in the mail to you. Allow 4-6 weeks delivery. Even if you have one already get one [...]
Answer Question
| September 1, 2011 3:15 PM
CIO, CRM, Database, DataCenter, Domino, Exchange, Linux, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, Virtual Server, VoIP, Windows
Be proud to show off you are part of the community with your free ITKnowledgeExchange.com sticker. All you have to do is answer a question and email me your handle and address and we will get one out in the mail to you. Allow 4-6 weeks delivery. Even if you have one already get one [...]
Answer Question
| September 1, 2011 3:15 PM
CIO, CRM, Database, DataCenter, Domino, Exchange, Linux, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, Virtual Server, VoIP, Windows
Date calculation incorrect in sql when +1 month entered
Date calculation incorrect in sql when 1 month entered. If we add 1 month to 28-Feb then it shows 28-Mar instead of 31-Mar. Similarly if I add 1 month to 30-Nov it should show 31-Dec instead of 30-Dec. SQL command run is SELECT CCDATE + 1 MONTHS FROM COGNOSMIS/xyzPF WHERE CCDATE = ’2010-02-28′
Answer Question
| March 26, 2010 12:31 PM
SQL, SQL Date Calculation
Date calculation incorrect in sql when 1 month entered. If we add 1 month to 28-Feb then it shows 28-Mar instead of 31-Mar. Similarly if I add 1 month to 30-Nov it should show 31-Dec instead of 30-Dec. SQL command run is SELECT CCDATE + 1 MONTHS FROM COGNOSMIS/xyzPF WHERE CCDATE = ’2010-02-28′
Answer Question
| March 26, 2010 12:31 PM
SQL, SQL Date Calculation
Problems with SQL communications over ISDN
We have upgraded a number of Windows XP clients (from MSDE 1 to MSDE 2000) which interact with a clustered SQL server 7 system (running on Windows NT server) via transactional replication. Our problem is that these clients are connected over ISDN dial up lines and since the upgrade we have noted a significant increase [...]
Answer Question
| March 24, 2010 11:39 AM
ISDN, MSDE, SQL Server, Windows NT, Windows XP Professional
We have upgraded a number of Windows XP clients (from MSDE 1 to MSDE 2000) which interact with a clustered SQL server 7 system (running on Windows NT server) via transactional replication. Our problem is that these clients are connected over ISDN dial up lines and since the upgrade we have noted a significant increase [...]
Answer Question
| March 24, 2010 11:39 AM
ISDN, MSDE, SQL Server, Windows NT, Windows XP Professional
Email sp_who2 on lock/wait sql server 2008
I have an alert set up to run a stored proc that will email me the results of a sp_who2 when the Lock Waits/sec rises above 2 seconds. The problem is that the alert doesn’t fire off until after the lock has cleared, so the results of the sp_who2 are not very useful because they [...]
Answer Question
| April 15, 2011 9:10 PM
SQL Server 2008, SQL Server 2008 administration
I have an alert set up to run a stored proc that will email me the results of a sp_who2 when the Lock Waits/sec rises above 2 seconds. The problem is that the alert doesn’t fire off until after the lock has cleared, so the results of the sp_who2 are not very useful because they [...]
Answer Question
| April 15, 2011 9:10 PM
SQL Server 2008, SQL Server 2008 administration
How do i recover the DB from suspect mode in sqlserver 2000?
I have a database that went to suspect mode in sqlserver 2000.How do i recover the DB from suspect without restore the DB?
Answer Question
| March 22, 2010 4:15 PM
Database, SQL Server 2000, SQL Server 2000 Suspect Mode
I have a database that went to suspect mode in sqlserver 2000.How do i recover the DB from suspect without restore the DB?
Answer Question
| March 22, 2010 4:15 PM
Database, SQL Server 2000, SQL Server 2000 Suspect Mode
Automate TSQL Query Output
I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?
Answer Question
| June 1, 2010 1:14 PM
Automated SQL Query, SQL, T-SQL
I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?
Answer Question
| June 1, 2010 1:14 PM
Automated SQL Query, SQL, T-SQL
How to extract key phrases from a log file using a batch file.
How can I extract key phrases from a log file using a batch file. I am new to this. I need to know how to extract key phrases from a log file using a batch file. I need to create the batch file first to extract the phrases from the log file. I don’t need to [...]
Answer Question
| March 22, 2010 1:18 AM
Performance testing, RSScripter
How can I extract key phrases from a log file using a batch file. I am new to this. I need to know how to extract key phrases from a log file using a batch file. I need to create the batch file first to extract the phrases from the log file. I don’t need to [...]
Answer Question
| March 22, 2010 1:18 AM
Performance testing, RSScripter
Local clients loose connection to local SQL Server when system network drops connection to HQ.
When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database. For some clients, the application still works just fine. The clients are all set up and authenticated in the local Domain Controller. It is my thought that the authentication [...]
Answer Question
| March 19, 2010 9:14 PM
Active Directory, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, VB
When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database. For some clients, the application still works just fine. The clients are all set up and authenticated in the local Domain Controller. It is my thought that the authentication [...]
Answer Question
| March 19, 2010 9:14 PM
Active Directory, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, VB
Adding users to my SQL Server 2008
How do I increase the number of users CAl to my SQL server 2008 Licensed by server?
Answer Question
| March 18, 2010 7:18 PM
CAL, SQL Server 2008, SQL Server licensing
How do I increase the number of users CAl to my SQL server 2008 Licensed by server?
Answer Question
| March 18, 2010 7:18 PM
CAL, SQL Server 2008, SQL Server licensing
How to Export a MS SQL Image column to a file.
I have pictures stored in a Ms Sql table in an image data type column. I want to be able to write the image(which is a JPG to a file. Is there a function in MS SQL 2005 or is another tool necessary?
Answer Question
| March 17, 2010 3:36 PM
blob data, Image databases, SQL, SQL 2005
I have pictures stored in a Ms Sql table in an image data type column. I want to be able to write the image(which is a JPG to a file. Is there a function in MS SQL 2005 or is another tool necessary?
Answer Question
| March 17, 2010 3:36 PM
blob data, Image databases, SQL, SQL 2005
create a procedure
i want to create a procedure it should be able to audit any change done in the database ie. drop/delete of schema tables. the procedure should be able write audited data into a remote server machine inaccessible by the system manager/dba.
Answer Question
| March 17, 2010 6:24 AM
DELETE statement, DROP, SQL Developer
i want to create a procedure it should be able to audit any change done in the database ie. drop/delete of schema tables. the procedure should be able write audited data into a remote server machine inaccessible by the system manager/dba.
Answer Question
| March 17, 2010 6:24 AM
DELETE statement, DROP, SQL Developer
SQL Table Layout
Hi I am creating a database. In my legacy system I had what we called a tables system where coded data could be expanded into different values eg 0 = No 1 = Yes I tried to create this in SQL by having a properties table and then relating the other tables to the [...]
Answer Question
| March 17, 2010 4:25 AM
SQL 2005, SQL tables
Hi I am creating a database. In my legacy system I had what we called a tables system where coded data could be expanded into different values eg 0 = No 1 = Yes I tried to create this in SQL by having a properties table and then relating the other tables to the [...]
Answer Question
| March 17, 2010 4:25 AM
SQL 2005, SQL tables
SQL find duplicates SQL Server 2008
Up against a SQL question that is difficult to code. Any help is greatly appreciated.
Answer Question
| March 22, 2010 8:47 PM
SQL Find, SQL Server, SQL Server 2008
Up against a SQL question that is difficult to code. Any help is greatly appreciated.
Answer Question
| March 22, 2010 8:47 PM
SQL Find, SQL Server, SQL Server 2008
What is the easiest and best Front End development for SQL server.
What is the easiest and best Front End development for SQL server. I have Visual Studio 2008 Professional IDE. VB.net or VB.
Answer Question
| March 15, 2010 6:21 PM
SQL Server 2008, VB, VB.NET, Visual Studio 2008 Professional
What is the easiest and best Front End development for SQL server. I have Visual Studio 2008 Professional IDE. VB.net or VB.
Answer Question
| March 15, 2010 6:21 PM
SQL Server 2008, VB, VB.NET, Visual Studio 2008 Professional
Resources for learning about SQL Servers
can some one teach me this
Answer Question
| March 16, 2010 12:28 PM
SQL Server
can some one teach me this
Answer Question
| March 16, 2010 12:28 PM
SQL Server
ORA-06550: line 224, column 7: error running in SQLPLUS
Im getting the following error when running the code below: SQL> @n377d_load_tfdscpm_sxb.sql exception * ERROR at line 224: ORA-06550: line 224, column 7: PLS-00103: Encountered the symbol “EXCEPTION” when expecting one of the following: begin case declare end exit for goto if loop mod null pragma raise return select update while with <an [...]
Answer Question
| April 7, 2010 1:13 AM
ORA-06550, Oracle Error Codes, PL/SQL, SQL Execution
Im getting the following error when running the code below: SQL> @n377d_load_tfdscpm_sxb.sql exception * ERROR at line 224: ORA-06550: line 224, column 7: PLS-00103: Encountered the symbol “EXCEPTION” when expecting one of the following: begin case declare end exit for goto if loop mod null pragma raise return select update while with <an [...]
Answer Question
| April 7, 2010 1:13 AM
ORA-06550, Oracle Error Codes, PL/SQL, SQL Execution
SQL Server memory usage
I have a situation where a total of 13 GB RAM is being used by SQL server. Is there any way I can break down the 13 GB usage by application? Is there any data or technique which could be used?
Answer Question
| March 15, 2010 6:34 PM
RAM chip numbers, SQL Server, SQL Server memory, SQL Server performance
I have a situation where a total of 13 GB RAM is being used by SQL server. Is there any way I can break down the 13 GB usage by application? Is there any data or technique which could be used?
Answer Question
| March 15, 2010 6:34 PM
RAM chip numbers, SQL Server, SQL Server memory, SQL Server performance
Moving Distribution database from an instance to antother does increase performance ?
The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some collisions between users (through application) and the [...]
Answer Question
| March 15, 2010 10:49 AM
distrib.exe, Performance/Tuning, SQL Server 2005, SQL Server Performance Monitoring, transaction replication
The Publisher database is in use by nearly 300 users with a trafic of about 340trans/sec. After adding replicas with a [strong]push[/strong] subscription (transaction replication with queue mngmt) to 1 subscriber (15 users) the CPU need on the server moved from 25% to about 55% and I can see some collisions between users (through application) and the [...]
Answer Question
| March 15, 2010 10:49 AM
distrib.exe, Performance/Tuning, SQL Server 2005, SQL Server Performance Monitoring, transaction replication
Encrypting passwords on SQL server 2000
I m using SQL server 2000 and I want to use a password field for Employee Master. My question is how to encrypt this password field in my insert query. I have heard about the “EncryptByPassPhrase” function and symmetric key, but it is provided from SQL Server 2005. I have tried using pwdencrypt which is [...]
Answer Question
| March 19, 2010 7:00 PM
Encryption, Password, Password field, SQL Server 2000
I m using SQL server 2000 and I want to use a password field for Employee Master. My question is how to encrypt this password field in my insert query. I have heard about the “EncryptByPassPhrase” function and symmetric key, but it is provided from SQL Server 2005. I have tried using pwdencrypt which is [...]
Answer Question
| March 19, 2010 7:00 PM
Encryption, Password, Password field, SQL Server 2000
Running SQL Server 2000 and 2005 simultaneously
When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?
Answer Question
| March 12, 2010 6:51 PM
Performance/Tuning, SQL Server 2000, SQL Server 2005
When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?
Answer Question
| March 12, 2010 6:51 PM
Performance/Tuning, SQL Server 2000, SQL Server 2005
