Answer Questions

• AJ Software Error when trying to start Management Studio

  Hello Guys, I am getting the following error when I try to start SQL 2005 Management Studio to manage my SQL Server : Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). Any ideas Thanks, Hello I have managed to sort it by reinstalling SQL over the current installation. Thanks Did you ever get this error fix. I did a search for that dll and i found it, the only weird things is its not located in the same directory as my database. Hello, Do you have a good idea instead of reinstall MS-SQL I've a lot of data in DB and always serve to customer. Can't reinstall as your suggess. Regards, XNOIE. ...Show All

• bminard Backup Software

  Hi We are getting ready to rollout a new system in the next few months and I have started to look at backup and recovery strategies for SQL Server 2005 on which this new system will be housed. The proposal is to by Veritas Backup Exec with the server this system will be housed on however my knowledge is "limited" to the backup and restore options available directly from SQL. I have been unable to find any opinion on using third party software to backup and restore SQL Server 2005 databases. Can anyone help to give me an objective opinion on this subject. Should I simply use SQL Server and the tools it ships with or do these third-party applications make it easier Many thanks in advance of your help Cheers Danny ...Show All

• CRasmussen parameter masking

  hi is there any option by which i can mask my parameter for password. Looking for the same option. Bummer there hasn't been a response. ...Show All

• DanMeyers Inner workings of RDA

  Hi all readers, we are currently investigating the inner workings of RDA. What we have found out so far is that after completing a pull the pulled table on the client has 7 more columns than the table on the server. The columns are: _sysIG, _sysCG, _sysCD, _sysP1, _sysMC, _sysMCS, _sysSR. Does anyone have a clear description what is saved in _sysP1, _sysMC, _sysMCS, _sysSR We found a patent description describing the columns on this site: http://freshpatents.com/Protocol-agnostic-database-change-tracking-dt20060420ptan20060085485.php type=description Yet, the above mentioned columns still remain a mystery for us. My second question regarding RDA is How does the server save the information which row has been deleted between two pushes. When ...Show All

