Answer Questions

• Eric Eichler Dependant assemblies in CLR

  This is related to one of my previous posts. I am running a CLR stored proc that goes to an EDS (Novell) server with LDAP and returns records into a SQL table. I am using the Novell ldap library. I want to do this with SSL so my code referneces the Mono security library as well. However when I make the call to the stored proc to run in SSL, I get an object not found error. I do not think that the the Novell assembly can "find" the Mono assembly. Two points: 1/ I can do the SSL if I run it as an asp.net page (so I know the SSL works) 2/ The proc runs and pulls all the records in non-SSL (so I know the proc works) Any ideas Thanks, BIG Hi BIG, As you surmised, Novell is trying to load the Mon ...Show All

• Dale17677 How to find the dependency object of a particular table

  Hi all, I m using SQL Server 2000. I want to know the Dependencies of a particular table in my database. I want to know the details inorder to delete the records which are not referenced from other related tables. (e.g) Customer, CustomerTax, Invoice tables are there. CustomerID is primary key in Customer table. CustomerID is Foreign keys in CustomerTax and Invoice tables. When i create new customer i enter customer tax also. So both Customer and Customertax details are stored in the tables. Once i created the customer details it not yet reference in invoice table i can deactivate(later i can again activate the customer) the customer, because it is not refered in Invoice table(eventhough it is refered in CustomerTax table). In my view Cust ...Show All

• Mike Norman update problem within cursor

  Hi there I written some tsql that uses a cursor to update certain tables in a database. --CURSOR TO REPLACE SYS__DB VALUES WITH 20202 DECLARE @V_TABLE_NAME NVARCHAR(128) DECLARE @V_UPDATE_SYS_DB NVARCHAR(128) DECLARE @V_DB_NAME NVARCHAR(128) DECLARE dbnames_cursor CURSOR FOR SELECT ENT_ID FROM VehiclesSYS.dbo.ENTITIES WHERE ENT_IS_VIRTUAL = 0 ORDER BY ENT_ID; OPEN dbnames_cursor FETCH NEXT FROM dbnames_cursor INTO @V_TABLE_NAME WHILE @@FETCH_STATUS = 0 BEGIN /* Process each database here. */ SET @V_DB_NAME = N'USE PEOPLE' EXEC sp_executesql @V_DB_NAME SET @V_UPDATE_SYS_DB = N'UPDATE @V_TABLE_NAME SET SYS__DB = 20202' EXEC sp_executesql @V_UPDATE_SYS_DB The problem lies with the update statement. T ...Show All

• Ganesh Thiyagarajan Is SQL Server supported in a VMWare environment

  I have looked all over the MS site and can find very little information regarding SQL Server's support for the VMWare environment.  Based on other information that I have obtained on other forums and web-site it looks like it is not supported by Microsoft, but I would like the company line if possible. Does any one know for sure and can point me to a URL   Thanks. Not much resource out there for that.  And MS doesn't support for that either.  However SQL server running on VMWare environment.  Even V-motion works great on our environment. Sunny SQL Server is not supported running under VMWare. -Euan Euan Garden Group Program Manager SQL Server ...Show All

• Mason Cox query large database

  Hi, I have a very large table to query, it has 11 million rows because it is a detail one. When I try to query against the table it took approximate 9 minutes. Is there a way to make it more faster I've already use partition scheme and indexes but seems 9 minutes is the fast result. Thanks in advance. best regards, You will come to know whether it is index seek or index scan or a table scan when you see the execution plan. if it is still doing the index scan or index seek then try update_stats command or create statistics. this should help as I did the same workaround for my query which used to take 1hr but after create stats it just took 3sec or so. You can also do something like: where trx_date >= '2004-01-01' and trx_ ...Show All

• Rolan Intermittent connection timeout / general network error

  We have a SQL 2005 clustered server (Microsoft Cluster Services) that is queried from 4 IIS6 Windows Server 2003 frontends. Each frontend runs both classic ASP apps connection with SQL Server ODBC and .NET2 apps connecting with System.Data.SqlClient. Ocassionaly we get a string of errors/timeouts opening a connection lasting maybe 2 minutes. One the classic ASP apps we log one of these two errors: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation or Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Server Driver]Timeout expired o n the AD ...Show All

• alex ivanov 3 Defrag for SQL Servers inside a Virtual Machine?

  sorry for asking here, since there's no forum for Virtual Server My question is We have 2 SQL Server instances on 2 Virtual Machine/Servers (say VM1 and VM2), which resides on a real physical machine (say A) Is there point in defragging VM1 or VM2's hard drive at all or should I just defrag on the physical machine A You want to make sure the VMs are down (stopped) then defrag the physical machine. That would be all you need. that's what I thought anyway, first time I defragged without shutting VMs down, I got a blue screen on 1 VM second time I defragged still without shutting VMs down, everything went smoothly I guess it's safer to shut down the VMs anyway Thanks for the answer ...Show All

