Answer Questions

• sidwang Got BIDS working, was there another way?

  i re-installed the SQLEXPR_TOOLKIT.EXE several times(4) trying to get the BIDS part to work. Each time i had the issue of it looking for the devenev.exe as others have mentioned. I gave up on a 5th install and went for the unsupported option of running vs_setup , after the toolkit.exe dumped all the install files to its temporary directory i went in there and ran it sperately... but essentially i did it the same way as this method... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=368549&SiteID=1 while this did work, it seems to be the unsupported way. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=665067&SiteID=1 Im not opposed to going back and doing it right, but was there ever a conclusion as to why the BIDS prog ...Show All

• &#169&#59; Ţĩмό Şąļσмāĸ Urgent - No mapping between account names and security IDs was done error !

  Hi There When i go to configuration manager and change the sql server service to run as a domain account i get the following error: No mapping between account names and security IDs was done. This is Sql Server Express running on a domain controller - Windows Server 2003 R2. Everything i find ont he net refer to IIS, DHCP etc etc , i cannot find the issue regrading sqls server configuration manager. Thanx Was the machine a DC when you installed SQL Server on it, or was it made a DC afterwards Thanks Laurentiu Two things - ensure that the user account you're starting wityh has permissions to log on locally. If in doubt, add them to a local group that can. Second - if this i ...Show All

• enric vives Does the SS Engine cache clr proc execution plans?

  Hi. When I checked the execute plan for a clr proc I wrote: Exec MyCLRProc All it had was one item "T-SQL Exec Proc".... How does Sql 2005 store the execution plan for all the sql, etc. contained in the clr proc itself Does it create a new execution plan every time a clr proc is excecuted Wondering, Thanks, Steve W. It's the same as any other ad hoc/dynamic SQL.  If the plan is parameterized it can be reused for multiple parameter values.  Otherwise, it will only be reused if the same parameter values are used.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     &l ...Show All

• Gregg Hamilton Backup without tabledata

  Hello. I am using SQL express and we have developed our app. til now. Now we have to move the database to the another server and go live. It is fine just to backup the database but how to do it without tabledata We have many test posts there and when going live we would like to start from beginning. Is there any way to do it or do we have to delete all data before backing up Hi! Isn't there any Export function in SQL Express or MSSQL 2005 Management Studio Hi This is possible. Under MSSQL 2005 Management Studio select the Database > All Tasks > Generate Script and Walk thru the all options. Doing this will generate the script which you can use on empty database to get t ...Show All

• RayRay1039 How To Filter An EXEC Table

  Hi All, How do I filter an EXEC table as to put the returned value into a variable I have to filter an EXEC table because I am using a table variable to define which table tto select. Help appreciated. Very good; try this: declare @Conn varchar(1000) set @Conn = 'This is the table connection' DECLARE @strSQL varchar(500) SET @strSQL = 'SELECT Name FROM ' + @Conn + ' WHERE Name = ''System''' create table #results (results varchar (255) null) -- provided 255 is large enough! insert into #results EXEC(@strSQL) thanks .. will give that a try Donaghy: If you can post your code that doesn't work correctly we can p ...Show All

