Answer Questions

• Jassim Rahma re-establishing mirror

  When witness and mirror were down, mirroring was removed at primary. Now when I try to re-establish mirroring I get the following error Msg 1456, Level 16, State 3, Line 1 The ALTER DATABASE command could not be sent to the remote server instance 'TCP://witness:5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again. On the witness server the following sql select * from sys.database_mirroring_witnesses returns 1 row with the previous mirroring information. How do I remove old information from witness server Thanks. I can't set up the original server. I don't have another computer to name as the original computer name and I ca ...Show All

• IceAngel89 Dynamic Cube partitioing in MSAS2000

  Hi, Pl give me a way, by which i can dynamically make the cube's partitions. Actully every month on start i have to create a partition for that month manully. Can it make it automatic by any way Pl help me for this regard i need it urgently. Thank and Regards Abhishek Hi Carroll, Thanks a lot to give me a way as DSO. It will be helpful for me if you send some demo code of "how to use it" and specially, how to use it using 'DTS'. Regards Abhishek Sorry, I missed that. Analysis Services 2000 can work with SQL Server Data Transformation Services in a similar fashion. You'll want to create a script task and use DSO to create the partitions and ...Show All

• schobmich Web application will not function after being published (database problem)

  Hello everybody, Here is the case: 1 – When I make a web application with VS 2005 (on a Windows XP Pro SP 2 machine) using a database (with the included SQL 2005 Express) all works fine on my dev computer 2 – After publishing that application on my Web server (an old but fresh reformatted machine with Windows 2000 Server SP 4 - but without any special feature of server version such as active directory configured -, IIS 5, SQL 2005 Express SP 1 with Advance Services, both 1.1 and 2.0 frameworks installed on it). I have this error when I call the application from IE: (Be kind as all my configuration and error messages are in French so I try to translate them the best I can but if translation is not clear tell me – and if someone ...Show All

• Sats_b1 install SP1 immediately after RTM might fail ... ?

  Hi all, maybe this is not a new issue anyway: Installing SP1 straight after the RTM (no delay between the finish of RTM install and start of SP1 install) might fail. This happened to me on an install of Analysis services install, but I guess it could happen on any install. I think in this case the reason is that the .NET Optimizer service is still busy generiting the native images of the assemblies and the SP1 install finds them locked.After a while, if you don't keep pushing the "Try Again" button you get an error message prompting to send the error report to MS (I got that twice), however in the background the installer continues. At the end the hotfix installation complete window states "Failure" for some compo ...Show All

• Dietz Restoring database problem

  i have developed an application where in one form i placed two buttons, backup and restore. when i want to take backup from database to which i currenly login, i can . But when i want to restore database that bakup to database to which i currently login, i get an exception. So then add following method myConnection.Close() RestoreBackup(); even though it is not restoring. the resore backup method is following public void RestoreBackup() { // If there was a SQL connection created if (srvSql == null ) { Connect(); } if (srvSql != null ) { openBackupDialog.InitialDirectory = "./Backup" ; openBackupDialog.DefaultExt = "bak" ; // If t ...Show All

• Tobias Zimmergren Allowing users to schedule jobs in Management Studio

  How do I grant a non sysdba user who has bulkadmin and dbcreator rights to schedule jobs on databases they've created The user is a developer and we dont want to give him sysdba rights. try if this works use the Execute AS command which is used to impersonate any user havent done much of a research on that one but u can easily get stuff on BOL http://www.sql-server-performance.com/faq/sqlviewfaq.aspx topicid=12&faqid=137 for your information to accomplish the task. ...Show All

• Greg Beech Use of transaction log

  Hi all, As I know that transaction log will record all transactions and database modifications made by each transaction, I want to know that what is actual use of transaction log Thankfully, Cbe. To expand on Jens' comment, it also helps in cases of rollback, database failure, backups, and log shipping. You already said that, every modification (depending on the logging level) is recorder in the transaction log top provide data concistency across the database. HTH, jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• vbjunkie Where to put DISTINCT in a CTE?

  CTE's are surprisingly useful for paging data, but I'm running into a problem where I have to add a distinct clause. The idea is to pull topic records for a user's forum posts, but only one topic record even if there are multiple posts in the topic. Here's what I have so far: CREATE PROCEDURE pf_PagedTopicsByUser( @StartRow int, @PageSize int, @UserID int ) AS DECLARE @Counter int SET @Counter = (@StartRow + @PageSize - 1) SET ROWCOUNT @Counter; WITH Entries AS ( SELECT ROW_NUMBER() OVER (ORDER BY IsPinned DESC, LastPostTime DESC) AS Row, pf_Topic.TopicID, pf_Topic.ForumID, pf_Topic.Title, pf_Topic.ReplyCount, pf_Topic.ViewCount, pf_Topic.StartedByUserID, pf_Topic.StartedByName, pf_Topic.LastPostUserID, pf_Topic.LastPostName, ...Show All

• moorpipe why job can't start automatically

  hello,everyone,i meet a problem that the job can't start automatically while i set the schedule,the job can start manual,so i don't know why somebody can help me,thank you Go to jobs right click on your job Properties then schedules , edit ,check enable box Hello, A few questions: 1. What version of MSSQL are you running 2. What is the error you receive in the job run history 3. If you receive no errors in task history, are you sure you've created and enabled a valid job schedule Cheers, Rob Please don't forget to close the thread if u have got the solution. Thanks thank you very much,i forget that i change the system time,when i correction the time,th ...Show All

• renyx Move database file

  I want to move my database file to a new directory, I search in MS and I use the following steps: USE master ; SELECT name , physical_name AS CurrentLocation , state_desc FROM sys.master_files WHERE database_id = DB_ID ( N 'test' ); ALTER DATABASE test SET OFFLINE ; ALTER DATABASE test MODIFY FILE ( NAME = test_Log , FILENAME = 'D:\Databases\test_log.ldf' ); ALTER DATABASE test MODIFY FILE ( NAME = test , FILENAME = 'D:\Databases\test.mdf' ); ALTER DATABASE test MODIFY FILE ( NAME = test_Log , FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test_log.ldf' ); ALTER DATABASE test SET ONLI ...Show All

• Xadja Can't load Report Builder

  I am having a problem where a standard user cannot load Report Builder. It works as an Administrator but not as a standard user. When the user clicks on the Report builder button the message "Application download did not succeed, please contact your system administrator" How do I provide the ability for a standard user to run this tool Anyone's help would be greatly appreciated.!! Thanks Hi Have a look at the following link. http://msdn2.microsoft.com/en-us/library/ms159667.aspx It talks about role assignments for report builder access Hope this helps. I have given the user system adminstrator rights to report builder but it still won't load. I have found that it ...Show All

• -Cyclone- Sorting SSIS packages in SQL Management Studio

  Hi, Is there a way to sort the SSIS packages in the SQL management Studio It seems like the list under MSDB is sorted by the date which the package was originally imported. Look for Darrens response in below link http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=748034&SiteID=1 ...Show All

• OhioDale Login failed for user ''. Reason: Not associated with a trusted SQL Server connection.

  Hello, I have some problem here. I have a sql server installed on one machine and I have another development machine for my asp application. How could I actually access the asp application and sql server at the same time from another machine within the network. I kept on getting the error message above. Thank you for your help :) Hi, I am using both sqlserver authentication and windows authentication to connect to sql server in mixed mode. Yes I am using IIS account from my development machine to connect to sql server. It works successfully. While the other machine without any IIS, access the development machine application and tried to connect to sql server but it fails. Thank you. Hi Oj, I still have some doubt over here. M ...Show All

• Zvona Feedback on Microsoft Connect Site

  I don't know how many folks here log into the Microsoft Connect site occasionally to check suggestions and bugs submitted to Microsoft for SQL Server and SSIS (still called DTS on their list). A small pecentage Almost everyone  (Possibly in this group.) Anyone can vote for feedback they think is important. Theoretically issues with the most votes will get Microsoft's attention first.   Links to a couple new submissions that look interesting:   1. SSMS/QA Style Message Logging for SSIS Execute SQL Tasks 2. ForEach SMO Enumerator Filtering   I vetted these issues in the forum first, so hopefully they're legitimate enough to warrant some useful feedback or even a few high ...Show All

• Sergey Bereznikov Mining XML from file

  Right now, when i want to load contents of XLM file, i have to use openXML which looks this way: declare @idoc int declare @doc varchar(max) set @doc='< xml version="1.0" encoding="windows-1250" > <root> <tag> <content1>xxccxcx</content1> . . . <contentXY>sf</contentXY> </tag> </root> exec sp_xml_preparedocument @idoc output, @doc select * from openxml (@idoc, '/root/tag',3 ) ( and here is whole select procedure) insert into ( table name) from openxml (@idoc, '/root/tag,3 ) (and here it is again) This is quite "useless" for daily using, unless someone fills the text field with new data. Is it possible to load cont ...Show All