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...
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...
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...
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...
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
...
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, ...
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 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
Is there a script I can run to disable the guest account?
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=...
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...
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...
Hello. I can't access a linked server from a workstation using Enterprise Manager.
I have a SQL2008 server and a SQL2000 server. I have set the SQL2000 to be a linked server on the SQL2...
i need to load an excel worksheet using the OPENROWSET functionality. i don't always no the name of the worksheet. i have clients uploading an excel file unto my ftp server and the worksheet n...
