Can't Load The Php Sqlsrv.dll For Some Reason

Feb 5, 2008

Running MS2k3 webserver with IIS and PHP 5.2.5

my php.ini is in the Windows folder containing among other things these 2 entries:

extension_dir ="C:PHPext"
extension=php_sqlsrv.dll

and the file php.sqlsrv.dll is located in the PHPext directory

I've restarted the IIS server with php running and working just fine. Is there anything else I could still check ?





Code Snippet

if (!extension_loaded('sqlsrv')) {
echo("NOT LOADED");
}

Produces: not loaded.


EDIT:
Dug up some logs:
The description for Event ID ( 2 ) in Source ( PHP-5.2.5 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: php[2144]; PHP Warning: PHP Startup: Unable to load dynamic library 'C:PHPextphp_sqlsrv.dll' - The specified module could not be found.
in Unknown on line 0.

View 1 Replies


ADVERTISEMENT

Transactions And Sqlsrv Php Driver

Nov 20, 2007

Hi,

I am testing the sqlsrv driver for php5. I wonder if there is any way how to work with transactions.

What I basically need is some equivalent of:
mssql_query("BEGIN TRAN", $c);


The command sqlsrv_conn_execute($c, "BEGIN TRAN") returns null and error code 266, message [Microsoft][SQL Native Client][SQL Server]Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.

Is it possible to use the driver the way I need? I mean, is there a way how to issue multiple statements (sqlsrv_stmt_execute()) in one transaction?

View 3 Replies View Related

Sqlsrv.exe Consuming High CPU Cycles

Dec 19, 2005

Hi,
The sqlsrv.exe process has been consuming a high number of cpu cycles and time and seems not be decreasing at all. Can somebody point me in the right direction as to how to identify the bottleneck and resolve the same at the earliest

Thanks in advance

View 3 Replies View Related

SQLSrv JDBC Driver 1.2.2828 Bug?

Jan 19, 2008

Hi All,
To me the results of getSchemas appears wrong and the catalog/schema values the wrong way round!

Using latest version of Sql Server 2005 Express with 1.2.2828 JDBC driver.

Created a database called: db_connection_tests

Created some tables inside this database called:


main
child
lookupThese show in Sql Server Manager as:


dbo.main
dbo.child
dbo.lookupIf I now log on through JDBC as user "dddddddddddd" and run 2 metadata calls (getCatalogs() and getSchemas()) the results to me do not match, that is the schema and catalog seem to be wrong in getSchemas.

Why is the catalog DBO returned for schema d_connection_tests in getSchemas(), when not in results of getCatalogs()?

TABLE_SCHEM db_connection_tests
TABLE_CATALOG dbo


getDatabaseProductName: Microsoft SQL Server

getDatabaseProductVersion: 9.00.3042

getDatabaseMajorVersion: 9

getDatabaseMinorVersion: 0

meta.getDriverMajorVersion(): 1

meta.getDriverMinorVersion(): 2

meta.getDriverName(): Microsoft SQL Server 2005 JDBC Driver

meta.getDriverVersion(): 1.2.2828.100

List of schemas (snippet):

TABLE_SCHEM db_connection_tests
TABLE_CATALOG dbo

List of catalogs:

TABLE_CAT db_connection_tests
TABLE_CAT master
TABLE_CAT model
TABLE_CAT msdb
TABLE_CAT tempdb

Tried JTds driver and results for getSchemas() are different!

getDatabaseProductName: Microsoft SQL Server

getDatabaseProductVersion: 09.00.3042

getDatabaseMajorVersion: 9

getDatabaseMinorVersion: 0

meta.getDriverMajorVersion(): 1

meta.getDriverMinorVersion(): 2

meta.getDriverName(): jTDS Type 4 JDBC Driver for MS SQL Server and Sybase

meta.getDriverVersion(): 1.2.2

List of schemas:

TABLE_SCHEM db_connection_tests
TABLE_CATALOG null


Code

package test.com.database;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class SqlServeTest_DriverMs {

private Connection con;
private DatabaseMetaData meta;

public static void main(String[] args) throws ClassNotFoundException, SQLException {

SqlServeTest_DriverMs sqlServeTest = new SqlServeTest_DriverMs();
sqlServeTest.runTests();
}

protected void runTests() throws ClassNotFoundException, SQLException {

// Class.forName("net.sourceforge.jtds.jdbc.Driver"); // JTds Driver
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // MS Driver
try {
// Jtds Drvier
// con = DriverManager.getConnection("jdbc:jtdsqlserver://localhost:1433/db_connection_tests;user=dddddddddddd;password=root");
// MS Driver
con = DriverManager.getConnection("jdbcqlserver://localhost:1433;user=dddddddddddd;password=root;database=db_connection_tests");

meta = con.getMetaData();
System.out.println("getDatabaseProductName: " + meta.getDatabaseProductName());
System.out.println("getDatabaseProductVersion: " + meta.getDatabaseProductVersion());
System.out.println("getDatabaseMajorVersion: " + meta.getDatabaseMajorVersion());
System.out.println("getDatabaseMinorVersion: " + meta.getDatabaseMinorVersion());
System.out.println("meta.getDriverMajorVersion(): " + meta.getDriverMajorVersion());
System.out.println("meta.getDriverMinorVersion(): " + meta.getDriverMinorVersion());
System.out.println("meta.getDriverName(): " + meta.getDriverName());
System.out.println("meta.getDriverVersion(): " + meta.getDriverVersion());

printOutSchemas();
printOutCatalogs();

} finally {
if (con != null) {
try {
con.close();

} catch (Exception e) { // Ignore error
}
}
}
}

protected void printOutSchemas() throws SQLException {
ResultSet rs = null;
try {
rs = meta.getSchemas();
System.out.println("List of schemas: ");
printResults(rs);

} finally {
if (rs != null) rs.close();
}
}

protected void printOutCatalogs() throws SQLException {
ResultSet rs = null;
try {
rs = meta.getCatalogs();
System.out.println("List of catalogs: ");
printResults(rs);

} finally {
if (rs != null) rs.close();
}
}

protected void printResults(ResultSet rs) throws SQLException {
final int cols = rs.getMetaData().getColumnCount();
while (rs.next()) {
System.out.println();
for (int i = 1; i <= cols; i++) {
System.out.println(' ' + rs.getMetaData().getColumnName(i) + ' ' + rs.getString(i));
}
}
}
}

View 1 Replies View Related

SQLSRV Driver For PHP Delete Queries Issue?

Jan 1, 2008

I have been experimenting with the preview release of the SQL Server 2005 driver for PHP. I have used the PHP MSSQL extension a lot as well as connecting thru COM. I am glad we finally will see a Microsoft supported extension.

With the current release I am able to do most things my current MSSQL driver does. It does require some workarounds (there is no sqlsrv_num_rows nor sqlsrv_data_seek) here and there. But nothing major.

Now to get to the issue at hand. When I run a DELETE query, there is no statement resource returned and my application incorrectly detects an error.

Sample code:
$the_query = "DELETE FROM sometable WHERE id=5";
if ( ! $qid = sqlsrv_conn_execute ( $connection_id, $the_query ) )
{
echo $the_query."<br />";
foreach( sqlsrv_errors() as $error )
{
echo "SQLSTATE: ".$error['SQLSTATE']."<br/>";
echo "Code: ".$error['code']."<br/>";
echo "Message: ".$error['message']."<br/>";
}
exit();
}

Looks like a bug to me. The funny thing is that exactly the same bug was in the PHP MSSQL extension a while ago.

View 2 Replies View Related

Prob With 120 Days Evaluation Copy Of Sqlsrv 2000

Mar 22, 2004

Hi,
I m using SQL Server 2000's 120 days evaluation copy for testing my application. The prob i am facing is that whenever the rows in one of the table increses beyond 10K it gets cleared up.

I could not trace the reason for this. Plz some one suggest a possible solution for the same.

Thanks in advance.

View 1 Replies View Related

Not Able To Load The Application In Case Web Farm Garden When We Load Data Through Background Thread.

Dec 14, 2007

Hi,

Here I will describe my problem.
1. We are loading large amount of data from database on background thread which is starting on Application_start event in global.aspx.cs file.The data is later cached for subsquent request to improve the performance.
2. Now when we put the application on web farm garden, it is not able to load the application.
3. We are sending the request the servers through Router kind of application.
4 This application is working fine on single server enviornment.

Please help us.

Ajay Kumar Dwivedi

View 1 Replies View Related

Load All Data Without Knowing Old One Was Load In The Previous Time???

Apr 27, 2007

I just have done the SSIS example in the tutorial document included when install SQL 2005 ENT. I have a problem that whenever I test to run, the service load all data from source with out noticing about the data (I mean it load all the data to the destination), I do it several time and it continue to load all without checking. That mean the data is dublicated when the schedule run???



I think there should be a paramete or something like that to help the engine just load the new data to the destination. Could you help please?



Thank

View 3 Replies View Related

Reason To Not Use SELECT *

Apr 22, 2004

Or when to use it...

http://weblogs.sqlteam.com/brettk/archive/2004/04/22/1272.aspx

Any comment appreciated...I'll add to the list as well

Thanks

View 14 Replies View Related

What's The Reason To Use OLE DB Command?

Dec 27, 2007

When I design package under ssis, I always use execute sql task to replace OLE DB Command. Normally, I use staging tables to get all data from data source,then modify or generate some columns on the staging tables according to bussiness rules using execute sql task, Finally,transfer to data destination. And execute sql task is more effiecient than OLE DB Command. I suppose there's reason for using
OLE DB Command. But I don't know. So what's the reason to use OLE DB Command?

View 1 Replies View Related

Deadlock Reason?

Apr 24, 2008

I am having difficulty in identify my deadlock reason. So, please give me some hints.

In my application, I have 2 standard functions. One for transaction creation and one for reporting. The strange problem is I seldom / never got any deadlock witht the transaction creation. Instead, I got deadlock problem with the reporting.

In the reporting function, I only use select and aggregate function. Why will deadlock be raised? Can someone give me an example why such deadlock happened?

Thanks in advance.

View 1 Replies View Related

My Agent Was Down With No Reason

Apr 8, 2008

Hello everyone, I need your help. I have SQL*Server 2000 in a Windows 2000 advanced server service pack 4. My SQL*Server has the path 4. Yesterday I had this message and then my database was down.
SQL Server is terminating due to 'stop' request from Service Control Manager.
Any help?

View 13 Replies View Related

Help, Pkg Does Not Run From Job - No Obvious Reason

May 6, 2008

Hi,

I have a package that just won't run from a job.

To test the problem, I created a very simple package. All it does is load a simple text file to a table on the local server.

I set protection level to "encrypt sensitive with password", and set the password. I changed the creator name to the SQL Server Agent Account. (don't know how to change the GUID?)

It runs fine from BIDS and msdb storage. But if I run it from the job, it fails with:
Executed as user: DOMAINUSERNAME. The package execution failed. The step failed.

No logging occurs, even though I have set the package to log, which seems to indicate it's not even getting as far as starting the package. I've restarted all the services.

I tried running this package from a job on ANOTHER server and it works, no problem. There's just something going on with this other server where it won't run from the job... both servers use the same SQL Server Agent account.

I've consulted http://support.microsoft.com/kb/918760 and it talks about this problem but I have everything set correctly... never had this problem before... seriously.

HELP

View 7 Replies View Related

DTS_E_PRODUCTLEVELTOLOW Without Any Reason

Mar 23, 2008

hy all

this is my second post on this issue, and I'm hoping to solve it now.


I got this error msg: DTS_E_PRODUCTLEVELTOLOW

when tring to run SSIs package with load data from File source (simple one) to DB on SQL2005 and the package is stored and exec on the SSIS server.

We installed the SSIS server with the Database engine on the same machine.

when running from my workstation it work fine, but when the package was uploaded to the MSDB and executed from there - it failed.


help, anyone.

Oh, by the way - microsoft issues on that problems didnt helpd - i got the enteprise edition installed and there is a match between the versions of all the components: BIDS, Server SSIS and SQL2005

udi

View 1 Replies View Related

Reason To Use Optimizer Hints

Aug 5, 1999

While investigating performance problems within an application recently I carried out some tests using SET SHOWPLAN ON.

I had a query like this within a stored procedure:

SELECT MAX(X) FROM Y WHERE Z LIKE @MYVAR

Where @MYVAR was passed in. I discovered that SQL Server did a Table Scan even when Z had an index on it. A problem with 200,000 rows!

If I said

SELECT MAX(X) FROM Y WHERE Z LIKE 'HELLO%'

(i.e., used a constant instead of a variable) SQL Server did use the index correctly and did not do a table scan.

I got around this by rewriting my statement:

SELECT MAX(X) FROM Y (INDEX=MYINDEX) WHERE Z LIKE @MYVAR

in other words by manually specifying the index I had created on the Z column.

Hope this helps someone.

View 2 Replies View Related

Going Into Single User Mode For No Reason?

Feb 19, 2001

Dear All,
I have some user databases that go into single user mode
for no apparent reason. Is there any reason that SQL
Server 7 would set a database in single user mode
by itself? NB They are not being set single user by anyone
else here, they would not know how.

Many Thanks in Advance,
Andrew

View 2 Replies View Related

Blocking SPID ... No Apparent Reason

Jun 14, 2004

Hi,
I hava a JAVA application that updates a SQL2000 (SP3a)database.
The application handles different types of "jobs" which effectively update the DB.

One job in particular appears to block all subsequent jobs. It comprises of a large amount of inserts/updates in a single transaction. This is necessary as it is an "all or nothing" scenario - so we cannot break the transaction into smaller ones. The transaction appears to succeed as it reaches the COMMIT TRAN statement without error.
However the records do not get written to the database.
EM indicates a large number of locks held on the tables accessed by the transaction and these do not get released.

Using the SP sp_blocker_pss80, the blocking SPID has a waittime of 0 and a waittype of 0x0000 - the lastwaittype is WRITELOG and its status is AWAITING COMMAND

I am using MS SQLSERVER JDBC Driver SP2 (considering using jTDS)

I have tried
- increasing Transaction Log size
- Moving Transaction Log to a separate Disk
- Reducing Isolation Mode to Read Uncommitted
- Set AutoCOMMIT to true
- set Close Cursor on COMMIT
- set SelectMethod to Direct - (we use Cursor by default)

None of these have succeeded in fixing the issue.

The job will succeed if it is the first/only job to access the database.
But if another job precedes it - then the blocking occurs.
I have verified that the preceding job only holds shared dataabase locks
before the blocking job is run.

Each job will use its own JDBC connections to access the database for reading
purposes, but all of the writing goes through the blocking SPID.

Any ideas?
Thanks, Liam

View 4 Replies View Related

I Hate New Management Studio For 1 Reason...

Dec 27, 2007

...and it is because...
when i drag and drop my script file into query window unlike query analyzer which selects the current database, new MSSMS selects the users 'default' database.

we maintain 1 script file for each sp/function and ddl/views groupe related stuff in 1 or more files

in query analyzer I just have to select DB where i want to deploy scripts and drag and drop the files from explorer and then then
1) press F5 (to run)
2) press CTL + F4 (to close window)
3) repeat till all scripts are deployed

