MS SQL Server :: Can't Find SQL Server: SSIS Pipeline Performance Object In Perfmon For 64-bit Server

Why Don't You Guys Provide A Way To Find Out The Dependancies Of Any Object (SProc, Table, View And Etc...) Within SQL Server...

Why don't you folks (SQL SERVER Management Studio Team or SQL SERVER Database Engine Team) provide an option by using which I would be in a position to know what all the other objects are depended on a selected object and vice versa. That means:

When I select a Table within the SQL SERVER Management Studio if there is an option for understanding "Which all the objects (tables or views) it is depended on (I mean Foreign key and etc... kind of relations) and also Which all the objects (Tables, Views, Stored Procedures and etc...) are using this table", It would be of great help for all developers.

I can be contacted over kotis@microsoft.com

I BLOG @ http://blogs.msdn.com/kreddy

View Replies !

Best Objects To Monitor In Perfmon To Judge Disk Performance
Have a sql 2000 db which I have no say in design, just make it run. My typical sql counters such as system queue, and buffer cache and cache hit ratio are all good. If I need to monitor disk activity (mainly how fast my data is being read, how long the user is waiting for that data for both reads and inserts), what are the best counters for this, and what value should throw up a red flag.

View Replies !

DTS.Pipeline.1 In SQL Server 2008
Hi

I have an existing application that programmatically builds SSIS 2005 packages.

I'm trying to get to working with the February CTP of SQL Server 2008. Having changed all the 2005 references to 2008 references and things like IDTSComponentMetaData90 to IDTSComponentMetaData100, my application compiles okay now, but hits a problem when it tries to create a Data Flow task.

The code which worked fine before (and seems to still be the recommended way in Books Online is):

Code Snippet

Dts.TaskHost myMainPipe = (Dts.TaskHost)container.Add("DTS.Pipeline.1");

However, this now produces the exception:

Cannot create a task with the name "DTS.Pipeline.1". Verify that the name is correct.

Should I be using a different moniker now? I took a stab at "DTS.Pipeline.2", but that didn't make a difference.

Thanks,
Andrew

View Replies !

Why Is It So Hard To Find SSIS For SQL Server Express?

I remember reading one year ago that SSIS came with Advanced Services, or SP1 for SqlServer Express.

I have the file SQLEXPR_ADV which i presume is Advanced Services , installed it, no sign of SSIS !?

Can someone point me in the right direction, half hour Googling, Foruming, MSDN still no results of where to get it .

View Replies !

SQL 2K5 SSIS DTS.Pipeline Errors
We have deployed an SSIS package successfully to production. We needed to apply SP1 to fix a different issue and now have encountered a new problem. We have numerous Data Reader Sources in different Data Flow Tasks that connect to a IBM iSeries (DB2) source. Pretty simple extracts that have worked fine in the past. They pump the data into staging tables on the SQL2K5 instance running the package (64-bit).

After we applied SP1 however, all of the Data Reader tasks fail AFTER they successfully copy the records with the following error.

[iSeries Invoice Details [1]] Error: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr ppBufferWirePacket)

If I delete the source and destination and recreate identical transforms, they work fine, but I don't feel like rebuilding all of the extracts. Any ideas! The problem occurs in all environments that we've tried.

TIA,
Michael Shugarman
P.S. I just tried the SP2 CTP, but that doesn't fix the problem.

View Replies !

SSIS [DTS.Pipeline] Error
Hi I have created a simple SSIS project on my client that carries out 4 Data Flow tasks, each one copying a few hundred rows from an Oracle 10.0.2 database. This works OK and will also run in debug mode fine.

I have copied the package to the file system on our development server and get the following error when in debug mode:-