• NessDan SUM returns incorrect value in SQL Server Mobile Query ... Bug??

  Hi all, I am a newcomer to Microsoft Database Technology and have appeared to come across an issue with the SUM function in SQL Server Mobile Edition. I am running Visual Studio 2005 and have created 2 tables: Orders and OrderLines which are set up in master detail fashion. The SQL Statement I create in the Query Builder is as follows: SELECT     Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address, SUM(OrderLines.Quantity * OrderLines.QualityReference) AS Total FROM         Orders, OrderLines WHERE     Orders.OrderNo = OrderLines.OrderNo GROUP BY Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address Now, the SUM ...Show All

• DevDiver create and attach data base

  Hi, i want to create a database with out the LOG file I did not find a way to do that, I want to create database in 2 ways 1. With CREATE DATABASE command. 2.Attach an exsiting MDF file. is there any way i can do that, my problem is that i'm creating the data base on my local computer the using sp_detach_db to detach the DB files, then trying to attach DB files from remote computer on the LAN that i dont have write premmsion on, but then i get an error from SQL server saying: "[Microsoft][SQL Native Client][SQL Server]Unable to open the physical file " \\lab11\sqltest\pppSignaling_log.ldf ". Operating system error 5: "5(Access is denied.)"." what can i do to solve this problem thanks ishay ...Show All

• shg_yl Installing Sql25k client without using CD/DVD?

  Hi everyone, We've found some problems when trying such thing. It seems that is compulsory to do via own CD/DVD. Any comment would be very appreciated. Thanks in advance, enric How are you trying to do the install If you share out the DVD/CD to a network drive and maintain the folder structures from the media, you should be able to install just fine. Thanks, Sam Lester (MSFT) Yes, be sure to follow the instructions in this KB, and you should be able to install from a network path or from a hard drive. http://support.microsoft.com/kb/916760/en-us Thanks for that. ...Show All

• Wadworth Waxstrong A connection to the report server failed

  Hello, I am getting extremely frustrated with this situation. I have two machines that are both connected to the domain and I am logged into both. I also have a W2K3 Server that is hosting SQL Server 2005 Standard. Both desktop machines have SSMS and all machines including server are now SP1. On one machine I can connect to reporting services just fine, but on the other I am getting the following error: TITLE: Connect to Server ------------------------------ Cannot connect to MEDUSA. ------------------------------ ADDITIONAL INFORMATION: A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using report server URL for the Server name, ...Show All

• Ravel Current package reference.

  hi Iam developing a custom ssis source component, in that i need to get the reference of the current package where this component is added. I can get get the reference of the current package using this line of code Microsoft.SqlServer.Dts.Runtime. Application app = new Microsoft.SqlServer.Dts.Runtime. Application (); Microsoft.SqlServer.Dts.Runtime. Package pak = app.LoadPackage(@"C\DTS\Package1.dtsx" , null ); Here i need to pass the path of the package. Is there any other way to get it (without the path) Thanks Mani Sorry we are a newbie, I want to add a dataflow task programmatically in the script task using the current package, Under dataflow task also create ...Show All

• michael447887 merge replications causes insert timeout

  Hi All, i need help. i have a merge replication running every 10 minutes. the replication is for 1 database consisting around 50 tables and all 50 tables are marked as article to be published. let's say the publisher is server A and the subscriber is server B. for explanation purpose, let's pick 1 table from the database, let's say table X in server A, there are applications running that insert and update table X. in server B, there are applications running that select and delete table X . table X at average, has tens of thousands rows. now comes the problem, every 10 minutes whenever the sql merge agent is running, sometimes whenan application insert a row to table X in server A, it returns an error : "Timeout expired. The timeout p ...Show All

• Zatoichi Invalid locator de-referenced

  I am trying to copy data from one SQL server to another. The data contains big image or texts. After SQLGetData, we used the SQLPrepare, SQLBindParameter, SQLParam and SQLPutData, and SQL_LEN_DATA_AT_EXEC to insert the data. Our application is unicode based, but the data type in the SQL server is text, so we bind the paramter using SQL_C_WCHAR as C type and SQL_LONGVARCHAR as sql type. But we got the error: SQLParamData: RETCODE= -1; State=37000, Native Error=7143 Microsoft claims it has this problem when using the MDAC2.7, see http://support.microsoft.com/kb/325765 , but with a different error message. The SQL server ODBC driver we are using is 2000.85.1117.00, but I got "Invalid locator de-referenced", Not sure if ...Show All

• sandeep437 Create Database with Visual Basic (Urgent)

  can i run such a transact SQL script with VB use master go create database Ayhandeneme on (Name=AyhanDeneme_Dat, FileName='c:ayhandeneme.mdf') go Yes you can use the TSQL script and run it in VB as a command You cannot execute the GO, as it is a batch seperator defined by the SQL Server tools. You will have to set the context in your connection command, or simply run it in two different batches. But you should be able to run any T-SQL command from VB. Use ADO in VB6, ADO.net with VB.net. As previously mentioned by MSVP, run the db creation in your command text object Adamus Ayhan Yerli wrote: can i run such a transact SQL script with VB use master go create database Ayhandeneme on (Na ...Show All