Answer Questions

• AbdelMoniem Sudden expiration of evaluation version

  I have had SQL2005 on a server for a very short period of time. Today I found that I am not able to execute an SSIS package in debug. It give me an error stating that the evaluation period has expired for data transformation services. I went to check the version by querying, but nothing happens when I click on the Server Management Studio link. Has anyone seen this before or how long the trial version should last Does anyone know what vers ...Show All

• BigCountry How to encrypt database in SQLServer2000, please help me, thanks

  I have 2 questions: 1. How to encrypt data of database in SQL Server 2000 Someone can't see true data if without password or something else. 2. If i have 2 database . All of them have same table, structure, ....How to update or insert or change in the second database when i update or insert or change in the first database automatically Thank you very much. I completely agree with Jens, you don't want to use th ...Show All

• Harlan Witherspoon Performance considerations in storing a measure (such as ext sales amt from qty * sales price) vs calculated member?

  What are the performance considerations in storing a measure in a fact table (such as extended sales amount from quantity * sales price) as opposed to using calculated members to return this value   Is using calculated members a better practice from a design standpoint Thanks, Dave.  Very helpful indeed! Strickly from a performance perspective, the difference is negligable. However, as usual, design questions get multi par ...Show All

• runcy How to get a handle of my queries

  Does anyone knows of a tool that will help me manage my queries I have 100's of them and all scattered. On my PC at home, some in my laptop, some of them at work, some in memory sticks. Then, when I need them I can't find the one I'm looking for so I end up writing the query again. Any ideas I kind of know how you feel. I would check out MSN Desktop Search ( http://toolbar.msn.com/ ) for stuff on a single ...Show All

• CrioGreen Splitting a field

  hi all i have a field which displays the full name of our customers i.e. John Smith Is there a way of creating an additional fields first name , last name and automatical splitting the field display name first name last name john smith john smith Thanks rich Once you create the two new columns for first and last names you are going to get rid of the full name column, rig ...Show All

• psymen DB Maint Plan - Cleanup old DB Backup files not working

  I created a DB Maint plan with just a 'Maintenance Cleanup Task'; the job executes fine, but does not remove files.  The sql it says it's running is: EXECUTE master.dbo.xp_delete_file 0,N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup',N'.bak',N'9/11/2005 11:12:31 AM', any ideas   The logfile says it worked.  June CTP. Found the problem, shouldn't have had the '.' in the extension. ...Show All

• sylvarion Sql Server Express Database login problem

  Hi! I'm using Sql server 2005 Express, and now i have a login problem. I want to create a user for my database in Sql Server Authentication mode, that when others that they don't know sa password and login in windows authentication mode can't see or can't access my database. I did these steps : 1. I loged in to sql server in 'sql server authentication' mode and with strong sa password 2. I went Security \ Logins and created new login w ...Show All

• HelloHello How to Store System Variables in DB?

  Hi, I want to store the System::StartTime in my Integration Table Log. Please guide how can I use this in my Execute SQL Task Block. I write this SQL Statement: INSERT INTO CMN_tblIntegration VALUES ('HRM_tblParty', ) Which the is for the parameter. I go to parameter mapping tab and map the System::SatrTime to parameter0, but the package fails to run. I also changed the to @IntDate and also changed the parameter name but the error was the ...Show All

• Kharkov Alexander Report Manager name?

  Hi all, I am not sure is this the correct forum to post this question, but here is the question. Is it possible to have the Report Manager name changed according to different user entry What I meant in Report Manager name is the Name which by default is "SQL Server Reporting Services". I know I can change the name to something else from Microsoft SQL Server Management Studio, but I want it to show for example "XXX's Repo ...Show All

• jspliff MSmerge_genhistory error-515

  Can't insert value NULL into column nicknames. This error generated when I try start sync. SQL Profiler is not helping w/ locating specific error. I tried to allow NULLS in nickname column, for this table, but this table gets dropped and recreated each time. Pls. advise on where to make correction. thx..bt Are there any other errors that you can see in the Merge history table Can you do &qu ...Show All

• CaptnJamesKirk Why use anything other than varchar(max)

  What is the benefit of using anything but varcha(max). See my post for my comments. Comments very welcome Hi Simon, as varchar(max) is a great "invention" for SQL Server it should be used wisely. There was a good webcast about this from Kimberly L.Tripp from SQLSkills which pointed out why and when you should consider using this new type. (Some of that which already took place at: http://www.microsoft.com/events/series/msdnsqls ...Show All

• Hafiz78664 Can't shrink system tempdb

  The shrink file dialogue box indicates the system tempdb has a current size of   1091MB, and a space used of 19MB. I’m assuming I should be able to reduce the   size to 19MB   Regardless of what shrink action I invoke it still maintains a size   of   1091MB. Is it possible to reduce the size of this system DB Thanks to everyone   for being there to help.     SQL 2000 SP4 ...Show All

• pdhot How to view status of disabled indexes

  I will be programmatically disabling and rebuilding indexes during my load process. Is there a way, visually or otherwise to check the status of an index The 'is_disabled' column in the sys.indexes catalog view will show a 1 if disabled, a 0 otherwise...just query on the appropriate object name and index name combination, like this: select i.is_disabled from sys.indexes i where object_name(i.objec ...Show All

• Saskia1 Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

  This was originally posted in the SSIS Forum , but a member of the IS team suggested it be moved here.  " Most recently I got this error (Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) so does this mean that SQL Server is still trying to use named pipes even if I only have TCP/IP enabled in SQL Server Configuration Manager " I'm having the same issue, and here's our scenario: Installed SQL Server 2005 ...Show All

• RJHarris0 problem with DtsTransferProvider

  I am trying to transfer a database from one SQL Server 2005 server to another. TransferData method completes successfully (and all tables are available in the destination) if the source db contains only default database users (namely dbo, guest, sys). Then I repeated the same process after adding a database user (named 'testdbuser') to the source database, TransferData method threw the following exception, but the database was created in the des ...Show All