[DTS.Pipeline] Information: Validation phase is beginning.
Progress: Validating - 0 percent complete
[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Server.user" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[DTS.Pipeline] Error: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
Progress: Validating - 50 percent complete
[DTS.Pipeline] Error: One or more component failed validation.
Error: There were errors during task validation.
Validation is completed
[Connection manager "Server.user"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Error while trying to retrieve text for error ORA-01019 ".
Validation is completed

If you go to the source of each flow task and select preview you can retreive the data.

Thanks Paul

View Replies !

SSIS DTS.Pipeline To MSAccess Databse

I cannot get a simple package to execute a data pump to an access database from SQL2005.
I have tried it in both SSIS and by running the Export data function.
I have been able to write to this database in the past using dtp in SQL2000 but I am not able to write to it using SQL2005.
What is the deal with the new SSIS?
Does anybody have any ideas I can try to get my export to work.
I have many more to do and I have to migrate over all of my SQL 2000 DTS packages to SQL2005 and some export to MSAccess.

This is the only error message I can find:
[DTS.Pipeline] Information: "component "OLE DB Destination 1" (2196)" wrote 0 rows.

Edit:
I found more errors in the debug section and a post here that discussed the problem as they had run into it. I was able to use part of that and some more research in order to tackle my problem.

I would still be interested in finding out why I suddenly had this problem arise after I upgraded to SQL2005.
This is going to be a real pain as apparently SQL2005 treats NULL as Zero Length and now all of my databsaes that had that set in access will have to be modified to deal with this in the export.

View Replies !

Database Server Performance Against SSIS Process
Dear all,

Right now I built an SSIS package to transform data from external source into local database server. I schedule it to be processed at that database server (ex Server A). Is there any difference performance if I replaced the SSIS package to be processed at another server (ex Server B) ? I'd like to separate the process because I want to reduce workload in Server A by removing the SSIS process to Server B. Am I correct ?

Thanks in advance,

Hery

View Replies !

Anything That You Find In SQL Object Scripts, You Can Also Find Them In System Tables?
I tried all the INFORMATION_SCHEMA on SQL 2000 andI see that the system tables hold pretty much everything I aminterested in: Objects names (columns, functions, stored procedures, ...)stored procedure statements in syscomments table.My questions are:If you script your whole database everything you end up havingin the text sql scripts, are those also located in the system tables?That means i could simply read those system tables to get any informationI would normally look in the sql script files?Can i quickly generate a SQL statement of all the indexes on my database?I read many places that Microsoftsays not to modify anything in those tables and not query them since theirstructure might change in future SQL versions.Is it safe to use and rely the system tables?I basically want to do at least fetching of information i want from thesystem tables rather than the SQL script files.I also want to know if it's pretty safe for me to make changes in thesetables.Can i rename an object name for example an Index name, a Stored Procedurename?Can i add a new column in the syscolumns table for a user table?Thank you

View Replies !

Automate Import Of Perfmon Data To SQL Server
Hi!

I want to collect a *.log file from perfmon, and automatically convert the results into a comma/tab separated file for import into SQL server. I want to make a batch file for it and shedule it to run every night. Does anybody know of a command line/scriptable program that will read the perfmon logfile and convert it into a separated file???

Thanks in advance!

Steinar Andersen

View Replies !

Remote SQL Server 2000 Perfmon Not Working
I have a SQL Server 2000 cluster running on x64 OS. I found the threads in the forum to run perfmon locally by using the x86 version of perfmon (mmc /32 perfmon). However, I cannot run a perfmon remotely from another machine and see the SQL Server perfmon data on any of the nodes in the cluster. The remote perfmon picks up all of the other perfmon variables but no SQL.

I found another thread where somebody asked this question but it wasn't answered. Thanks in advance.

Mark

View Replies !

Major SQL Server/SSIS 2005 Performance Issue
SQL Server 2005 is installed on a brand new 64-bit server (Windows 2003 x64 std. Edition, 2.4 Ghz AMD opteron- 2cpu, 8.8 Gb of RAM). There is barely few hundred rows of data scattered among few tables in one database.

SQL server and SSIS performace grossly degrades overnight and in the morning everything is slow including the clicking of tool bar selection.It takes 3 seconds to execute a simple select statement against an empty table.

It takes15-20 seconds to execute a SSIS package that normally would take 2-3 seconds.

But once SQL Server is restarted, everything returns to normal and the performance is good all day and then the next day everything is slow again.

Thank you for your help.

View Replies !

MS SQL Server 2005: Collect Procedure For &&"dts Pipeline Generate Error
Dear experts,

My MS SQL Server 2005 is generating the following error. may i know what's wrong with it?

"
The Collect Procedure for the "DTSPipeline" service in DLL "XXX:Program FilesMicrosoft SQL Server (x86)90DTSBinnDTSPipelinePerf.dll" generated an exception or returned an invalid status. Performance data returned by counter DLL will be not be returned in Perf Data Block. The exception or status code returned is the first DWORD in the attached data.
"

Thanks in advance for any assistance rendered.
pat

View Replies !

Server Error: Object Reference Not Set To An Instance Of An Object. Trying To Upload Image In Database
Does any one has any clue for this error ? I did went through a lot of articles on this error but none helped . I am working in Visual studie 2005 and trying to upload image in sql database through a simple form. Here is the code

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.IO;
public partial class Binary_frmUpload : System.Web.UI.Page
{protected void Page_Load(object sender, EventArgs e)
{
}protected void btnUpload_Click(object sender, EventArgs e)
{if (FileUpload.HasFile == false)
{
// No file uploaded!lblUploadDetails.Text = "Please first select a file to upload...";
}
else
{string str1 = FileUpload.PostedFile.FileName;
string str2 = FileUpload.PostedFile.ContentType; string connectionString = WebConfigurationManager.ConnectionStrings["GSGA"].ConnectionString;
//Initialize SQL Server Connection SqlConnection con = new SqlConnection(connectionString);
//Set insert query string qry = "insert into Officers (Picture,PictureType ,PicttureTitle) values(@ImageData, @PictureType, @PictureTitle)";
//Initialize SqlCommand object for insert. SqlCommand cmd = new SqlCommand(qry, con);
//We are passing Original Image Path and Image byte data as sql parameters. cmd.Parameters.Add(new SqlParameter("@PictureTitle", str1));
cmd.Parameters.Add(new SqlParameter("@PictureType", str2));Stream imgStream = FileUpload.PostedFile.InputStream;
int imgLen = FileUpload.PostedFile.ContentLength;byte[] ImageBytes = new byte[imgLen]; cmd.Parameters.Add(new SqlParameter("@ImageData", ImageBytes));
//Open connection and execute insert query.
con.Open();
cmd.ExecuteNonQuery();
con.Close(); //Close form and return to list or images.

}
}
}

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.Source Error:

Line 32:
Line 33: string str2 = FileUpload.PostedFile.ContentType;
Line 34: string connectionString = WebConfigurationManager.ConnectionStrings["GSGA"].ConnectionString;
Line 35:
Line 36: //Initialize SQL Server Connection Source File: c:UsersManojDocumentsVisual Studio 2005WebSitesGSGABinaryfrmUpload.aspx.cs Line: 34
Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
Binary_frmUpload.btnUpload_Click(Object sender, EventArgs e) in c:UsersManojDocumentsVisual Studio 2005WebSitesGSGABinaryfrmUpload.aspx.cs:34
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

View Replies !

Object Reference Not Set To An Instance Of An Object. MSSQL Server Report Builder
When I try and run Report Builder Reports i get this error message "Object reference not set to an instance of an object. "

I can run reports locally but not from Report manager

here is the stack trace info

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces) +18
Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e) +358
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +482
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +958
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

