Windows XP virus Query!
I’ve found this approach helpful in many cases. Boot the machine in Safe Mode (w/NO network support) and log in as administrator. Then go to the folder(s) in question and take ownership, and force that change to propagate. Because the permissions can be tightly locked by some of these pests, you may have to do [...]
View Answer
| January 30, 2012 8:45 AM
Access, Availability, Bandwidth, Desktops, Hardware, Interoperability, Management, Microsoft Office, Microsoft Windows, Networking, OS, Security, Servers, Software, SQL Server, Tech support
I’ve found this approach helpful in many cases. Boot the machine in Safe Mode (w/NO network support) and log in as administrator. Then go to the folder(s) in question and take ownership, and force that change to propagate. Because the permissions can be tightly locked by some of these pests, you may have to do [...]
View Answer
| January 30, 2012 8:45 AM
Access, Availability, Bandwidth, Desktops, Hardware, Interoperability, Management, Microsoft Office, Microsoft Windows, Networking, OS, Security, Servers, Software, SQL Server, Tech support
Will defragmenting hard disks improve SQL Server performance?
Yes it can, however the benefit will probably be minimal. It will be a great amount of help for a data warehouse, but for OLTP applications the data will be so fragmented throughout the file, that defragmenting the file on the drive will only provide a minimal amount of assistance. More is gained by making [...]
View Answer
| January 30, 2012 8:40 AM
Defragment, Disk drives, SQL Server performance tuning
Yes it can, however the benefit will probably be minimal. It will be a great amount of help for a data warehouse, but for OLTP applications the data will be so fragmented throughout the file, that defragmenting the file on the drive will only provide a minimal amount of assistance. More is gained by making [...]
View Answer
| January 30, 2012 8:40 AM
Defragment, Disk drives, SQL Server performance tuning
USB External Hard drive and Windows XP
You might want to check in disk management and see if the system is seeing the drive and what drive letter is assigned – Windows tries to assign the next drive letter – even if it’s already assigned to something. If you see the drive in Disk Management – then just assign it a different [...]
View Answer
| April 19, 2013 8:28 AM
Adapters/Interfaces, Billing and customer care, Billing Support Systems, Desktops, Development, Disk drives, Fibre channel, Hardware, Management, Microsoft Windows, OS, Security, Servers, SQL Server
You might want to check in disk management and see if the system is seeing the drive and what drive letter is assigned – Windows tries to assign the next drive letter – even if it’s already assigned to something. If you see the drive in Disk Management – then just assign it a different [...]
View Answer
| April 19, 2013 8:28 AM
Adapters/Interfaces, Billing and customer care, Billing Support Systems, Desktops, Development, Disk drives, Fibre channel, Hardware, Management, Microsoft Windows, OS, Security, Servers, SQL Server
SQL Server 2005 backup server
Yes. You should be looking at database mirroring. It is a native feature of SQL Server 2005 and higher and will keep an exact duplicate of the database on the second server. =========== It is possible to replicated and SQL server to another by using a third party software. However, you have to research for [...]
View Answer
| January 30, 2012 8:22 AM
Backup, Backup and Recovery Hardware, SQL 2005, SQL Backup, SQL Server 2005, SQL Server database
Yes. You should be looking at database mirroring. It is a native feature of SQL Server 2005 and higher and will keep an exact duplicate of the database on the second server. =========== It is possible to replicated and SQL server to another by using a third party software. However, you have to research for [...]
View Answer
| January 30, 2012 8:22 AM
Backup, Backup and Recovery Hardware, SQL 2005, SQL Backup, SQL Server 2005, SQL Server database
Report from check disk on active NTFS partition
In the event log. The name on the event will be: winlogon this will be found in the system event log. === Event log is also possible to record the checkdisk execution of your computer system. However, the best thing you can do is to perform a regular checkdisk scan to avoid any future problem [...]
View Answer
| January 30, 2012 8:17 AM
DataCenter, Desktops, Disk drives, Hardware, Management, Microsoft Windows, OS, Security, Servers, Software, SQL Server, Storage, Storage products and equipment, Storage servers, Tech support
In the event log. The name on the event will be: winlogon this will be found in the system event log. === Event log is also possible to record the checkdisk execution of your computer system. However, the best thing you can do is to perform a regular checkdisk scan to avoid any future problem [...]
View Answer
| January 30, 2012 8:17 AM
DataCenter, Desktops, Disk drives, Hardware, Management, Microsoft Windows, OS, Security, Servers, Software, SQL Server, Storage, Storage products and equipment, Storage servers, Tech support
Automated Query iSQL
You can schedule tasks in Windows XP using the task scheduler and here is a link to a Microsoft technet article that shows you how to schedule recurring tasks/jobs – http://support.microsoft.com/kb/308569. All you need to do is put your iSQL commands in a DOS command shell script and schedule the script to run or schedule [...]
View Answer
| January 29, 2012 12:47 PM
Automated SQL Query, isql, SQL
You can schedule tasks in Windows XP using the task scheduler and here is a link to a Microsoft technet article that shows you how to schedule recurring tasks/jobs – http://support.microsoft.com/kb/308569. All you need to do is put your iSQL commands in a DOS command shell script and schedule the script to run or schedule [...]
View Answer
| January 29, 2012 12:47 PM
Automated SQL Query, isql, SQL
Open IT Forum: What do you want to see from IT Knowledge Exchange in 2012?
Some hot topics I would like to know more about are Virtual Desktop technologies (VDI), SQL Server 2012, and Cloud Computing. It would also be nice to be able to search across all TechTarget Search*.com sites at once when researching a topic. -Tech Talker
View Answer
| January 28, 2012 2:26 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Some hot topics I would like to know more about are Virtual Desktop technologies (VDI), SQL Server 2012, and Cloud Computing. It would also be nice to be able to search across all TechTarget Search*.com sites at once when researching a topic. -Tech Talker
View Answer
| January 28, 2012 2:26 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Compressing Old Files
Hi there, I have been working with PC’s for a long time and I have been compressing files through disk cleanup with no problems at all. When I re-format a machine I also have no problems. I would recommend you do this on a regular basis to keep your machine operational and responsive. Compression does [...]
View Answer
| January 26, 2012 11:16 AM
Access, Adapters/Interfaces, Administration, Backup & recovery, Business/IT alignment, Career development, Certifications, CRM, Data analysis, Data management and storage, Data mining/analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, Disk drives, E-business, Ecommerce applications, Exchange, Exchange security, Fax and print management, File, Hardware, Hardware selection and management, Management, Microsoft Windows, Monitoring, Online transaction processing, Oracle, OS, Patch management, PC/Windows Connectivity, Performance and availability, Project management, Replication, Sales force automation applications, Security, Servers, Software, Spam, SQL Server, Storage, Storage management, Storage products and equipment, Storage servers, Systems management software, Tape drives/Libraries, Tech support, Training, Web development
Hi there, I have been working with PC’s for a long time and I have been compressing files through disk cleanup with no problems at all. When I re-format a machine I also have no problems. I would recommend you do this on a regular basis to keep your machine operational and responsive. Compression does [...]
View Answer
| January 26, 2012 11:16 AM
Access, Adapters/Interfaces, Administration, Backup & recovery, Business/IT alignment, Career development, Certifications, CRM, Data analysis, Data management and storage, Data mining/analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, Disk drives, E-business, Ecommerce applications, Exchange, Exchange security, Fax and print management, File, Hardware, Hardware selection and management, Management, Microsoft Windows, Monitoring, Online transaction processing, Oracle, OS, Patch management, PC/Windows Connectivity, Performance and availability, Project management, Replication, Sales force automation applications, Security, Servers, Software, Spam, SQL Server, Storage, Storage management, Storage products and equipment, Storage servers, Systems management software, Tape drives/Libraries, Tech support, Training, Web development
What are basic differences between SQL Server 2000 and 2005?
Following are the some major differences between the two versions:- (PG) The most significant change is the .NET integration with SQL SERVER 2005. Stored procedures, User-defined functions, triggers, aggregates, and user- defined types can now be written using your own favorite .NET language (VB.NET, C#, J# etc .). This support was not there in SQL [...]
View Answer
| January 25, 2012 10:02 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades
Following are the some major differences between the two versions:- (PG) The most significant change is the .NET integration with SQL SERVER 2005. Stored procedures, User-defined functions, triggers, aggregates, and user- defined types can now be written using your own favorite .NET language (VB.NET, C#, J# etc .). This support was not there in SQL [...]
View Answer
| January 25, 2012 10:02 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades
Filtering a select based on the value of one column and the max value of another column
You are probably going to need a sub-select. Here are a couple of possible options, although the syntax from the first example might not be supported on your database platform: <pre>SELECT * FROM temp WHERE (so_id,seq_id) IN (SELECT so_id,MAX(seq_id) FROM temp GROUP BY so_id) AND act_code = ‘C’;</pre> <pre>SELECT t.* FROM temp t JOIN (SELECT [...]
View Answer
| January 25, 2012 6:57 PM
SELECT, Temp Tables
You are probably going to need a sub-select. Here are a couple of possible options, although the syntax from the first example might not be supported on your database platform: <pre>SELECT * FROM temp WHERE (so_id,seq_id) IN (SELECT so_id,MAX(seq_id) FROM temp GROUP BY so_id) AND act_code = ‘C’;</pre> <pre>SELECT t.* FROM temp t JOIN (SELECT [...]
View Answer
| January 25, 2012 6:57 PM
SELECT, Temp Tables
Failed ODBC USER DSN connection to SQL Server 2005
<a href=”http://computerallofsolution.blogspot.com/”>
View Answer
| January 20, 2012 4:11 AM
SQL Server 2005, VB.NET
<a href=”http://computerallofsolution.blogspot.com/”>
View Answer
| January 20, 2012 4:11 AM
SQL Server 2005, VB.NET
Why can’t I connect to SQL Server 2005 through ODBC ?
Your connection string should look something like this. <pre>Provider=SQLNCLI;Server=backend;Database=zkp_database;Uid=myUsername; Pwd=myPassword;</pre> Don’t bother with the SQL Alias. When you use this connection string what is the error message that you are getting?
View Answer
| January 19, 2012 10:59 PM
ASP, ODBC Microsoft Access Driver Login Failed, SQL Server 2005 connectivity
Your connection string should look something like this. <pre>Provider=SQLNCLI;Server=backend;Database=zkp_database;Uid=myUsername; Pwd=myPassword;</pre> Don’t bother with the SQL Alias. When you use this connection string what is the error message that you are getting?
View Answer
| January 19, 2012 10:59 PM
ASP, ODBC Microsoft Access Driver Login Failed, SQL Server 2005 connectivity
How can do iSQl*Plus login for DBA
Oracle stopped supporting iSQL*Plus starting with Oracle11g. I would recommend switching to SQL Developer which can be downloaded for free from http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html. SQL Developer can do all of the same things iSQL*Plus can do, plus more. There are other third-party Oracle DBA/Developer tools available for purchase which I will not promote in this post, but [...]
View Answer
| January 17, 2012 7:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
Oracle stopped supporting iSQL*Plus starting with Oracle11g. I would recommend switching to SQL Developer which can be downloaded for free from http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html. SQL Developer can do all of the same things iSQL*Plus can do, plus more. There are other third-party Oracle DBA/Developer tools available for purchase which I will not promote in this post, but [...]
View Answer
| January 17, 2012 7:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
Two SQL (2005 and 2008) on the same machine.
There is no problem running one instance of SQL Server 2005 and one instance of SQL Server 2008 on the same machine. My laptop has both running on it and has since Beta 3 or so of SQL Server 2008. The only thing you will need to worry about is setting up each instance so [...]
View Answer
| January 17, 2012 9:49 AM
SQL Server 2005, SQL Server 2008
There is no problem running one instance of SQL Server 2005 and one instance of SQL Server 2008 on the same machine. My laptop has both running on it and has since Beta 3 or so of SQL Server 2008. The only thing you will need to worry about is setting up each instance so [...]
View Answer
| January 17, 2012 9:49 AM
SQL Server 2005, SQL Server 2008
Best book for SQL Server
I would recommend SQL Server 2008 Administration in Action ( http://www.amazon.com/gp/reader/193398872X/ref=sib_dp_pt#reader-link) and SQL Server 2008 Management and Administration ( http://www.amazon.com/gp/product/067233044X?ie=UTF8&tag=brozsqseex-20&linkCode=as2&camp=1789&creative=390957&creativeASIN=067233044X). My SQL Server DBAs use both of these books.
View Answer
| January 16, 2012 10:30 PM
IT Books, SQL Server, SQL Server business intelligence
I would recommend SQL Server 2008 Administration in Action ( http://www.amazon.com/gp/reader/193398872X/ref=sib_dp_pt#reader-link) and SQL Server 2008 Management and Administration ( http://www.amazon.com/gp/product/067233044X?ie=UTF8&tag=brozsqseex-20&linkCode=as2&camp=1789&creative=390957&creativeASIN=067233044X). My SQL Server DBAs use both of these books.
View Answer
| January 16, 2012 10:30 PM
IT Books, SQL Server, SQL Server business intelligence
SQL Server Logins
SQL Server 2000 is case insensitive by default due to collation and sort order. You can change collation after setup but it is important to use the correct collation settings and you must rebuild the databases and reload the data. It is also recommended that you develop a standard within your organization for these options [...]
View Answer
| January 15, 2012 1:12 AM
SQL 2000, SQL Logins, SQL Server 2000, SQL Server Password Management, SQL Server Passwords
SQL Server 2000 is case insensitive by default due to collation and sort order. You can change collation after setup but it is important to use the correct collation settings and you must rebuild the databases and reload the data. It is also recommended that you develop a standard within your organization for these options [...]
View Answer
| January 15, 2012 1:12 AM
SQL 2000, SQL Logins, SQL Server 2000, SQL Server Password Management, SQL Server Passwords
Crystal Reports XI period in database name
We ran into the same problem and the only fix we could find was to recreate the database without the “.’ In the name. It is a bad DBA practice to use special characters in the database name. The best solution would be to rename the database. You don’t need to delete and then create [...]
View Answer
| January 13, 2012 8:27 PM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
We ran into the same problem and the only fix we could find was to recreate the database without the “.’ In the name. It is a bad DBA practice to use special characters in the database name. The best solution would be to rename the database. You don’t need to delete and then create [...]
View Answer
| January 13, 2012 8:27 PM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
Execute SQL SELECT via RUNSQLSTM error
If you are just selecting records from a file, you cannot use SELECT if you are using RUNSQLSTM. If you are doing a different function such as INSERT or DELETE and basing this off of a selection from a different file, then you can use SELECT. I put a simple statement in a soiurce member [...]
View Answer
| January 11, 2012 5:11 PM
RUNSQLSTM, SELECT statement, SQL
If you are just selecting records from a file, you cannot use SELECT if you are using RUNSQLSTM. If you are doing a different function such as INSERT or DELETE and basing this off of a selection from a different file, then you can use SELECT. I put a simple statement in a soiurce member [...]
View Answer
| January 11, 2012 5:11 PM
RUNSQLSTM, SELECT statement, SQL
Replication and run backups
You can run replication and backups on the same database. Both publications and subscriptions can be backed up You likely don’t need a backup up of the subscription database unless it contains objects that are not on the publication database. Backups are essential for disaster recovery. Backups also help limit the database log file size. [...]
View Answer
| January 6, 2012 4:05 AM
Backup, Replication, SQL 2008
You can run replication and backups on the same database. Both publications and subscriptions can be backed up You likely don’t need a backup up of the subscription database unless it contains objects that are not on the publication database. Backups are essential for disaster recovery. Backups also help limit the database log file size. [...]
View Answer
| January 6, 2012 4:05 AM
Backup, Replication, SQL 2008
MSSQL 2008 sudden and drastical slow down – IT telephony
I realize that this question was posted a while ago and that you have probably already corrected this issue, but in case you have not or others are having a similar problem, you should try re-indexing the database tables and updating statistics on tables which generally addresses the type of problem you have described. There [...]
View Answer
| January 5, 2012 3:58 AM
MS SQL Server, MSSQL, SQL 2008, SQL Server
I realize that this question was posted a while ago and that you have probably already corrected this issue, but in case you have not or others are having a similar problem, you should try re-indexing the database tables and updating statistics on tables which generally addresses the type of problem you have described. There [...]
View Answer
| January 5, 2012 3:58 AM
MS SQL Server, MSSQL, SQL 2008, SQL Server