and now in MSSMS

1) select db (this step is really painful especially when i have to deploy more than 1 script/file)
2) press F5
3) press CTL + F4
4) repeat

is there any settings that could change the behavior of SMS2K5 like old QA2K?

well what i cant do here is change default db to the tartget db before deploying and switch back after deploying (but not a true solution)

thanks in advance

View 9 Replies View Related

Using Where..IN In Update Query.. Not Working For Some Reason

Jul 20, 2005

Hi folks,Hopefully this is a simple fix, but I keep getting Syntax error withthis statement in an MS SQL DTS statement and in Query Analyzer:Update A Set A.deptcode = A.deptcode,A.type = A.Type,a.TotalExpenseUnit = (a.LaborExpenseUnit + a.OtherExpenseUnit)Where a.Type in ('FYTD04', 'Prior Year','Budget')From Data_Unsorted A Join Data_Unsorted B OnA.deptcode = B.deptcode and A.type = B.TypeBelow is the error from Query Analyzer:Server: Msg 156, Level 15, State 1, Line 5Incorrect syntax near the keyword 'From'.Where do I place my Where..In statement since I only want to limit theUpdate to run for items where a.type is FYTD04, Prior Year, or Budget?Thanks,Alex.

View 3 Replies View Related

Transaction Log File Disappearing Without Reason

