Storing text documents in tables in SQL Server 2005
Check the full text index properties and see if the document has been added to the index or not. It can take some time for the data to be added to the index. Documents are not added to the index at the same time that they are added to the table.
View Answer
| September 20, 2008 11:10 PM
Microsoft Word, Notepad, SQL Server 2005, Storage
Check the full text index properties and see if the document has been added to the index or not. It can take some time for the data to be added to the index. Documents are not added to the index at the same time that they are added to the table.
View Answer
| September 20, 2008 11:10 PM
Microsoft Word, Notepad, SQL Server 2005, Storage
clustered sql 2000 to sql 2005 upgrade
It should go fairly smoothly.
View Answer
| September 20, 2008 11:09 PM
SQL 2005, SQL Server clustering, SQL Server upgrades
It should go fairly smoothly.
View Answer
| September 20, 2008 11:09 PM
SQL 2005, SQL Server clustering, SQL Server upgrades
Unable to Restore Backup in SQL Server 2005
It looks correct from here. Use SQL Profiler and see what it says as far as the actual command which is being run. What’s the error message which is being returned?
View Answer
| September 20, 2008 11:07 PM
SQL Server 2000, SQL Server 2005, SQL Server backup, VB.NET
It looks correct from here. Use SQL Profiler and see what it says as far as the actual command which is being run. What’s the error message which is being returned?
View Answer
| September 20, 2008 11:07 PM
SQL Server 2000, SQL Server 2005, SQL Server backup, VB.NET
Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices
Try reinstalling the client tools and reapplying the latest service pack and hotfix. This should force all the dlls to be re-registered.
View Answer
| September 20, 2008 11:06 PM
Business Intelligence, SQL error messages, SQL Server, SSIS
Try reinstalling the client tools and reapplying the latest service pack and hotfix. This should force all the dlls to be re-registered.
View Answer
| September 20, 2008 11:06 PM
Business Intelligence, SQL error messages, SQL Server, SSIS
must Access be installed to use Analysis Server
Shouldn’t need to have access installed, but it may not be pointing to the correct place.
View Answer
| September 20, 2008 11:03 PM
Analysis Manager, Database, Microsoft Access, SQL Server
Shouldn’t need to have access installed, but it may not be pointing to the correct place.
View Answer
| September 20, 2008 11:03 PM
Analysis Manager, Database, Microsoft Access, SQL Server
Error when using Microsoft OLE DB for Oracle in DTS Package
When you run the job manually are you doing it on the servers console or on your workstation? Can you use the Oracle tools to connect to the Oracle server manually? Microsoft KB Article <a href=”http://support.microsoft.com/kb/255084″>255084</a> should help you out.
View Answer
| September 20, 2008 11:01 PM
DTS Package Scheduled Task, Oracle
When you run the job manually are you doing it on the servers console or on your workstation? Can you use the Oracle tools to connect to the Oracle server manually? Microsoft KB Article <a href=”http://support.microsoft.com/kb/255084″>255084</a> should help you out.
View Answer
| September 20, 2008 11:01 PM
DTS Package Scheduled Task, Oracle
Infopath Library
If you get can ODBC or OLEDB drivers for InfoPath you can use DTS (SQL 2000) or SSIS (SQL 2005+) to import the data into the SQL Database.
View Answer
| September 20, 2008 10:53 PM
Infopath, InfoPath form library, SQL Database
If you get can ODBC or OLEDB drivers for InfoPath you can use DTS (SQL 2000) or SSIS (SQL 2005+) to import the data into the SQL Database.
View Answer
| September 20, 2008 10:53 PM
Infopath, InfoPath form library, SQL Database
Maintaining a company table in SQL
It really depends on how you are going to be querying the data. If you will be usually querying the budget and the sales information together then store it together. If you will to querying the data separately then overall performance will be improved by storing them separately.
View Answer
| September 20, 2008 10:06 PM
SQL, SQL tables
It really depends on how you are going to be querying the data. If you will be usually querying the budget and the sales information together then store it together. If you will to querying the data separately then overall performance will be improved by storing them separately.
View Answer
| September 20, 2008 10:06 PM
SQL, SQL tables
Creating database access at runtime for ADO and SQL Server
You will want to use basically the same code, but with a different connection string. Check our <a href=”http://www.connectionstrings.com”>connectionstrings.com</a> for all the options in the connection string.
View Answer
| September 20, 2008 9:54 PM
ADO, SQL Server database
You will want to use basically the same code, but with a different connection string. Check our <a href=”http://www.connectionstrings.com”>connectionstrings.com</a> for all the options in the connection string.
View Answer
| September 20, 2008 9:54 PM
ADO, SQL Server database
Creating a table with three fields in SQL
AFAIK it is not possible to define a check constraint that makes counts of the table records. I think you will need to put this validations on the data entering application, and I would suggest this value (2) being stored on the database, so the app doesn’t need to be modified if this policy changes. [...]
View Answer
| September 19, 2008 7:46 PM
SQL tables
AFAIK it is not possible to define a check constraint that makes counts of the table records. I think you will need to put this validations on the data entering application, and I would suggest this value (2) being stored on the database, so the app doesn’t need to be modified if this policy changes. [...]
View Answer
| September 19, 2008 7:46 PM
SQL tables
For Save .doc file in Sql Server 2000
Create a table with a column of the IMAGE data type. You can upload the binary data of the file into this field to save the file. You will need to write a client application in a language like VB.NET, C#, C++, etc to take the actual file and load it into th database.
View Answer
| September 19, 2008 6:19 PM
Microsoft Word, SQL Server 2000, SQL Server import/export
Create a table with a column of the IMAGE data type. You can upload the binary data of the file into this field to save the file. You will need to write a client application in a language like VB.NET, C#, C++, etc to take the actual file and load it into th database.
View Answer
| September 19, 2008 6:19 PM
Microsoft Word, SQL Server 2000, SQL Server import/export
Upgrading from SQL Server 2000 to SQL Server 2005
AFAIK SQL Server 2005 <b>Express Edition</b> is a free product, so maybe what they are offering for free is the upgrade process itself. I think you should not have network problems (just be sure to enable network connectivity, because I think these settings are turned off by default in that version), but might want to [...]
View Answer
| September 19, 2008 6:14 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades
AFAIK SQL Server 2005 <b>Express Edition</b> is a free product, so maybe what they are offering for free is the upgrade process itself. I think you should not have network problems (just be sure to enable network connectivity, because I think these settings are turned off by default in that version), but might want to [...]
View Answer
| September 19, 2008 6:14 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades
Checking for a transaction isolation level in SQL Server Profiler
Look for the “SET TRANSACTION ISOLATION LEVEL” command in the profiler trace.
View Answer
| September 19, 2008 6:11 PM
Isolation level, LINQ, SQL Server Profiler, SQL statements
Look for the “SET TRANSACTION ISOLATION LEVEL” command in the profiler trace.
View Answer
| September 19, 2008 6:11 PM
Isolation level, LINQ, SQL Server Profiler, SQL statements
Questions about a SQL database with hourly transaction log backups
No transaction logs are not cumulative. You have to keep each log backup taken between the full backups. It is actually recommended to keep a couple of cycles worth of log files. Your cycle is daily, so I would recommend keeping 2-3 days worth of log file backups.
View Answer
| September 19, 2008 6:08 PM
SQL, SQL Database, SQL Server backup, SQL transaction logs
No transaction logs are not cumulative. You have to keep each log backup taken between the full backups. It is actually recommended to keep a couple of cycles worth of log files. Your cycle is daily, so I would recommend keeping 2-3 days worth of log file backups.
View Answer
| September 19, 2008 6:08 PM
SQL, SQL Database, SQL Server backup, SQL transaction logs
The specified module could not be found
Since the error message does not mention what is the name of the module that could not be found, I think the first step is to find out what module is it talking about, and the “Process Monitor” from sysinternals can help on this matter. Try this: - Run Process Monitor (which can be downloaded [...]
View Answer
| September 19, 2008 4:40 PM
SQL Database, SQL Server 2000, Windows Server 2003, Windows XP
Since the error message does not mention what is the name of the module that could not be found, I think the first step is to find out what module is it talking about, and the “Process Monitor” from sysinternals can help on this matter. Try this: - Run Process Monitor (which can be downloaded [...]
View Answer
| September 19, 2008 4:40 PM
SQL Database, SQL Server 2000, Windows Server 2003, Windows XP
Improving I/O performance on SQL Server 2000
If your disk queues are that high you may need to look into adding additional disks to the server. You will also want to look at your indexing on your databases. If you don’t have the tables indexes correctly this will cause the disks to work harder than they need to. He is right, what [...]
View Answer
| September 19, 2008 4:14 PM
I/O errors, Performance monitoring, SQL Server 2000, SQL Server performance
If your disk queues are that high you may need to look into adding additional disks to the server. You will also want to look at your indexing on your databases. If you don’t have the tables indexes correctly this will cause the disks to work harder than they need to. He is right, what [...]
View Answer
| September 19, 2008 4:14 PM
I/O errors, Performance monitoring, SQL Server 2000, SQL Server performance
How to mark a DTS package as complete even if it errors.
I don’t remember an easy way to tell the package to fail with success instead. You could try a technique like this however. Before doing to data transformation from the text file to the database stick a SQL task before it. In that SQL task use <a href=”http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1270919,00.html”>xp_file_exists</a> to see is the file exists. If [...]
View Answer
| September 18, 2008 10:18 PM
DTS packages
I don’t remember an easy way to tell the package to fail with success instead. You could try a technique like this however. Before doing to data transformation from the text file to the database stick a SQL task before it. In that SQL task use <a href=”http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1270919,00.html”>xp_file_exists</a> to see is the file exists. If [...]
View Answer
| September 18, 2008 10:18 PM
DTS packages
Email from SQL Server Management Console
You will want to create a SQL Agent job and have that job run the sp_send_dbmail procedure to send the email. One of the parameters of that procedure is @Query which will allow you to give it a SQL Query such as “SELECT * FROM MyView” and it will email out the output from the [...]
View Answer
| September 18, 2008 8:20 PM
SQL Server Management Console
You will want to create a SQL Agent job and have that job run the sp_send_dbmail procedure to send the email. One of the parameters of that procedure is @Query which will allow you to give it a SQL Query such as “SELECT * FROM MyView” and it will email out the output from the [...]
View Answer
| September 18, 2008 8:20 PM
SQL Server Management Console
PERFORMANCE ISSUE while inserting bulk data in a blank table from 2 different tables
What does the execution plan look like? I would assume that you are missing an index on either or both tables. How do the indexes look like for these tables?
View Answer
| September 18, 2008 6:43 PM
INSERT statement, SQL Server performance tuning
What does the execution plan look like? I would assume that you are missing an index on either or both tables. How do the indexes look like for these tables?
View Answer
| September 18, 2008 6:43 PM
INSERT statement, SQL Server performance tuning
Backing up a SQL Server 2005 database on SQL Server 2000 EE
To backup your MS SQL Server 2000 database, please follow these steps: 1. Open Enterprise Manager. 2. Connect to your MS SQL Server 2000 database. 3. Right-click your database, expand All Tasks and select Backup Database. 4. Under Backup, select Database – complete. 5. Under Destination, click Add. 6. Enter the path and file name [...]
View Answer
| September 18, 2008 12:18 PM
Backup & restore, SQL Server 2000, SQL Server 2005, SQL Server backup
To backup your MS SQL Server 2000 database, please follow these steps: 1. Open Enterprise Manager. 2. Connect to your MS SQL Server 2000 database. 3. Right-click your database, expand All Tasks and select Backup Database. 4. Under Backup, select Database – complete. 5. Under Destination, click Add. 6. Enter the path and file name [...]
View Answer
| September 18, 2008 12:18 PM
Backup & restore, SQL Server 2000, SQL Server 2005, SQL Server backup