View Replies !

Report Server Issue Object Reference Not Set To An Instance Of An Object
Hi all,

I'm getting this problem 'Object reference not set to an instance of an object.' whenever I try to review a report and I checked the log file and this is what it had

w3wp!ui!1!11/14/2006-10:54:20:: Unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
   at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
   at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
   at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
   at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Some previous forums stated checking the webconfig file but the web config file look okay. Is there another way to fix this.

Much Thanks,

Carl

View Replies !

Help! SQL Server Error - [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object Name ...
Dear all,On Win2000 server with SP3, I am trying to access a SQL Server 7.0database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO2.7. In SQL Server Enterprise Manager, there is a login named "Tester".In its property window, NO "Server Roles" was assigned but its"Database Access" was set to "TestDB". This login was also made as theuser of "TestDB" with "public", "db_datareader" and "db_datawriter"selected as its "Database role membership". All the tables I am tryingto access in "TestDB" were created under "Tester".My code is like:Set conn = New ADODB.Connectionconn.Open "DSN=TestDSN;UID=Tester;PWD=test"Set cmd = New ADODB.Commandcmd.ActiveConnection = conncmd.CommandText = SQLset rs = cmd.Execute()If I set the SQL to something like "SELECT * FROM tbl_test", I alwaysget an error of "-2147217865" saying "[Microsoft][ODBC SQL ServerDriver][SQL Server] Invalid object name tbl_test". If I set the SQL to"SELECT * FROM Tester.tbl_test", everything runs properly. Could anyoneplease kindly advise why the first SQL is not working? Or in otherwords, why must I prefix the table name with its owner while the DBconnection is already made under that owner name? Thanks in advance.Tracy

View Replies !

SSIS Design : Object Reference Not Set To An Instance Of An Object
In visual studio 2005, I create a new Integration Services Project. It tries to create the first package by default "Package.dtsx". The "Package.dtsx[Design]" tab displays

Microsoft Visual Studio is unable to load this document

Object reference not set to an instance of an object

I try to create new SSIS package or edit an existing one (from tutorial), I get the same error in the SSIS graphical user interface tab.

Thanks for your help.

View Replies !

How Do I Write Multiple Pipeline Buffer To Multiple Targets Based On A Calculated Value In The Pipeline Buffer
The scenario is as follows: I have a source with many rows. Each row has a column called max_qty_value. I need to perform a calculation using another column called qty. This calculation is something similar to dividing qty/(ceiling) max_qty_value. Once I have that number I need to write an additional duplicate row for each value from the prior calculation performed. For example, 15/4 = 4. I need to write 4 rows to the same target table as in line information for a purchase order.

The multicast transform appears to only support fixed and/or predetermined outputs. How do I design this logic in SSIS to write out dynamic number of rows to a target table.

Any ideas would be greatly appreciated.

thanks

John

View Replies !

HELP! How To Find The Owner Of An Object??
I need to remove some login ID on a SQL2000 server, but it did not let me
because the login ID owns objects in one or more databases.

How can I find out what objects does the login ID own?

Thank you

View Replies !

How Can I Find When An Object Is Last Modified
Hi EveryOne,

How can I find when an Object is Last modified say a Stored Proc( when it is modifed)

Thanks in Advance
DP

View Replies !

Object Permissions, Can't Find
I'm trying to identify the objects in master that the role public has select permissions on, but when I run this query, I get 4 results where the default schema is null and the major_id column does not correspond to any records in the sys.all_objects table. Where else can I look to find what objects these are. DBO is listed as the grantor.

I appreciate your help.

SELECT *
FROM SYS.DATABASE_PERMISSIONS P,
SYS.DATABASE_PRINCIPALS R
WHERE P.GRANTEE_PRINCIPAL_ID=R.PRINCIPAL_ID and
permission_name='SELECT' and class_desc='OBJECT_OR_COLUMN' and
r.name='public'
order by r.name desc

View Replies !

DTS Error: Can't Find Object Named: ...
I am receiving an error when using DTS to copy all objects. I receive an error stating that DTS can't find an object with a certain name. However, if I select all objects individually, it works fine. I did discover what was causing the problem, but it has happened more than once, and I'm not sure how to correct it. Apparently, the name of the object in the sysobjects table contains a space or spaces, even though the actual object name does not. When DTS discovers this, it tries to find an object match with the part of the name after the space, and, of course, it can't. So far, this has only happened with foreign keys. I can drop and recreate the foreign key constraint and this corrects the problem, but I would like to know if there is a was to prevent this from continuing to happen.

View Replies !

How To Find Who Is Deleted The Database Or Object?
Hi,
I wanted find the log information if anybody deleted my database or bojects in my server.
Is it possible we can able to find this details in my previous log or any sys tables ?
Thanks

View Replies !

Cannot Find The Certificate Object When Creating Endpoint
Hi,

I try to implement mirroring using certificate authentication.
When I do this query :

create certificate Principal_cert with subject = 'Principal certificate', start_date = '2007/11/01', expiry_date = '2020/11/01';
GO

Create endpoint endpoint_Princ state = started

as tcp(listener_port = 7024, listener_ip = all)

for database_mirroring (authentication=certificate Principal_cert, encryption = disabled, role = all);

GO

I have this error :

Msg 1088, Level 15, State 1, Line 1

Cannot find the object "Principal_cert" because it does not exist or you do not have permissions.

I have also noticed that the error does not occured when I try this in the master database.

So, I have two questions:

1. Why SQL server does not find a certificate that just been created ?
2. Should the certificate be in the master database or in the database being mirrored ?

Thanks for any help.

View Replies !

The Microsoft Jet Database Engine Could Not Find The Object 'MSysReplicas'
I am getting the following error in the replication process between SQL 2000 and MS Access database(as a Linked Server)

The Microsoft Jet database engine could not find the object 'MSysReplicas'. Make sure the object exists and that you spell its name and the path name correctly.

The Microsoft Jet database engine could not find the object 'MSysReplicas'. Make sure the object exists and that you spell its name and the path name correctly.
(Source: MS.Jet.4.0 (Agent); Error number: -1305)
---------------------------------------------------------------------------------------------------------------

When I click Start Synchronizing it works fine for few hours and throws the same error.

Any help is appricitated

thanks

View Replies !

Cannot Install SQL Server Express On Vista Ultimate - Cannot Find MS SQL Server Native Client
I am trying to install SQL Server Express - (the non ADV version) and get the following error.

"An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli_x64.msi'".

I have 64 bit Vista Ultimate running on an HP dv9000.

I am using the download from the bottom of the download page for SSX where it says 64 bit version.

Prior to this I got the. "64-bit ASP.net is registered. Required 32-bit ASP.NET to install Microsoft Reporting services 2005(32-bit)." messagd during the pre-install scan. From what I gather in the posts, the reporting issue is different from my installation package problem.

I have been trying to prove a point to friends about how far you can go with SSX but am having no luck installing it. This whole process took 1 hour in XP but I've been stymied for 2 days.

I would appreciate being pointed at the right downloads for what seems to be a simple install.

View Replies !

Performance Monitor -- Buffer Cache Object
Hello,
Does the performance counter Buffer cache object refer to Data cache and procedure cache or just refers to Data cache???

I was of the opinion that Buffer cache means data cache and Plan cache means procedure cache. Can someone throw some light???

Regards

Jaideep

View Replies !

Bad Performance Selecting A Complex View Over Linked Server. Reason Is How SQL Server Handle Such A Statement
Hello,
I had setup a linked server to a Sybase ASE 12.5.3 via Sybase OLE DB provider. But I have bad performance when I select a complex view from the remote site.

select * from RemoteServer.database.dbo.remoteview where ID = 5

On the sybase system itself a "select * from remoteview where ID = 5" is very fast.

Furthermore a OPENQUERY-select is also fast

select * from OPENQUERY(RemoteServer, 'select * from database.dbo.remoteview where ID = 5')

I try to find out whats happening. With Sybase auditing and TCPIP analyse I found what happens.

OPENQUERY
---------------------
1. Step : MS SQL server sent "select * from remoteview where 0 = 1"
I assume that it get the schema of of view.
2. Step : select * from remoteview where ID = 5

OK, fine. Statement is fast.

Direct statement
------------------------
1. Step : MS-SQL server sent "select * from remoteview"
"select * from remoteview" needs very, very, long to deliver the data as there is no good where-argument. It seems that - for what reason ever - MS SQL Server waits for the first row to be delivered. I saw the row in one of the TCP/IP packages. As ther is only one row I assume that MS SQL Server cancel this query after getting the first row.

2. Step : select * from remoteview where ID = 5

In this case the first step makes the complete statement extremly slow.

But why is the first step implemented as it is ? Why isn't it enough to send "select * from remoteview where 0 = 1" in this case too ?

Regards
Wolfgang Kunk

View Replies !

Find SQL Server Product Key Installed On Server
Hello;

I am trying to get information of SQL Server licensed key which is installed on our servers. I am using SQL Server 2005 standard edition. Is there a way to find out the product key which is installed on servers. I did some searches and found some thirdparty software to get that information but I don't want to use them on production, is there a way which microsoft recommends.

Thanks

View Replies !

Linked Server/SQL Server OLE DB Performance Problem With Parameters?
Hi,
I am interested if anyone else has come across performance problems with the SQL Server linked servers to SQL Server. I suspect that the OLE DB Provider that I am using perhaps has some performance issues when passed parameters.

I have set the dynamic paramters option on, and use collation compatible.

View Replies !

Replication Merge Instance Is Not Find In Performance Viewer
Hi all,I set the configuration for Merge replication for Subscription onone database andI have created the Merge replication for publication on anothermachine.And I updated columns of subscription database table and I findpublication machine database table also updated with subscriptiondatabase table, here my problem starts,My problem is when I run replication for merge transaction, I have tofind instance of the Windows on my machine in Performance Viewer (tosee performance viewer goto control panel ->Administrator->performancein this select performance counter as SQL Server: Replication merge)but I am not finding the instancePlease some body help me out.Rasheed

View Replies !

Performance Between SQL Server CE 2.0 And SQL Server Mobile 2005

We have recently updated an application from SQL Server CE 2.0 to SQL Server Mobile 2005 and we are seeing a huge decrease in performance? Is this normal? Database query that used to take 8 or 9 seconds are now around 20 secs, the database is only about 5 MB and the two tables in this particular query have 20 rows and 14K rows respectively. The query is basically:

select * from table1 join table2 on table1.myint = table2.myint

myint is the Primary Key of table2 and I have even created an index on myint for table1, any ideas?

Thanks - MTW

View Replies !

SQL Server Mobile Merge Replication Walkthrough, Cant Find The .NET Framework Data Provider For SQL Server Mobile Edition.
Hi,

View Replies !

Upgraded To SQL Server 2005. Updates No Longer Work. Error &&"Could Not Find Server 'DEVDB' In Sysservers. Execute Sp_addlinkedse&&"
Hello!

We just upgraded to SQL Server 2005 from SQL Server 2000. The DB was backed up using Enterprise Manager and restored with SQL Server Management Studio Express CTP. Everything went as expected (no errors, warnings, or any other indicator of problems).

The DB resides in a DB Server (Server1) and the application we are running is a Client/Server system where the AppServer resides on Server2.

During the application's operation all read, create, and delete transactions work fine but no update works. When viewing details in Trace Log I see this message after attempting any update:

Could not find server 'Server1' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. (7202)

Any help is greatly appreciated,

Lucio Gayosso

View Replies !

Performance Monitor Counter Requirement (Error) - Can't Find Perflib To Edit!
I keep encountering this error when I try to install another SQL Server after uninstalling Express: - Performance Monitor Counter Requirement (Error)
Messages
Performance Monitor Counter Requirement

The System Configuration Check for Performance Monitor counter registry
value has failed. For details, see How to: Increment the Counter
Registry Key for Setup in SQL Server 2005, in the readme file or in SQL
Server Books Online. I've looked up the solution and it
says to change the Perflib entry in the register...only I don't seem to
have one! this is highly annoying as I can do nothing to remedy the
situation. Any ideas?

View Replies !

Invalid Object Name (sql Server
I am attempting to call a user defined function from a stored procedure in the same database, and I get the following error:Invalid object name 'dbo.fn_NewSplit'.I've tried calling it as dbo.fn_NewSplit, fn_NewSplit etc. I also setup another that had my DB login IE ihomesm_maindb.fn_NewSplit and get the same results. Interestingly there is another previously built stored procedure calling the same function with apparantly no problems.
Also, I have tried to execute this stored procedure with both my .net application and within the query analyzer with the same error.

View Replies !

SQL Server Object Security
Hello,We are using Access Front End (ADP Project) and SQL Server 2000backend. SQL Server is using NT Security.We do not want the users to access the the underlying tables. So, wewent to each table and unchecked 'Select'. We also placed an 'X' inall columns for guest and public account.Next, we created a view. The view has 'Select' permission given to theusers (it is also enforcing some business rules on whether a recordshould be returned).Access XP is behaving as expected - the tables are not showing up, anda report can be created using the view.Here is the test situation we have set up:User 'test_a' has 'select' allowed on the view.Built in user 'public' and 'guest' were not allowed on the view.When we configured the view as stated above, 'test_a' did not haveaccess to the view (even though we specifically granted). It appearsthe 'public' must also have at least 'Select'.It is not the case for a member of BUILTINAdministrators.Is this expected behavior? Does SQL server not follow the NT Securitymodel? Or am I simply missing something with the 'public' role?Should I create roles, then add users to the roles (so I can removepublic). This seems a little different than the NT model ofusers/groups.Also, thanks to Simon and Pete for their previous replies.JeffJoin Bytes!

View Replies !

Dropping An Object In Sql Server
Hi,

I am getting errors when I try to drop a column in sql server table.

Server: Msg 5074, Level 16, State 1, Line 1
The object 'DF__bdp_langu__langn__29572725' is dependent on column 'langname_ge'.
Server: Msg 4922, Level 16, State 1, Line 1
ALTER TABLE DROP COLUMN langname_ge failed because one or more objects access this column.

I thought the object to be a constraint and tried dropping it first by "alter table drop constraint" command.

But query analyser says that the concerned object is not a constraint. How do I drop this object?

Thanks and Regards,
Celia

View Replies !

SQL Server Object Permissions
Hi all,My project modules in MS-Access rely heavily on DAO permissions. Now the access front end is being hooked up to a SQL Server 2005 back end, and I'd like to sync the permissions of linked table objects with the corresponding views when they are created/recreated.I'm vaguely aware there are a substantial number of differences between the the SQL Server and Jet security models. Initially, I'd like to create a lookup table to handle this. My problem is that I don't seem to be able to find much info on groups and object permissions in the SQL Server security model - perhaps I'm asking the wrong questions.:confused: Can anyone provide a link to a decent site for SQL Server novices?Ta

View Replies !

SQL Server 7.0 And Excel Object
Hi All,
Here is a problem:

I am running number of Excel reports (Pivot Tables) from SQL Database.
Is there any way I can keep Excel objects (Pivot Shapes with no data)
as a part of database as a BLOB or some kind of OLE contaner and call
them from there.

Any input greatly appreciated

Boris

View Replies !

Calling Com Dll Object From SQL Server
Hello All,

I wonder how this can be accomplished.

We have created a class lib wrapper that imports the com dll. Upon placing the assembly in sql 2005, both the wrapper Dll and the com dll (probably a converted version) gets placed inside the sql 2005 assembly store. Next a CLR sp references the 2 assemblies above, but within the call to the CLR sp things fail with exception:
System.UriFormatException:
Invalid URI: The URI is empty
The works fine from a windows forms app.
What is the methodology to invoke a COM Dll? How far are we from implementing this in SQL CLR

Thank you,

Lubomir

View Replies !

SQL Server Management Object (SMO)
Regarding Server Management Object (SMO) and (DMO) Data Management Object.

While Querying the Named instance of particular SQL Server it is giving Exception "An exception occurred in SMO while trying to manage a service" for this what is the solution...?

View Replies !

Could Not Find Server 'System' In Sysservers. Execute Sp_addlinkedserver To Add The Server To Sysservers.new
HiI am getting the above error message when I try and bind a stored procedure to a gridview:string connectionString2 = ConfigurationManager.ConnectionStrings[project].ConnectionString; SqlConnection con_room_code2 = new SqlConnection(connectionString2); SqlCommand cmd_sofa = new SqlCommand("report", con_room_code2); cmd_sofa.CommandType = CommandType.StoredProcedure; cmd_sofa.Parameters.Add(new SqlParameter("@code", SqlDbType.VarChar)); cmd_sofa.Parameters["@code"].Value = Session["code"].ToString(); SqlDataSource1.ConnectionString = connectionString2; SqlDataSource1.SelectCommand = cmd_sofa.ToString(); plreport.Visible = false; plreport.Visible = true; test.Text = Session["code"].ToString();does any1 know why this is? thanks

View Replies !

Can't Find SQL Server: SSIS Pipeline Performance Object In Perfmon For 64-bit Server

I can't find 'SQL Server: SSIS Pipeline' performance object in performance monitor on a 64-bit SQL Server. I see it on a 32-bit. Does anybody know why? Thanks

I can't find 'SQL Server: SSIS Pipeline' performance object in performance monitor on a 64-bit SQL Server. I see it on a 32-bit. Does anybody know why?

Thanks