I am using ActiveX Crystal Viewer to display a crystal reports 8.5. ASP code seems to connnect to SQL Server 2005 but when report object is genereated, the report is blank.
I am trying to set up database mirroring between 2 databases on 2 different SQL 2005 servers. I am using the wizard in MS to set it up, and the End Points are created fine. However when I clic...
I have a SQL 2005 failover cluster on Windows 2003 server. I need to add an addtional instance. Can I use the same cluster group and resources or must I add another group to the cluster and sp...
I am using the folling ia a query to test a trigger I need to develop. My end result in the trigger will be to concatenate an inserted char (8) field with a ntext field from another table. I...
How can I bulk import data using automation to get data from Excel to a SQL Server table in bulk? I know that I can cycle through each row and insert them, but the tables are going to be huge ...
In SQL server management studio I have to go to SQL server agent and right click and click start, and then the maintenance plan will run, but after a reboot it won't run again until I start it...
i have a view that calls a stored procedure to return a value. The view runs fine. I have another view, ViewB, that groups the first view. This also runs fine and returns all the values fi...
I have a script that e-mails me if new records have been added to a table within the past 24 hours. The body of the e-mail indicates when the most recently added record was inserted into the ...
I continue to get this error and I don't see where I am making any conversion from varchar to int. This is a query only, not an insert or update.....
Microsoft OLE DB Provider for SQL Serv...
I could not login as sa user in sql server 2005 express edition.
here is the error detail:
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
I know it is a security issue. b...
Hi there,
i am having problems setting up an email subscription on a report to email the report as an Attachment.
I can set the subscription to work for entering just the link within the ...
Greetings Experts,
I need some help with a query. Here is an example of what I am looking to do.
Table 1 Table2
ColA ColA ...
I need to export a database (schema and data) from sql server 2005 on one machine to another machine into sql server 2005 express.
What is the easiest way to accomplish this?
I am new to SQL Server 2005. I need to save html data (email content) to a varchar field in a sql table. I want to save the email contents as-is (tabs, font, line breaks,etc).What is the easi...
Hi, I have a MSSQL db. I have been hit with a SQL Injection attack. I have someone trying to shore it up for me, but in the meantime, how can i simply delete any occurence of this:
<script...
Hi folks,
Is it possible to change the collation propert of an existing view? If yes, could you please describe how.
This question is related to groups and will use my previous examples. Is it possible to get a group total for just one item and to not display it under the rest of the group total? I'm reall...
I found this :http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31846/
to reindex all my databases tables. That uses a custom table to insert into, then read from. Is there...
In ssrs report, I have 1 data set which accesses 1 stored procedure that creates 2 work files and from those work files creates 8 other smaller tables (from queries).
In the other data set I...
I have a table that stores identification information for animals. Three field: ID, Type and SourceID
A single sourceid can have multiple id's of varying types assigned to it. Currently I a...
hey ee!
Here is my problem. I usually use the export wizard with a simple query whenever needed to export to excel. But for my latest request, I have had to do more than just a simple query...
GET_INBOUND_MESSAGE.BUILDING_NUMBER is NUMERIC and when trying to run this SELECT statement, I am getting
"Error converting data type varchar to numeric"
Hi..
I am trying to create a link server from SQL Server 2005-A to another SQL Server 2005-B which is on named instance.e.g HPSR080001\Artenaprod. I am able to create a link from SQL Server...
I moved a SQL Server 2000 db on Windows 2000 to a Windows 2003 server using SQL Server 2005. I have 5 load-balanced web servers hitting this db. Users are getting an intermittent error:
M...
I'm using dynamic sql to execute an update statement via a stored procedure. I have my exec statement set to NVarChar(4000). I have my input parameters for the fields that need to be foreign...
