Answer Questions

• tomerlev Changing the sa password of publisher and subscriber

  Hi, I have publish the data which have two subscriber ,one is in local network and other one is through internet. Now As per compnay policy i am going to change tha sa password of Publisher and subscriber. So i want know that it will effect replication or not. if it will then what should i do to change the sa password. Regards Sanjay Tiwari Depending on how you setup your repl. I suggest you take a look at Vyas' article. http://vyaskn.tripod.com/repl_ans4.htm ...Show All

• msdate Slow backups and restores

  Hi all, A few weeks back I had a problem with setting up Maintenance Plans on my SQL Server, the only fix in the end was re-install the SQL along with SP1. Since then backing up or restoring our developers database takes around 15-20 minutes whereas before it would take 1-2 minutes. The server doesn't seem to be the problem as I have restored it to a 2nd server and get exactly the same problem there. Other databases on the same server of around the same size backup as expected. The database is approximately 150MB's with the log file being 800MB's. The server in question is a Dual Core Opteron 2.2Ghz with 4GB's of RAM, running Windows 2003 x64, fully patched and up to date. The SQL version is 2005 Standard Edition x64 also incl ...Show All

• Sergio Ortiz Visual Studio crash at Analysis Services Project

  I have implemented SQL Server 2005 Developer Version at Windows XP Home. I'm working on localhost. I want to do an assoziation analysis and creating data source and data source view is successful. But when the data mining wizard comes to the point where to choose the data mining algorithm, the visual studio crashes- the application is not responding. No error code is given, so I don't know where to start. Analysis Server is running and the connection to the data source is made. Hope someone can give me a hint. Are you able to connect to your Analysis Services instance and browse cubes from other clients Try SQL Server Mgmt Studio and Excel. I'm not aware of any issues with XP Home - however, ...Show All

• SQLChamp Select vs Stored Procedure

  I have code simililar to the following in a stored procedure: CREATE PROCEDURE GetGroupMembers ( @GroupID INT ) AS SELECT TMembers.MemberID, VCurrentMemberGroups.GroupID, THonorsMembers.HonorID FROM THonorsMembers LEFT OUTER JOIN TMembers ON THonorsMembers.MemberID= TMembers.MemberID LEFT OUTER JOIN VCurrentMemberGroups ON TMembers.MemberID= VCurrentMemberGroups.MemberID WHERE (VCurrentMemberGroups.GroupID = @intGroupID) AND TMembers.DeleteDate IS NULL ORDER BY TMembers.MemberID RETURN GO When I call this stored procedure in Query Analyzer, it takes two minutes to execute. The web pages that rely on it time out before that. If I copy just the select statement and substitute the group I'm working wi ...Show All

• Queenw Trigger on Select

  We have an access front-end and sqlserver back-end. We need to log all selects to a key table (i.e. patient data). Since there is no trigger on Select, does anyone have any suggestions or has implemented something to work around this (not on the front-end). With another front-end, we can put this in the stored proc and log, but this is Access front-end and I would like something done in the back-end. Thanks. Leanne. Ouch. My only suggestion would be to create a SQL Trace Job that would log to a table. This is a stinky idea, though due to the performance hit. Does access have to access the table directly Could it go throught a Stored Procedure to retrieve it's data. If so that would be a better option. ...Show All

• Stampede2 Unable delete remote files using FTP Task

  I can create remote folder and delete it I also can create remote files but i can not delete remote files error warning is like subject any ides thanks Yes. By default, the normal FTP commands cannot handle multiple files. MGET, MPUT, MDELETE are used for that purpose. (Speaking in terms of non-SSIS FTP Tasks) I don't know about a windows FTP server, but in Unix, just because you can upload files doesn't mean you get to delete them. In fact the owner of the files you just uploaded may not be you. If on a unix FTP server, have you verified that your FTP login ID is the owner of the files (ls -l) I don't know how the SSIS FTP Task's delete files command works though. It does accept wildcards. ...Show All

• Blackchina79 Passing a variable to the from statement

  Hi, I have the following sql that I execute against a flat file. The flat file has a fixed length header and trailer but variable length data section. I execute this sql to get the header and trailer details the data section is put through a process in integration services: SELECT substring ( bulkcolumn , 1 , 5 ) --<HeaderIdentifier, char(5),> , substring ( bulkcolumn , 6 , 10 ) --<SenderIdentifier, char(10),> , substring ( bulkcolumn , 16 , 10 ) --<RecipientIdentifier, char(10),> , substring ( bulkcolumn , 26 , 30 ) --<FileType, char(30),> , substring ( bulkcolumn , 56 , 8 ) --<CreationDate, char(8),> , substring ( bulkcolumn , 64 , 6 ) --<CreationTime, char(6),> , substring ...Show All