Apr 17, 2007

Hi team,



At one of our SQL2005 servers we've got a really strange problem. The transaction logfile of one of our databases is suddenly disappearing without a reason. From that moment on the event log (application) is being filled up with SQLserver event 9001



Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: (2)
Event ID: 9001
Date: 16/04/2007
Time: 12:31:40
User: N/A
Computer: PBVSRV
Description:
The log for database 'Putboringen' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 29 23 00 00 15 00 00 00 )#......
0008: 12 00 00 00 50 00 42 00 ....P.B.
0010: 56 00 53 00 52 00 56 00 V.S.R.V.
0018: 5c 00 53 00 51 00 4c 00 .S.Q.L.
0020: 45 00 58 00 50 00 52 00 E.X.P.R.
0028: 45 00 53 00 53 00 00 00 E.S.S...
0030: 07 00 00 00 6d 00 61 00 ....m.a.
0038: 73 00 74 00 65 00 72 00 s.t.e.r.
0040: 00 00 ..


We already had this a few times before and really are unable to find the root cause for this. Can you help us out?

The server is a Dell PE1900 running SBS2003R2. Database is stored on a seperate volume (R5 configuration). Environment is +-5 workstations





Thanks



Didier

View 8 Replies View Related

FTP Task Fails For No Good Reason

