Hi,
I'm having problems with setting up MSRS, i've installed it on a Vista 32bit machine with no issues at all i've run Report Services Configuration and its all green. The problem occurs w...
Hi
I am trying to execute a store procedure from Cognos 8. When i validate the statement it does not generate any erros and it creates the data item. But when I run the report I get the er...
I have a query which is supposed to supply default values to Date_From and Date_To parameters for a report query.
The SELECT statement below provides date in the format YYYY/MM/DD , apparen...
I have verified that I am able to use OPENQUERY to query tables in the linked server, even the table being queried from within the oracle stored procedure. I have already executed the oracle ...
Hi Experts,
I've just been hit with a sql injection which contained a hex string - does anyone know how I can decode that hex to see what commands they were trying to run?
Many thanks,
In SQL server- Query Analyzer when you do a delete from table sql command in SQL you get
ie. (25 rows(s) affected). which is the norm. But for a specific table that I perfom a delete from t...
I'm a rookie as CASE statements and need some help. This query worked fine until I added the one CASE statement, and now, I can't get it to run. I keep ketting the following message:
Serv...
I have an SSIS package; the same logic could be used for a DTS package that I need to see if a CSV file is on the SQL server. Then based on if the file is there on the server (the same server...
Hi,
I believe that we have been hit with an SQL injection attack. At the top of our website page it has the following;
<script src=http://www.chinabnr.com/b.js></script>
Can you tell ...
Experts:
I'm new to RS and working with BI Dev Studio and I'm testing some simple reports and charts..etc.
They work fine on my CLIENT workstation, however when I deploy them to the Repo...
I just detached a DB so that I could move the files to a diffrent hard drive but I keep getting this error:
"Cannot Copy impresario Access is denied.
Make sure the disk is not full or wr...
Hi,
Language: T-SQL (Microsoft)
I would like to convert value from a string (dd\mm\yyyy) to a date (or datetime) and insert the value to a table. This should be the equivalent to Oracle func...
I have a SQL server that is virtualized on VMWARE with 4 CPU and 8GB of memory. Since Thursday the SQLSERVER.EXE has posted anywhere from 90-100% CPU utilization.
so far we have performed ...
I need some guidance. I am deploying an application that uses SQL Express written in VB.NET. I have the master program running with SQL Express. I am trying to figure out the best way to cre...
Hello
I keep recieving the following message in Event Viewer:
"The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs." Event ID 17896
It is an informatio...
What is the difference between Oracle/SQL Server. SQL also provides security features. What is the key difference between the two.
I am filling a dataset from a stored procedure on my SQL Server 2000 database and have not had any problems with it in the past few months. Now today I am getting timeout error whenever I try...
So I got a stored proc sp_One that returns a resulset.
And I want to have sp_Two with a #Temp table to do something like:
SELECT INTO #Temp the Resultset From sp_One
Then I'm going to do s...
I have the following code in a file called mssqlscript.bat and what i want to do is simply double click it and have it run the backup. It currently doesn't do anything when I double click it....
How to skip Tempdb in below procedure
The below procedure gives us all tables information in the server, and runs weekly once. This procedures running good but some time its giving the error...
My SP wont except an english date format I havent come across this before with my store procedures they have been accepting english date formats now for months - e.g. 13/12/2008
alter proce...
Hi,
I'm trying to import data from a CSV file into an existing table but having problems. The current error I can't get past is "Bulk insert data conversion error (type mismatch)".
Here ...
I'm writing a query in reporting services to provide a count of all activities entered by a particular user on a per month basis. The trick is, the boss wants to see a count of 0 for any user ...
Hi,
I have the following code that is talking to a sql stored procedure: -
USE [testdata]
GO
DECLARE @return_value int,
@NewTestID uniqueidentifier,
@ErrorCode int,
@ErrorDe...
I am executing the following - but later, in my code, when I try to select * from @MX_REIMB, it throws an invalid object name - I am not sure with temp tables, but is it because, since it is i...
