Answer Questions

• PraveenPatel Multithreading SMO

  I have been experimenting with multithreading the SMO database objects to increase performance in my application but i never seem to beable to push the cpu load of the system above 25% (4 processor server). Has anyone successfully been multithreading these objects Niklas, SMO can be used in multithreaded scenario, but improvements in performance highly depend on the design on your application. SMO applications are usually not CPU-bound, and the best strategy is usually to optmize the number of queries to the SQL Server SMO has to perform. Here is a couple of great articles written by one of SMO architects Michiel Wories: http://blogs.msdn.com/mwories/archive/2005/05/02/smoperf1.aspx http://blogs.msdn.com/mwories/ ...Show All

• &#169&#59; Ţĩмό Şąļσмāĸ How to dynamically assign database name in query or store procedure?

  Hello, I am not sure if this possible, but I have store procedures that access to multiple databases, therefore I currently have to hardcode my database name in the queries. The problem start when I move my store procedures into the production, and the database name in production is different. I have to go through all my store procedures and rename the DBname. I am just wonder if there is way that I could define my database name as a global variable and then use that variable as my DB name instead of hardcode them something like Declare @MyDatabaseName varchar(30) set @MyDatabaseName = "MyDB" SELECT * from MyDatabaseName.dbo.MyTable Any suggestion Please. Thanks in advance Thanks Uma and Joeydj ...Show All

• AndrewVos Unlocking login on Status Tab always gets reset to Locked Out

  I've been having this issue lately with a new login. We have set it up to use the Windows Password and Expiration Policy and I give it an initial strong password. In testing this new account I would purposely input the wrong password into an application 3 times thus causing the login to become locked out. I would then go into the SQL Management Studio, go to the Status Page and uncheck the 'Login is locked out' flag. If I would then click the 'OK' button to close the properties, I would get an error message that the password is not complex enough. This is strange since I never changed the password in the first place, I just unchecked the 'Login is locked out' flag. That's issue#1. I then decided that I would give Management Studio the b ...Show All