• Lawrence Parker Printing differences between RTM and SP2

  Using SQL Server 2000 SP4 and SQL Server 2000 Reporting Services I'm using the code from http://blogs.msdn.com/bryanke/articles/71491.aspx and have discovered a problem with the printed report between the RTM version of Reporting Services and SP2. Our development server had not been upgraded to SP2 and using Bryan's code the reports were printing without any issues at all. Now the server has had SP2 applied the report footer is missing and data on the right-hand margin is truncated. Anyone got any ideas why this would be the case What can I check to see why this would be happening Thanks Well that sort of solved my problem. I had to convert measurements to metric. Then I plugged some code ...Show All

• LouisVanAlphen Why CodeBase property of CurrentAssembly in CLR SP is empty string?

  Where is SQL storing and caching the assemblies used by CLR SP I want to read a mapped configuration file for that assembly but it seems that assemblies are not read form their initial location. Is there a way to use configuration files for the assemblies used by CLR SPs (I don't want to use a static string to point to a file on the disk) In the SQLCLR, assemblies are either loaded from inside the database - if they are user assemblies - or from the GAC if they are System assemblies on the "blessed" list. To see where the user assemblies are loaded from look in the content column in the sys.assembly_files view. Niels ...Show All

• phoenix11 Managing transactional replication

  Hi everybody, I wish to manage the process of transactional replication between two SQL databases using a c# (or any other possible language, does not differ) written tool. More accurately, I have a database in my server, and I want to have the program to be run from any other computer and does the replication between the local pc(where the program is run) and my server. More to say is that the connection between the server and pc(s) is over the internet. I would be so thankful if anyone would help me to solve the issue, with regards farshad Thanks Mahesh, I think I didn't say what I meant, of course this was a good help, but not exactly the solution to my problem. Thanks a lot again, cheers farshad Hi ...Show All

• Jkumar SA account (DBA System account) Granting Priveleges but SQL Server 2000 not applying them

  I have been running a script in SQL Server 2000 as sa also as a Active Directory user who has administrator rights (I tested both approaches SQL Server then Windows Authentication) in Query Analyser which grants execute rights to the stored procedures within the database instance and Query Analyser does not give any errors when I run the script. I have made sure that each transaction has a go after it. I then return to Enterprise Manager, check the rights (I apply them to roles so that when we create another SQL Server user we just grant him/her rights to the role) and discover that the role has not been granted the rights. I seems to be occurring only with 2 of the procedures. Is there a known bug that might be causing this yours since ...Show All

• Sacristy Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

  God morning! I 've just installed SQL Server 2005 on Windows 2003 Server 64 bit. One of my databases need to connect to seveal Oracle databases. - I tried installing 64 bit Orcale 9 on this server. Got a strange message that the application (Oracle 64 bit) could not be installed on a 32 bit server! Strange! - I installed Oracle 9 32 bit on the server, but I could not find ODBC driver in the Data sources! Neither the oledb under providers in MSS Manager Studio! - Same result efter several desintall and installation. A college copied the .dll files och run a script to register the dll files. We could then se the Oracle driver in the Database sources, but we could not create any connection. - We have even tried an 10G version of Oracle with t ...Show All

• Juice Johnson Problem connecting to remote datasource

  I'm having trouble connecting to my datasource while processing (but no trouble connecting to it when developing). My datasource is using a database on a different server to the AS server. I'm getting an error along the lines of The remote datasource '' cannot be found in the metadata I've tried all the different impersonation options with no joy. I've got the SSAS service running under a user thats set up as an administrator on both the AS server and the database server. Can anyone shed any light on what I might have done wrong. Thanks in advance, Jon If it helps the exact error message is: Errors in the high-level relational engine. The '' remote datasource cannot be fo ...Show All

• joeycalisay Open Navigation Link in a new window

  I have a report with a hyperlink. When I go to the navigation tab, it does not give me any options to open the link in a new window. I have a link to show help and I do not want the user to actually move away from the reports Any ideas This is such a simple thing..I wonder how MS misses this I have seen this answer "rc:LinkTarget" from multiple sources, but I cannot get it to work. I cannot get the Target attribute to change from _top to _blank or any frame names. here is my code sample: =" http://myServersName/ReportServer /Finance/quickTest&rc:LinkTarget=_blank " Because or report server runs in a framed wrapper the window.open method cannot work either. any suggestions would be helpful. ...Show All

• BernyBern Basic security questions

  Hi, I am new to SQL 2005, can someone give me some details instructions about how to do below two tasks: All my developers are in a window domain user group, I need to grant dbo privileges to that domain group so then can do the their development work. The rule is all objects they create need to be owned by dbo not by there ID. ( I can’t do it because I got “ The “Deafult_Schema clause cannot be used with a windows group”) Same as above but this time they only need select permission on tables nothing else. Many thanks. PC See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=678115&SiteID=1 and the thread referenced there. Thanks Laurentiu ...Show All