Jan 11, 2008

Hi,

I have a package that has several FTP tasks in sequence:

[ftp task 1]->[ftp task 2]->[ftp task 3]->[ftp task 4]

[Ftp task 4] fails about 20% of the time, for no apparent reason. This is the error message I receive:

[FTP Task] Error: Unable to receive files using "FTP Connection Manager".


The problem is, it works most of the time (80%), but every 4 or 5 tries, it fails. This makes NO sense to me. Is this a bug perhaps?

Please help... should we use an ftp script instead, as the ftp task seems rather unreliable.

Thanks

View 5 Replies View Related

Reason To Back Up Database Master Key?

Aug 17, 2006

I can backup this key using something like:

BACKUP MASTER KEY TO FILE = 'c:TestEncryptionMasterKey.key'

ENCRYPTION BY PASSWORD = '23'

but why would I need to do it as the DBMK is stored in the databases itself ( in sys.symmetric_keys) and we dump all databases nightly. Just "in case"?

TIA,



barkingdog









View 1 Replies View Related

How To Find Out The Reason For Error 17883?

Sep 26, 2007

Hello, ereryone

I use MSDE in my system, and sometimes the following error occurs in MSDE. After that, I can not even access MSDE with the osql command.

Can anyone give some advice as how to deal with this kind of error or how to find the real reason? I have checked MS homepage, but I can not get the details of it.


