I would like to create a simple stored procedure in SQL Server 2005, where there is one argument used as a search string for a LIKE clause. For example to run it I would like to type spFindThis 'partoffilename' Where the search string would get inserted into a query such as SELECT * FROM TheTable...

We have requirement like, we are using pocket PC(Touch Screen, OS: Win CE.Net 4.2 with Processor: Intel XScale PXA255, 400MHz) web application, want to sing on the Pocket PC surface using stylus/pen that should be save in Oracle Database and when ever we want/require we have to get from the database...

This Security update for SQL Server 2005 Service Pack 2 will not update. In the system event log it is error 0x80070643 and event ID 20. There is also a Security update for >NET Framework 2.0 that will not install with the same rror code and ID.

I have some code where I am getting information about folders. The one I can't figure out is how to get the size of the directory. How would I do this? Thanks Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: Dim getInfo As System.IO.DirectoryInfo getInfo = My.Computer.FileSystem.GetDirectoryInfo...

The Windows authentication automatically defaults to computername\username. It doesn't let me change it to just username. How can I fix?

We installed some updates to our server which is a Windows Server 2003 server. After that happened we are getting this error when trying to build a project in Visual Studio 2005 Team Suite: The "ConvertToAbsolutePath" task was not found. Check the following: 1.) The name of the task in the...

I have a scenario where I need to ensure that my clients get a daily update of a SQL Server 2005 database. Their server will be SQL Server 2005 as well. What is the best replication model to accomplish this, given that the replication will have to cross firewalls, internet, etc?

I am planning to upgrade my Visual Source Safe 6.0 to Visual Source Safe 2005. Just want to know what problems I should anticipate in such an upgrade if there is any one out there that has already tried. I have my current source safe database with all my files and would like to keep all the history and...

I am trying to restore a SQL server 2005 database to a new database but it is always failing with the following error message: "Restored failed for the server '...' Additional Information: An exception occurred while executing Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo...

I have just installed the Visual Studio 2005 Professional trial. It works fine except when I try to start debugging it gives me the following error: "Error while trying to run project: Unable to start debugging" "The stub received bad data." I have uninstalled and reinstalled. Computer...