• FernTheBrute Server Express

  hi, my sql server express installation seems fine on the surface. I have activated "sa", etc. yet when i try to connect from the network (local, pings fine) that i get the error like "Server not found or access denied!" I am using OleDB base class for my connection. Could someone help Regards, Ehmer Be sure about servername (and instance if any), username and pwd (if set only fro SQL server login). You can first check with SSMS (SQL server managemnt studio - download if you haven't already do so). Here is a connection sample: oCon = createobject("ADODB.Connection") oCon.ConnectionString = "Provider=SQLNCLI;server=machineme\sqlexpress;Integrated S ...Show All

• GTrz Auto-Generate MDX Query from Cube OWC Settings?

  Can I somehow auto-generate an MDX query based on current settings in the AS OWC cube browser Why If so, I will want to use the AS OWC cube browser to filter the data down to < 66K rows, then auto-generate an MDX query from the current browsed settings, copy and paste the MDX script into MS Excel's OLAP query, and use it. I'm trying to avoid the 66K row limitation in Excel 2002. If this is innappropriate, is there another way, besides raw MDX hand-coding, to accomplish the same thing You can start a trace using the SQL Server Profiler, and see the MDX query created by OWC. Then use that query in Excel Chris. ...Show All

• jiao Confusion over @@ROWCOUNT test

  I have a pair of services. One is an initiator of a conversation, another is a target. I have a pair of message types, one sent by the initiator one sent by the target. I have a pair of queues corresponding to the above services. Both queues have activation stored procedures associate with them. The intiiator sends its mesage to the queue that the target service is defined on. The activation procedure successfully retrieves the message, does some work and then sends a reply message on the same conversation to the initiating service. At this point behavior seems to become strange. Some of the time the send from the target service produces the "zero length message" error and indeed at times the message body is em ...Show All

• J A Y BI Portal connected to analysis services 2005

  Anyone has connected the bi portal with analisys services 2005 I have a security problem. Thanks I'm a bit confused, I thought you said earlier that you created and tested the connection OK, now you say that you are getting an error when you create the data source. Why don't we try just setting the absolute minimum settings in the connection string and see if we can get a connection created without an error. Try a connection string like the following: Provider=MSOLAP.3;Initial Catalog=OnAlert2;Data Source=w2k3sql2005; Sorry, I don't know. I cannot enter a connection string directly into the advanced box, but if I connect first, or if I click Advanced and then browse and select a .oqy file, I can then edit ...Show All

• Toby77006 a very simple question

  hi, there this is a very simple question and Im sorry if it sounds to simple to post. My problem is that my query returns a long result set in a very long row, the row is so long that I cant see all the result, when I try to expand the page, it still isnt enough to see all the results, and scrolling dosnt help either, I tried select all and copying the reults to a file, but all that does is only copy what can be done on screen. what I would like to know is (1) how can adjust query analyser so that i can see all the reults (2) is it possible to get the results returned as several rows, rather than one row, thanks this is my query: select * from employees where employeeid = 1 for xml auto, elements thanks very much for any ...Show All

• AndyL Full-Text Search

  I am trying to create a full text index on a column in a table and the data type is Image, but the TYPE COLUMN FILE EXTENSION is in another table. there is no way of creating the type in the same table. the wizard will not allow me to pick the data type field from another table. is there a work around this issue Emadkb Sattva, The behievor you are experiencing with your SQL Server 2000 Enterprise Manager (EM) is typical and expected. The EM cannnot "see remote" services such as the "Microsoft Search" (MSSearch) service on remote servers when accessed across the internet or the server is registered as an IP address. However, SQL FTS is still functional and you can use the system sto ...Show All

• Bubo Integrated Security doesn't work - "Not associated with a trusted SQL Server connection." Error

    Hi, I have a piece of Java code that needs to connect to SQL 2000 (SP4) using Windows Authentication. It's running on Windows Server 2003 SP1. I tried JDBC v1.1 and followed the code from the following blog: http://blogs.msdn.com/angelsb/default.aspx p=1 But still get this error as shown below. Any help appreciated. I am using JDK1.4.2, "sqljdbc_auth.dll" is located under "E:\SQL2005JDBCDrv\sqljdbc_1.1\enu\auth\x86", also made a copy under "E:\JavaTest" and "C:\Windows\System32" but still won't work. Cheers Allan   =========================================================== E:\JavaTest>javac -classpath ".;E:\JavaTest\sqljdbc.jar" TestW2.java E:\JavaTest>java -classpath ".;E:\JavaTest\sq ...Show All

• Beast Forever Output and Error Output write the same table at the same time, stall the process.

  Hi I have Lookup task to determine if source data should be updated to or insert to the customer table. After Lookup task, the Error Output pipeline will redirect to insert new data to the table and the Output pipeline will update customer table. But these two tasks will be processing at the same time which causes stall on the process. Never end..... The job is similiart to what Slow Changing Dimention does but it won't update the table at the same time. What can I do to avoid such situation Thanks in advance, JD Jamie Thomson wrote: You need to do the update and insert serially - meaning in 2 different data-flows. Push the data for the update into a raw file and then consume it in a seperate dat ...Show All

• Maithili Scheduled Subscriptions, ScheduleRecurrence and the ICalender Recurrence Rule

  I am working on getting a subscription management interface put together for my product's implimentation of Notification Services. I have a question about the capabilities of the Scheduled Subscriptions, specificaly about the flexibility of the ScheduleRecurrence property. below is a copy of recurrence options from books online... ICalendar Recurrence Options FREQ=DAILY; FREQ=WEEKLY;BYDAY= DaysOfWeekList ;[BYMONTH= MonthsOfYearList ;] FREQ=MONTHLY;BYMONTHDAY= DaysOfMonthList ;[BYMONTH= MonthsOfYearList ;] FREQ=YEARLY;BYMONTHDAY= DayOfMonth ;BYMONTH= MonthOfYear ; It would apear that Daily is the smallest unit of recurrence supported, but we would like to have a recurrence option in a period o ...Show All

• Julian Ladbury replication hangs on one table

  publisher - sql2000 sp4 distributor - sql 2005 sp1 subscribers - mix of sql2005 sp1 and sql 2000 sp4 we have a database with around 300 tables and replicate it to around 10 different subscribers. some in the same datacenter and others in different offices. We have around 50-60 different publications for this. Some have 20 or so tables others have only one table if they are large tables. Tables range in size from a few hundred rows to over 20 million. Some tables replicate a few commands, others 100000 or more commands on a daily basis. Around 6 weeks ago we started having problems with one table. It's 1.4 million rows and replicates around a few thousand commands on a daily basis. We saw a backlog of around 150000 to 400000 commands. We ha ...Show All

• AbhijeetG Reducing storage space by moving rarely required columns to separate table while sharing Primary Key constraint

  Dear all, In my current database design, there is one table (PState) which has a Primary Key (int) and a few other fields. During development, a pattern started to arise; for certain rows in PState, I wanted to specify an additional set of columns (over 10 of them with quite large lengths) for each row in PState. However, as these additional columns would only be required in approximately 20% of the rows of PState, there would be plenty of NULL values in PState if I would make this table wider than necessary. So, I decided to create a separate table with those optional columns (PStateWFI). In order to attach these additional columns in PStateWFI to PState in the cases they were needed, I would obviously have to create a Foreign Key c ...Show All

• loonysan I can't seem to find exactly what my problem is in the following

  I have trying to figure out where the error is exactly. The error message shows a '/' and there isn't one of these in my stored procedure at all The error is: Msg 102, Level 15, State 1, Line 5 Incorrect syntax near '/'. Here is the rather lengthy code. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo] . [TEST] @StartDate DateTime , @EndDate DateTime AS BEGIN SET NOCOUNT ON ; DECLARE @sql varchar ( 8000 ), @select_clause varchar ( 8000 ), @from_clause varchar ( 8000 ), @gift_clause varchar ( 5000 ), @is_welcome bit , @pckg varchar ( 100 ) declare @bk_id int , @it_id int , @qty int , @desc varchar ( 100 ), ...Show All