Error: 17883, Severity: 1, State: 0 The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x003B70F8

Thanks in advance.

View 1 Replies View Related

Reason: Invalid Login Information

Mar 25, 2008

I can log in to a database with administrator account, but not with an user account.
I am getting "Invalid login information" error message. What will be the likely cause for this?
I am using Winodws authentication.

View 5 Replies View Related

Database Size Exploded For Unknown Reason.

Oct 25, 2006

I have been working on an app for several weeks.  My database size went from 9MB to about 12MB.  Sometime in the last 2 days it jumped up to 242 MB.  I don't know why.  Now I cannot open it with management Studio Express.  It says another process is using it.  Usually this means I have a aspnet_wp.exe process running (from Visual Studio) and I just end the process, but Wndows Task Manager will not end the process.  It does knock its size way down to 2.9 MB but won't kill it.  Rebooting won't kill it either.Are these two symptoms related?  How do I recover?Thank you.

View 1 Replies View Related

Annoying, Can't Insert Into DB For Some Reason, Even Using A Stored Procedure.

Dec 8, 2003

Hello, I am having problems inserting information into my DB.

First is the code for the insert


Sub AddCollector(Sender As Object, E As EventArgs)
Message.InnerHtml = ""

If (Page.IsValid)

Dim ConnectionString As String = "server='(local)'; trusted_connection=true; database='MyCollection'"
Dim myConnection As New SqlConnection(ConnectionString)
Dim myCommand As SqlCommand
Dim InsertCmd As String = "insert into Collectors (CollectorID, Name, EmailAddress, Password, Information) values (@CollectorID, @Name, @Email, @Password, @Information)"

myCommand = New SqlCommand(InsertCmd, myConnection)

myCommand.Connection.Open()

myCommand.Parameters.Add(New SqlParameter("@CollectorID", SqlDbType.NVarChar, 50))
myCommand.Parameters("@CollectorID").Value = CollectorID.Text

myCommand.Parameters.Add(New SqlParameter("@Name", SqlDbType.NVarChar, 50))
myCommand.Parameters("@Name").Value = Name.Text

myCommand.Parameters.Add(New SqlParameter("@Email", SqlDbType.NVarChar, 50))
myCommand.Parameters("@Email").Value = EmailAddress.Text

myCommand.Parameters.Add(New SqlParameter("@Password", SqlDbType.NVarChar, 50))
myCommand.Parameters("@Password").Value = Password.Text

