I would like to do real-time entry cell validation in a DataGridView. That is validate each cell immedately after it is entered. I have tried using the cell-validating event and the cell_en...
I am trying to start Distributed Transaction Coordinator in one of the node of my clustered server.
It is running in Windows Server 2003 Enterprise Edition. But I received the error mesage as...
Hello,
We're running a hosted CMS system based on ASP and SQL server 2005. Now we've encountered a typical SQL injection attack, where the "hacker" tries to execute an sql query in the quer...
Hi there, I have a series of statements that I'm placing the value of a select statement into a variable and then running an update statement. I'm having some problems with the Warning of nul...
Hiya
Think its about the 3rd time in last 12 months I've installed MS SQL Server 2005. Each time I find it hard to make an initial connection. I manage and I record the connection details a...
I'm new to SQL EXPRESS. I had it set up a month or 2 ago working fine, but now it won't work. I'm guessing it's a permissions thing b/c I get a lot of those errors in general. I also recently ...
I've installed report server but can't open the page in a browser. I get the following error:
Cannot connect to the configuration database. For tips on troubleshooting this error, search fo...
What is the main difference between a clustered and non-clustered index
1) Using Fill method of DataAdapter, opens SqlConnection and closes it after the query is executed. While using SqlCommand, we need to explicitly open and close SqlConnection. I want the SqlCo...
Hi,
Using SQL Server Management Studio to create and run backup jobs with a full backup of all databases running nightly, Hourly Differential backups and logs every 15 minutes.
The daily...
I have a log file that has grown to 18gb and I am afraid to leave for the weekend without doing something about it. We only have 10 gb of space left on the SQL Server c:\. I have my it guys ...
Quick question. Here's how I'm trying to send a text value into a SQL Stored Procedure for a LIKE query. I can't seem to figure out how / where to put my quotes to get a proper string to SQL...
which the data type equivalent to double (access) in sql 2005, the decimal or numeric?
Pertaining to question
http://www.experts-exchange.com/Database/Miscellaneous/Q_22398914.html,
I would like to generate the script from C#. How can I achive this?
Hi,
How can i insert single quotes in databse,if i am trying to insert i am getting error like Incorrect syntax near 's'. Unclosed quotation mark after the character string .
Users are...
I need help on how to append data in an excel spreadsheet to a sql server 2005 datatable.
Thanks
I'm getting the following error when I try to access the http://localhost/Reports/ and http://localhost/reportserver/ web pages on SQL Server 2005 Reporting Services (running on Vista Ultimate...
I could change the default database file location to other drive (not c: drive) for user databases. But how to change the default database file location to other drive for system databases dur...
I have a SQL Server 2005 instance running on a server called MSSMLBIZ. On this host machine I have enabled named pipes, enabled TCP/IP, set the port to be 5356, run the Surface Area Configura...
When I try to capture the result set from sp_help_job using the following statement, it works fine:
INSERT dbname.dbo.tablename
EXEC [LinkedServer\Instance].msdb.dbo.sp_help_job @execution...
When I try to open Microsoft SQL Management Studio I receive the above error. This has just happened recently but i'm not sure what caused it.
I'm not sure if this is causing it but when I...
I have a lot of database files on my SQL server hard drive that I need to delete as the SQL database has either been removed or put out of service. As this was not done when the database was ...
I have a need to run SFTP (SSH FTP), Admin likes psftp (type "putty" at the Google prompt. First choice).
Seems simple enough. Use the Execute Process Task to execute psftp.exe and pass ...
I have a store in which I want to check to see whether a parameter is not null. if its not null i want to continue. whats the correct syntax to check for not null.
I want to know correct sy...
Hi,
I have a situation like this.I have a user login data table called LogTable where i have a set of Login, Logout date time details against a particular userid.The structure of LogTabl...