• wagnerjp delete statements deletes more rows than select using the exact same criteria

  I have a situation where a select statement returns about 30 rows of data but a delete statement using the exact same criteria deletes 190 rows from the same table. Here is my select: SELECT * FROM PS_COST C WHERE C.ASSET_ID = '000000000315' AND C.BUSINESS_UNIT = '00010' AND EXISTS (SELECT * FROM PS_OPEN_TRANS OT WHERE OT.CALC_DEPR_STATUS = 'P' AND OT.DTTM_STAMP = C.DTTM_STAMP AND OT.TRANS_TYPE = C.TRANS_TYPE AND OT.ASSET_ID = C.ASSET_ID AND OT.BUSINESS_UNIT = C.BUSINESS_UNIT AND OT.BOOK = C.BOOK) Here is my delete: DELETE PS_COST WHERE ASSET_ID = '000000000315' AND BUSINESS_UNIT = '00010' AND EXISTS (SELECT * FROM PS_OPEN_TRANS OT WHERE OT.CALC_DEPR_STAT ...Show All

• AlexDav Mapping a user to a login

  I have created a login and a user on a database using SMO. I am having trouble mapping a database to the login. When you create a login from the GUI using SQL Server Management Studio Express CTP the user is automatically created and the database is mapped to this login from the user mapping tab. When I create the login programmatically this is not the case so I need to create the user.  How do I map the database to the login. I set the default database property on the login but this does not do it. Thanks, Michael Gustafson   what property of the Login is used to show what databases are mapped also is there a way with SMO to check and see if a password is blank Granted the odds ...Show All

• Ruslan Popov SQL Syntax Error

  Thanks in advance Below is basic sql script. I don't know why it has syntax error. Please explain why and advise correct answers. DECLARE @Date_Range VARCHAR (200); DECLARE @RowCount int ; SET @Date_Range = '(Date BETWEEN CONVERT(DATETIME, ''2006-11-1 00:00:00'', 102) AND CONVERT(DATETIME, ''2006-11-30 00:00:00'', 102))' ; SELECT @RowCount = Count (*) FROM MyTable WHERE (EmployeeID = 1111) And + @Date_Range; Line 9: Incorrect syntax near ';'. ManiD -You are NOT correct! Mugambo's suggested WHERE clause will return all records, including all times, starting midnight (00:00:00.000) on the @LoDate up to, but not including midnight (00:00:00.00 ...Show All

• Checkmate setting a null value for mirror_address

  Hi I set up some routes incorrectly on one of my servers and included a mirror address when i shouldnt have. now i cant get rid of the mirror address - when i try alter route remote_route with mirror_address = null i get an error saying incorrect syntax near null Does anybody know how i can clear out the mirror address for a route Thanks Anthony Thanks - i thought that would probably be the solution after i posted the question Looks like a limitation in our design of the ALTER ROUTE statement. I'll investigate this. Until then the workaround would be to DROP and re-CREATE the route. Rushi ...Show All

• Mongsreturn Running job error in schedule

  Dear All, I set the scheduler to run a stored procedure and it casyes error. Failed to run the stored procedure but when running it manually from the query analyser it works just fine. This is the error. SQL Server Scheduled Job “Job ABC” (0xE708F39963C95A4390BC3C99E6A029AC) – Status: Failed – Invoked on 2006-12-10 03:00:00 – Message: The job failed. The job was invoked by Schedule 7. Could anyone please advise what should be the problem Regards, LG Dear Satya SKJ, Thanks for response. Actually the job run 20% successfully. We run the calculate and update the tables and only 20% of the table is properly updated after that it fails. But if we use the same script to run on the ...Show All

• DamonPeng How to get concatinated value in a group footer

  Hi, I want to display a concatinated value of strings (DB field) having a "/" in between, for each group separately in the group footer.I tried using custome code.I was calling that code in detail.In detail it was showing correctly i.e running concatenated value for each record.But when i used the same global variable in group footer it's taking previous group's concatenated value and first groop footer shows a blank string.I guess its because groop footer thing is getting executed before the detail part.so can you please give me any solution for this. Thanks in advance Suchi I can't think of any other RS options and could not get the Join function to operate on a field or its value. Maybe you can return t ...Show All

• hr0nix test deployed packages

  hi all, i've followed the tutorial in SQL Server 2005 for deploying packages. everything works ok until i came to lesson 3 installing packages. i could connect to SSIS but when i expanded the Stored Packages node, i get an error message saying : Login timeout expired An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. named Pipes Provider: Could not open a connection to SQL Server[2]. (Microsoft SQL Native Client) my database engine has an instance name. will this affect SSIS connectivity thanks! thanks a lot, Jam ...Show All

• perrs Connect to database takes long for non-admins

  Hi, any idea why it might take longer to connect to a SQL Server for a non-administrative user than for a dbo Same machine, just different logins... Thanks, Hi Jens, well, we'll try full logging later... It has nothing to do with the database being closed for inactivity since if you logon twice it will take the same time... Thanks, Thomas Interesting... I'm trying to troubleshoot what may be a similar issue. Here are some specifics... + just set up a brand new 64bit server (Windows 2003 R2 64 bit O/S and SQL 2005 64 bit, Std Edition); SQL is the only thing running on this server. + installed this new server in the same AD domain as an existing SQL 2000 db + on my workstation using SQL ...Show All

• Alessandro Camargo Access connection count at the same time

  I want to learn access connection gives how many user to connect at the same time. http://www.narcv.com/ Access is mainly limited through the performance of the server, the logical limit is AFAICR 32767, but in most cases you will be throttled through the physical limitations of the server. if you have conneciton pooling on the client side enabled, and you will go through the pool, you will be limited on the client side to the numbers of connections specified for the pool. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• FergusLogic sqljdbc DriverManager.getConnection Hangs after mirror failover.

  When performing a failover the DriverManager.getConnection method never returns from it's call. I used a modified version of the test program included in the sqljdbc help file (below). If the principle server is server2 and a failover is performed, the program works just fine. If the priciple server is server1 and a failover is performed, the hang occurs. The sql servers are not on a domain, are in the same workgroup, have certificates setup between them.  Sqljdbc version used is 1.1.1501.101.  I rolled back to version 1.1.1320.0 and the DriverManager.getConnection exceptioned.  Not sure if this is a setup issue or a common problem. Anyone have any suggestions or seeing similar issues Thanks - tc Version 1.1.1501.101 - Syst ...Show All