Answer Questions

• Smegg Stored Procedures Not Converted or copied to SQL Server 2005

  I am converting  about 50 databases from Windows 2000 and from SQL Server 2000  to a totally new 4 processor Server 2003 with SQL SErver 2005.  I used the Database Copy Wizard in SS2005 to do the transfer.  After making sure the databases were big enough to hold the new Masterdatabase everything went well... except none of the stored procedures from any of the 50 databases copied from SQL Server 2000 to SQL Server 2005.  What did I do wrong   And how do i fix it.  Also, even though I changed the default database, the wizard did not reflect the new SAN location for the Data and Log files.  I had to do each one manually. When you specified the location names, I'm assuming that the SAN was on-lin ...Show All

• Sam4u2e SQL 2000 - How to Reduce data files from 2 to 1?

  Hello, I have an 80GB database which consists of two data files. We recently encountered a bug associated with the use of multiple files (see KB Article #818096). Microsoft has a fix in SP4, but our vendor will not certify their application for SP4 (at least not without lots of $$). Therefore, I want to reduce the number of datafiles from two to one. I tried to restore the DB to a new database with only one file but it still wants to create two data files. I considered creating a new DB with one file and copying the data to this new DB, but the size is currently 80GB and we only have 50GB available. Does anyone have any suggestions for another way to reduce the number of files to one Wonderful! If ...Show All

• Jonesie Custom Task: How to access/modify the Expression Collection of a package

  Hi, I created a Custom Task which it has a Property called ConfigFilePath. I'm overriding the Validate() method from Task. I want to throw an error if my property ConfigFilePath is empty and if the expression for this property is empty. So far, I can check if the property is empty but I don't see how I can access the Expressions Collection of my Custom Task. Any thoughts I'd appreciate your help. I realize you want design time validation. I'm not sure if you want to validate that user used an expression to set the property (and reject if he/she simply set the property directly), or just want to validate that the user configured the property somehow, either directly or via expression I don't think you can do #1. ...Show All

• Keith Chapman Qusetion about return values from EXEC('select count(*) from xTable')

  Hello everybody! As the topic: Can i get the value "count(*)" from EXEC('select count(*) from xTable') Any helps will be usefull! Thanks! How about this ; create table #results ( cnt int ) insert #results exec ('select count(*) from master..sysdatabases') select cnt from #results Thanks Shallu, Rod Colledge, and NB2006. I will try to test whether it works. Thanks !! Not good at english! Sorry!! Hi, Yes you can do that. it will return a table with one column and a row. Please make sure to specify column name for count(*) 'select count(*) as RowCount from xTable' Hi You can return a parameter from executing a string , but you need to use sp_executesql , like ...Show All

• Marco Shaw Configuring SQL Express During Installation and attaching smart client DB / silent install for one click?

  Hey all, Cool place! Has anyone deployed SQL Express silently using one click and an attached a smart client DB from within the app ... would love to see some of the best practices or horror stories! Just kidding... :) I'm about to deploy a smart client using SQL Express and could use some tips from someone who has been there. Thanks in advance, Bill Hi Bill, It wasn't clear to me why you were using SSEUtil since the command you're calling (-m -a) is simply doing an attach that it appears you've already done. The reason I wonder is that SSEUtil is an unsupported application and as such is not licensed for deployment. You should consider removing this step from your install script and also consider removing SSEUt ...Show All

