OK, we copied a working ASP.Net 2.0 App from a machine running IIS 5.1 under WinXP to a machine running IIS 7 under Win7. We Get: Login failed for user 'IIS APPPOOL\DefaultAppPool'.
at line...
I have a user that gets this error when opening an application:
"Unhandled exception has occurred in your application. If you click conttinue, the application will ignore this error and att...
Hello, have the below code in a stored procedure (Visual Studio 2008/MSSQL 2005), that is tied to a GridView control. It currently returns/shows a column of regional office names ('ro' field)...
Hi,
We run a SQL Server 2005 server with Reporting Services enabled, both running on the same machine; Windows Server 2003 Standard R2 x64. We keep running into the "unable to load client p...
Hi
I wouldn't think this is difficult todo but I haven't found solution. Its to pick a column from table from a set period. I get error in title from stored procedure "Conversion failed when ...
Client just had a lock up on Friday and unable to start MSSQL service due to what appeared is a copurpt Master database. When through the steps to recover and restore the master database. SQL ...
Dear expert:
I have a table that has a lot of fields, say fields A, B, C, .... I want to add a trigger that, if there is an update which is updating field B, it put also the new value on fi...
Hi,
I'm currently working on a C# program that needs to generate an SQL script. I've discovered that the SQLDMO API will allow me to do everything that the SQL Management Studio can do. T...
I am receiving this error when trying to copy data from an Oracle table to a SQL Server table. The Oracle datatypes are varchar2 and in SQL Server they're varchar. I've included the Data Conve...
I have a Windows Server 2003 Std. Its running a DB using MSFT SQL 2000. I have two HotFixes listed in my add remove programs that are very substantial in size. They are Hotfix 2050 and 2055...
Hi All,
I have a fairly straightforward SQL statement that selects a number of records from a table. I have recently converted this statement into a stored procedure and passed a few parame...
Declare @sqlquery1 float, @sqlquery2 float
set @sqlquery1='
select top 1 logspaceused from dbo.DBLogspaceHist
where server_id = 3 and database_name = ''bistage''
order by LogDT desc'
s...
I setup a SQL job to execute a package. As of right now I cannot get the job to run. When I do try to manually "Start Job at Step..." the job starts execution but fails.
The error message...
I have rows in two tables, say X and Y. X is the source, Y is the destination. I need to take certain rows from X and insert them into Y. Some of these rows already exist in Y, some are new ro...
I would like to know how to modify my existing script that creates a system DSN to create a USER DSN. Our company is making us use USER vs SYSTEM. Thanks
MSSQL 2000
OK, i'm working on an application that allows for data entry. It allows the user to create "Templates" which are made up of "fields". Here is a layout of the tables.
Table: Te...
Hello Experts,
I am working with some data I imported from an AS400 system. All my date (xxxDT) and time (xxxTM) fields are numeric:
I need three UFNs that will calculate the following
...
I have 2 tables contact1 and contact2. the contact1.acct field matches the contact2.acct field.
I need to pull the contact1.id values into contact2.id fields. How can I accomplish this on S...
This seelct query is part of a bigger stored procedure that I have been messing with but in my latest version I get this error and its after I added the primary key intPositionId butI need thi...
Hello All,
building off the example given here http://sqlblog.com/blogs/andy_leonard/archive/2007/10/14/ssis-design-pattern-read-a-dataset-from-variable-in-a-script-task.aspx?CommentPosted=...
Is there a script I can run to disable the guest account?
Hi,
I know a bit about 1NF till 3NF, but can anyone explain to me about 4NF ? any gud example will be helpful
Here is the type of web page I need to create:
http://www.nexium-us.com/nexium-resources/formulary-database.aspx
Let's say that i have all the relevant data in a relational DB, such a SQ...
I recently noticed that services had stopped on Backup Exec, meaning that backups weren't being run. I can use BEXEC to manually restart the services, which works fine but obviously this isn'...
I'm trying to find a query that would find lowercase letters within a field. I will want to Convert after the list is generated, but I'm having a difficult time finding one to find the inform...