myCommand.Parameters.Add(New SqlParameter("@Information", SqlDbType.NVarChar, 3000))
myCommand.Parameters("@Information").Value = Information.Text

Try
myCommand.ExecuteNonQuery()
Message.InnerHtml = "Record Added<br>"
Catch Exp As SQLException
If Exp.Number = 2627
Message.InnerHtml = "ERROR: A record already exists with the same primary key"
Else
Message.InnerHtml = "ERROR: Could not add record"
End If
Message.Style("color") = "red"
End Try

myCommand.Connection.Close()

End If

End Sub


No matter what I get a "Could not add record" message

Even substituting the insert command string with my stored procedure I would get the same thing

Stored Procedure:

CREATE Procedure CollectorAdd
(
@Name nvarchar(50),
@Email nvarchar(50),
@Password nvarchar(50),
@Information nvarchar(3000),
@CustomerID int OUTPUT
)
AS

INSERT Collectors
(
Name,
EMailAddress,
Password,
Information
)

VALUES
(
@Name,
@Email,
@Password,
@Information
)
GO


Can anyone see any problems with this code? It looks good to me but I get the same message always.

Thanks

View 2 Replies View Related

Increased Backup Size For Unknown Reason

May 25, 2004

Does any one know what could be making the size of a backup get so big in SQL server?

I noticed if you back-up the same database in Enterprise Manager over and over (without making any changes to the database), the size of the backup gets bigger and bigger. To get around this I simply erase the backup and create a new one.

Now I'm experiencing the same kind of problem, different situation. I decided to make very few changes to my database. If anything, I shrunk the size of the tables and stored procedures.... Now all of a sudden my database backup is 7 times larger.

What could be increasing the size so much, if I haven't increased the amount of tables or stored procedures?

What is the log file about? Mine is huge? Is there a way to reset it or clear it?

any help would be great.

Thank you,


Alec

View 1 Replies View Related

Query Taking Ages For No Apparent Reason

Jan 19, 2004

Hope someone can help me with this because its driving me potty!

I have a .NET script that sends really simple queries to SQL server that works perfectly 50% of the time but for the other 50% it takes ages (2-3 minutes) and then fails, I'm assuming because it times out. I then check the SQL by excecuting it via query analyzer and it again takes ages but will work eventually (I'm assuming because this bypasses the timeout settings, but changing these isn't on).

This happens randomly, the scripts will be working fine and then fail a few times before magically working again!

Any ideas? Perhaps some database features that commonly cause this problem? The problem only occurs with one database, all our others are fine but we can't spot any differences!

Any help or tips would really be appreciated.

Thanks.

View 5 Replies View Related

Dt Object Crdate Updating For No Apparent Reason

Oct 7, 2005

In the master database for a SQL Server instance I noticed the dt... objects (procedures, etc.) in create date of today about 7 minutes before I looked in sysobjects. No changes have been made to that instance for months. Also in other cases I noticed the same thing just different dates for each instance. Any ideas on why the dates would change?

View 1 Replies View Related

Problem With IF Statement - Some Reason Not Firing Properly

Apr 23, 2008

Hi all, could someone be kind enough to provide me some help into why the following IF statement is not working? Basically, I am trying to find out whether a field in my database has a CONSTRAINT attached to it with a particular name... IF it does have one then drop it and re-create it ELSE simply create one.

I have used SELECT * FROM SYSOBJECTS to find whether it exists which according to the results it does EXIST, however my IF statement is not detecting it and I get an error which states:
Msg 1781, Level 16, State 1, Line 30Column already has a DEFAULT bound to it.Msg 1750, Level 16, State 0, Line 30Could not create constraint. See previous errors.

However, surely my IF statement is suppose to be handling this problem and therefore if it does EXIST THEN it should ideally drop the CONSTRAINT and then re-create it but this is not the case... instead the ELSE is always being triggered. After using SYSOBJECTS I copied it directly from the results view into my SQL but still for some reason if my constraint does exist it jumps to the ELSE.