• martinx1 Undocumented sp supported...

  Dear folks, I’m seeing that undocumented stored procedures such as sp_MSforeachdb or sp_Mshelpcolumns are available yet on Sql Management Studio whereas other such as sp_MSgettools_path not. I don't get the point so that l et me know your thoughts/ideas about this. Thanks in advance and best regards, hi Jens, That's fine by me. I meant, why ones are already up and otherwise others one are out Thanks again. The procedures are as you already told undocumented, means that they are not documented in the online help BOL. They are shwoing up in SSMS, but that does not mean that are supported (they also showed up in Enterprise Manager). HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• cggamer Change URL

  Can any body help me i need to chanage my URL when select my TPM and TPK i have two option in my Filter 1.TPM 2.TPK i writen some custome code here but its not working i know some thing wrong in that its my Code here:- Public Function access( ByVal parameter As Object ) As String IF parameter Is "TPM" Then Response.Write("<script language=""Javascript"">window.open (' //localhost/Reportserver/Pages/ReportViewer.aspx %2fTPM%2fAFM1&rs:Command=Render&rc:Toolbar=true&RUNDATE =" & Parameters!TPM.Value & ' ,'mywindow','location=1,status=1,resizable=yes,scrollbars=1,width=400,height=400');</script>") ...Show All

• gauls Problem with Publication Articles being deleted

  I wonder if anyone can advise, I currently have a replication set to 5 offices. Which has been working fine for some 18 months+, then the replication dropped out. When I looked in the publisher it had lost all its articles and would not allow me to add back in. I deleted the publication and recreated it and then after creating a new snapshot starting rolling back out to the various locations, and one of the locations failed and again all the articles where lost. I deleted and rebuilt the database at that office and went through the same routine again, only for it to happen again, the issue being that now errors where produced!!!. So at present I have the publication and all the subscriptions running apart from this one office. Has an ...Show All

• shakalama SQL 7.0 on Windows 2003 Server

  Hi, I have a client requiring SQL 7.0 installed on Windows 2003 Server Std. Just wondering if its supported and possible to install SQL 97 on Windows 2003 servers. Thanks SQL Server 7.0 has actually gone out of general support. Check out the following support policy. http://support.microsoft.com/kb/912251/en-us Michelle ...Show All

• bobnalong99 Obtaining Snapsot via FTP using SQL Express client

  Hi All, I really need some help here! I have spent the last few days upgrading a clients system to SQL 2005, part of which involved upgrading their sales people's laptops to Sql 2005 Express and setting up Merge Replication. I have configured the Server to use Web Synchronisation, and have tested that the replisapi.dll diag all works ok and it does. I am running into problems now with getting the laptops to synchronise. I have set up the Replication task, and am getting an error when I run the Wndows Synchroniser: ==================== The schema script '\\PTC42\ParklandsWebsiteV2\ftp\PTC42_PARKLANDS_PARKLANDS\20060812131209\' could not be propagated to the subscriber. The process could not connect to FTP site 'mail.parklands ...Show All

• Rajnesh How to open a RDL report in Report Builder ?

  I have 2 files for a report (rdl and data). If I am trying to open the report using the File->Open->File->*.RDL , the VS will open the XML report definition. How can I see the design of the report Thanks. WOW! First off VS and RB are two different report builders. If I hear you correctly, you are using Visual Studio and trying to open a RDL file by clicking on [file/open/file]. This is incorrect and will only load the xml code. If you do not have a solution file SLN to open up the RDL file then you need to create one. [new/project/business intelligence projects]. Make sure you see where the project is being created. C:\Documents and Settings\yourusername\My Documents\Visual Studio 2005\Proj ...Show All

• Scythen Help on dynamic sql results on temp table

  The dynamic sql is used for link server. What I need is that the result of the dynamic sql put on a temp table. Can someone help. Im getting an error CREATE PROCEDURE GSCLink ( @LinkCompany nvarchar ( 50 ), @Page int , @RecsPerPage int ) AS SET NOCOUNT ON --Create temp table CREATE TABLE #TempTable (  ID int IDENTITY , Name nvarchar ( 50 ), AccountID int , Active bit ) INSERT INTO #TempTable ( Name , AccountID , Active ) --dynamic sql DECLARE @sql nvarchar ( 4000 ) SET @sql = 'SELECT a.Name, a.AccountID, a.Active                    FROM CRMSBAL ...Show All

• Ljhopkins Report Layout after deploy

  Hi everybody, I have problem to creating the report using report server. After report degining as report project, the report appeared proper in the layout . But it doesn't show with proper alignment, After deploy this report in the reporting server . How to rectify this. Please anybody is in, share with your idea. Good day Yes, You are right. The controls are overlapped in my report degin . After rectify this, the report display properly. After that, i m facing another problem for using the subreport. it hasn't display properly. If you have any solution, please provide to me Thanks It sounds like you have overlapping report items (r ...Show All

• amit kuzi Processadd Dimension

  Because I have a very large subscriber dimension and the oracle temp space of the underlying Oracle db is limited, I want to do a processadd on a dimension. The dimension is defined in a named query. In the original Datasource view, the where clause limits the result set to 'NL'. I created a new DS view with only the subscriber named query in it. I copied this code in the xmla script and I changed the DS name to the original one. In this script, I also specified the where clause to take the 'UK' records. Allthough the xmla script is being executed without error messages, it seems to ignore the ds view part and always queries on 'NL' instead of 'UK'. Below, you can find the xmla source. I cannot figure out what is wrong here! ...Show All

• Alex.NP Problem createing Assembly System.Web from Framwork

  I have problem installing System.Web into SQL server to use in my own Assembly. When trying to create it say that i need to install system.enterpriseservices, system.runtime.remoting. So when a try install them they say they need system.web. They seem to be cross refernce eache other. Who can i solve this /Martin See sample CREATE ASSEMBLY [system.web] AUTHORIZATION [dbo] FROM 'C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\System.Web.dll' WITH PERMISSION_SET = UNSAFE CREATE ASSEMBLY [system.enterpriseservices] AUTHORIZATION [dbo] FROM 'C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\System.Enterpriseservices.dll' WITH PERMISSION_SET = UNSAFE CREATE ASSEMBLY [system.runtime.remoting] A ...Show All