• Samoyed Copy database with encrypted column to new server and decrypt column there

  To do this successfully do I need to backup the Service master, Database master, and database itself from the the Source server, then restore all three of them on the destination server (I'm concerned that restoring the source Service Master key to a new target server with an existing sql 2005 install will screw things up big time.) TIA, Barkingdog It's actually a little easier than that. All you have to do is restore the database and then restore the encryption between the SMK and the DBMK. The database master key should already be in the database so after that you just need to associate the DBMK with the new server's service master key. After restore, you will need to: 1) use <dat ...Show All

• Alex2200 SQL 2005 Standard won't accept remote connections - followed all FAQs but options aren't available

  Hi, SQL Server 2005 isn't accepting any connection other than SQL Management Studio from the local machine. However, even that's exhibiting strange behavior (please see below for more details). I've read through all the common errors regarding enabling remote connections via the SAC tool, making sure protocols are enabled, etc. This case seems to be completely outside. Any advice appreciated. Thanks, Elias [1] Client side: What is the connection string in you app or DSN N/A. Can't connect via any remote method, including client Control Panel > ODBC > create DSN, SQL Server Enterprise Manager, third party application. If client fails to connect, what is the client error messages Several, depending on method: "server d ...Show All

• Idanle recursive query

  Hi guys, this is a weird query i need to build, or it can be an stored.proc, whatever's easier I have a table Item_ID Item_PARENT_ID --> references "Item_ID" Item_LEVEL --> 0 = top, else 1, 2, 3, 4 Item_NAME Item_START_DATE Item_END_DATE I would like to populate a gantt like chart, I have this table and need to generate an output ORDERED BY DATE BUT "PER LEVEL" how should it look like ID | NAME | PARENT ID |LEVEL|START DATE 1 topitem 1 - 0 01/01/01 9 subitem 1-1 1 1 09/01/01 3 subitem 1-2 1 1 15/01/01 2 subsubitem 1-2-1 3 2 01/01/00 7 topitem 2 -- 0 02/01/01 and so on. So this is a tree structure, ordered a. By top's date b. by sub date c. by sub ...Show All

• AndyB_UK_2006 Replication of check constraints

  I have tables that are replicated using transactional and merge replication. As a result I am unable to use automatic identity management as transactional replication doesn’t seem to understand it. Therefore I have implemented a version of the automatic mechanisms that seems to work in a hybrid environment. It is based on a central table that holds the maximum identity for each table that has been issued to date. Valid identity ranges are issued to each publisher and subscriber as needed in a similar way to the automatic mechanisms and tables are reseeded as needed. I want to enforce the ranges in a similar way to the automatic mechanism using a check constraint similar to this: alter table [dbo].[test1 ...Show All

• dlgrasse Attaching a SQL Express database to SQL Server Standard instance...

  If I create a database in SQL Express and then copy the MDF/LDF files and attach them to a machine running SQL Server 2005 Standard - will this new database have SQL Express limitations Are there good reasons not to do this and create the database in SQL Server Standard using scripts generated from the SQL Express instance instead Basically, I'm setting up a merge replication between Standard and SQL Express for a common database and I figure attaching a copy of the database created in SQL Express is the fastest way to get this started. You can attach the file created on SQL Express to SQL Standard Edition, they are the same product and use the same file format. The limitation are specific to ...Show All

• Pisces Database files free space (SQL Server 2005)

  Dear friends I need to report the amount of free space in each datafile of a database. I have tried sys.dm_db_file_space_usage , but the documentation says that it only works for the TempDB. Please help. Regards Parviz Take a look at the sp_spaceused text. You should be able to derive from there. exec sp_helptext 'sp_spaceused' Here's some code, cribbed from a sqldbatips report designed to mimic the taskpad in SSMS. ( http://sqlblogcasts.com/blogs/sqldbatips/archive/2006/11/21/custom-ssms-reports-in-sp2-enterprise-manager-taskpad-view.aspx ). All I did was add some code to show the amount free. Seems to work well. Posting here because this was one of the top results in Google when ...Show All

• pmanisekaran Correct approach to catching execution time errors in a custom task

  Hi, I'm building a custom task and just wondering what is the correct way of passing errors back to SSIS. Is there a rcommended approach to doing this. Currently I just wrap everything in a TRY...CATCH and use componentEvents to fire it back! Here's my code: public override DTSExecResult Execute( Connections connections, VariableDispenser variableDispenser, IDTSComponentEvents componentEvents, IDTSLogging log, object transaction) {   bool failed = false ;   try  {   /*   * do stuff in here   */  }   catch ( Exception e)  {   componentEvents.FireError(-1, "" , e.Message, "" , 0);   failed = true ;  }   if (failed)  {   return DTSExecResult .Failure;  } ...Show All

• Brent C iif statement problem

  hi all, i've browsed some of the smilar iif expression problems but no idea how to solve mine. i get an #Error when i wrote the following expr : =sum(iif(Fields!revenue_type.Value= "R" , Fields!amount.Value,0)) but no error when it's =sum(iif(Fields!revenue_type.Value= "R" , Fields!amount.Value,0) - iif(Fields!revenue_type.Value= "T" , Fields!amount.Value,0)) If i filter the dataset and just take in data where revenue_type = "R" then there won't be error... how come did i do something wrong please help... this seems so simple yet i couldn't get it.. Ok, after your post I've tried the same thing in one of my report ...Show All

• kirank_gh transactional replication newbie, badly need help!

  hi there! i am a newbie with replication. i am trying to implement one, however due to lack of references, there are some difficulties. here are some of my questions, i am hoping anybody could take their time to help me out in details. Thanks and appreciate it! (1) i could not publish all tables. tables that do not have primary keys are not included, and i need to publish all tables. (2) tables that i sucessfully published does not replicate the table's primary keys, relationships and triggers, how do i update the subsciber (3) for some reason, i could not replicate schema objects - views, UDFs, stored procedures. its giving me an error. Please advise. Again, thank you so much! 1. Transa ...Show All

• ClydeCoulter Attach database

  I have a database on a server and want to put it my local laptop that also has sql express. I attached the db, I see it in Management Studio but it does not show up in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data so my app is not working correctely. How do I get the db to show up in the MSSWL\Data folder. I'm a bit confused. Then it has nothing to do with the directory of the file. That means that what "MSSWL\Data" is the name of a "named" instance of Sql Server. In that case you will need to configure\modify the application so it can connect to the Sql Server installed on your machine. As it looks now the application is trying to connect to the server from where yo ...Show All

• Benjj Subscriptions

  We are running Reporting Services on an Application server, side by side with a web application. The server exists outside our corporate domain due to the fact that our external vendors need access to the application (not the reports). Our web app uses a third party mail system to funnel the application email thru our corporate exchange server. Since Reporting Services is not connected to our domain, it can not authenticate to send reports via e-mail subscriptions. I am looking for alternatives to make this work from outside the domain. This should work: IIS(with reporting) ---- SMTP Server (IIS Virtual one) | | | v (Auth ...Show All