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
It should go fairly smoothly.
View Answer | September 20, 2008 11:09 PM
SQL 2005, SQL Server clustering, SQL Server upgrades
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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