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...
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 ...
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...
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, this is my first question through ExpertExchange.
My previously working SQLCMD batch file fails
1) My BSE.BAT file looks like this:
sqlcmd -y 1024 -S ANDREW_LAPTOP\SQLEXPRESS -i bse.sql...
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...
I have been trying for weeks to install this service pack and I continue to get failures. I have tried suggestions from the internet, but so far, nothing works and I continue to get the "Upda...
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...
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 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
When i execute the code below, i get the following error messge:
Msg 451, Level 16, State 1, Line 1
Cannot resolve collation conflict for column 2 in SELECT statement.
Msg 451, Level 16, ...
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=...
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'...
Is there a script I can run to disable the guest account?
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...
Hello,
I have a SQL Server 2005 Entripise Edition, SP 2, installation. Server is Windows Server 2003 Standard Edition on a 64 bit machine.
WSUS seems to try to do an update KB955706 for ...
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 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...
Hi,
I know a bit about 1NF till 3NF, but can anyone explain to me about 4NF ? any gud example will be helpful
The user could no longer access this file like normal. When I try to look at it using Query Analyzer on a CE device, all I can see is the filename, but I can't view anything about the file, s...
I have an SQL query (listed below) that is part of a Report View in a Windows application. Because of the way the reports are done I don't believe I can use external functions or stored proced...