Code SnippetIF EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME = '[DF_TBL_SyncTable_OB-DEVUK]')
BEGIN
ALTER TABLE TBL_SyncTable DROP CONSTRAINT [DF_TBL_SyncTable_OB-DEVUK]
ALTER TABLE TBL_SyncTable ADD CONSTRAINT [DF_TBL_SyncTable_OB-DEVUK] DEFAULT 2 FOR [OB-DEVUK]
ALTER TABLE TBL_SyncTable ADD [OB-DEV6] TINYINT DEFAULT 2
END
ELSE BEGIN ALTER TABLE TBL_SyncTable ADD CONSTRAINT [DF_TBL_SyncTable_OB-DEVUK] DEFAULT 2 FOR [OB-DEVUK]
ALTER TABLE TBL_SyncTable ADD [OB-DEV6] TINYINT DEFAULT 2
END


Thanks for replies + suggestions + comments

Regards, Onam.

View 6 Replies View Related

Login Failed - Reason: The User Is Disabled

Apr 6, 2007

Hi,

I am having a problem with sql server 2005. I would like to access the database but unfortunately I disabled the account I am using to login. Can somebody tell me how can I enable it if possible?



Thanks

View 1 Replies View Related

SQL Server Admin 2014 :: SSIS Job Fails For No Reason

Aug 11, 2015

I have a job that runs an SSIS package. The job seems to be able to run through the package successfully, but at the end it errors out saying "The binary code for the script is not found. ...". The script referred to is at the beginning part (not the very first step) and should already be run.

The thing is, I can manually run this package on the server or visual studio without any problem. Also this job has been run on a regular basis without any issues on our old SQL 2008. I'm migrating this to Amazon Cloud SQL 2014.

Together with this package are other two very similar ones. They all work fine. I just can't figure out what can be wrong with this one.

View 4 Replies View Related

SSIS Package Fails/Does Not Complete Without Reason, Likely Due To A .NET 2.0 Exception

Feb 8, 2008

I have searched extensively and not been able to find a solution to this problem.


The problem:
We have one SSIS package will sometimes 'finish' executing (or crash from a .NET exception) when it certainly has not made its way through all of the data flow components. There are no SSIS error messages, no warnings, and it never happens at the same location in the package's pipeline. The only thing that is instantly visible is a command window that flashes on the screen and disappears too quickly to see anything,.

Sometimes the package does actually complete without any problem, but most of the time, it does not.

What we see:
If the packages is being run through the "Execute Package Utility" (by double clicking the dtsx file), after a bit, a command window flashes on the screen and instantly disappears (no text is visible), then the €œExecute Package Utility€? disappears. The event viewer of the machine then shows:

Source: .NET Runtime 2.0 Error
Category: None
Event ID: 1000
Type: Error
Description: Faulting application dtexecui.exe, version 9.0.3042.0, stamp 45cd726d, faulting module dtspipeline.dll, version 2005.90.3042.0, stamp 45cd721f, debug? 0, fault address 0x00019a66.

If the package is running within visual studio, again the command window flashes on the screen, then the "Execution has completed" prompt appears, but any "running" component remains Yellow (no red), both within the data flow and control flow (we do not have any event handlers set up). Neither our SQL Log provider, nor the "Execution Results" tab in visual studio show any type of error message... all SSIS messages just stop right in the middle of the many OnPipelineRowsSent log events (so there is no PackageEnd log event when this happens). The event viewer on the machine contains no useful messages when running within visual studio.

And other packages:
Are fine. This is only the case for this one package... we have nearly a dozen other packages, all very similar in design, that complete without issue.


We have also tried re-creating this troublesome package from scratch with no avail.
<!--[if !supportLineBreakNewLine]-->
About the package:
The Data Flow is pulling rows from 3 different external SQL data sources (400k-500k rows total), sorting and merging the rows, performing some basic lookups, then SCD'ing the results. This Data Flow is executed multiple times within 2 nested for loops (these nested loops give us particular dates, i.e. years 2000 through 2008, then months 1 through 12 for each year). There is not a single script task in the package. The problem seems to happen most as the data is being pulled from the sources and merged together, but it is not limited to this area.

<!--[if !supportLineBreakNewLine]--><!--[endif]-->
The environment:
We€™ve tried to use multiple machines with the same result. The current machine specs are as follows:
SQL Server 9.0.3042 (SP2)
Windows Server 2003 R2, Enterprise x64 Edition, SP2
3.00GHz x 16 processors, all 64 bit
63.5 GB of RAM
Over 1 terabyte of hard disk space
.NET 2.0.50727.42


The package was designed using:
Visual Studio 2005 with SP1
Microsoft SQL Server Integration Services Designer - Version 9.00.3042.00


Anyone have an idea? Thanks in advance.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved