How can I get past this problem?
The database server has SQL Server 2008 Express installed.
I want to copy some files to my server with my application, but there is 1 problem, if there are some files with same name with the files I am going to upload so those file will be overwrite. ...
Hi,
I would like to know if there is a solution for my SQL problem.
I work on 2 different linked servers.
When I execute a query on each server separately, there is no problem.
But, wh...
I'm being forced to use extensive dynamic sql because of the design of the db I'm working with. The table name is often a parameter to the stored procedure. That being the case, I'm trying...
The T-SQL UDF named 'udf_GetCountOfRows' (defined in the box below) fails to run when I invoke it with the following SELECT statement,
SELECT dbo.udf_GetCountOfRows( 'ODS_AR_INVOICE_I...
Hello,
I am having an issue where some users are receiving the following error when using a particular form: Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access ...
I am trying to read the text from a Binary field in a sqlserver table. I can use the sqlquery tool to dump the table and see the encoded bytes. the table has two fields, one named bits and o...
I have a select statement that changes the last name to Upper case for the first letter and lower case for the rest. So it changes SMITH to Smith.
My problem is when I have a multiple word ...
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
How can I insert tif or pdf files into a MS SQL 2005 server? I can use VBScript an JScript because my scanning software is supporting that.
My Databasename is dbFiles
My Tablename is Empl...
I need help connecting remotely to my SQL 2000 server via port 1433.
-I have SQL SERVER 2000 enterprise running on a Windows server 2003 R2 machine (windows NT 5.2)
-I have an instance regis...
We found a lot of error message 77799009 in errorlog and window event view. How should I know what the error message text for the user defined Error 7779909?
Thanks!
Still have an app using sql 7 (was that the version before sql 2000?). Anyway, I'm wondering if that product is end of life or if it is still supported by Microsoft. If it is eol, what are t...
First of all, I know about joins, subqueries etc., but we have a lot of old scripts made for Access and we recently upgraded to MS SQL Server 2000. Now SOMETIMES some of these scripts don't wo...
I wrote DDL script that runs for Oracle. However, is the script i attached below is compatible with SQL Server?
When I do this
BACKUP LOG tempDB WITH TRUNCATE_ONLY
DBCC SHRINKFILE(templog2, 2)
I Have message" Cannot shrink log file 3 (templog2) because all logical log files are in use."
What I ha...
Hi all,
I have a table called eord_line that has two columns [ref_no, part]
What I want to do is basically in the code snippet but because it's a frequently run query I want to do it usi...
I am trying to create a view with a UNION query which works fine if I run it as a query but if I create a View with the same code I get, "The multi-part identifier "IV00101.ITEMGEDSC" could no...
Hi. I want a stored proc to insert into one of two tables, depending on a variable, but Im getting a darned syntax error:
I have just created a counter log file. called base.blg
How to load and view it in system monitor.
I am using windows 2003 server.
i am getting ready to upgrade my SQL 2000 dbs to SQL 2005. before i do the upgrade i want to perform a couple of dry runs to be sure that everything works properly and anything that doesn't is...
Hi
There is a query to list a field [ashortcode]
I want to add a new line before 'receipt: ' .......
So, it can display 2 lines in a cell when display.
Can it be done?
I use MSS...
Although SQL Server (ACT7) is set to start automatically it is intermittently failing to start and thus stopping ACT 7 from loading any databases. I can start the service manually and then a ...
HI Guys,
I'm not very technical when it comes to SQL so,
I've had to create a test database from an original database for the client to test an upgrade before it goes live.
I have creat...
The Code attached is to use for the sales enquiry, I know the query is long but I'm getting the correct result and also its takes too much time to execute.. The SQL query uses two tables - Sal...
