Answer Questions

• vr8ce Modify the expression to be valid

  I pass in a variable SourceServer to my package via the command line. In our production environment we are seeing: The expression "@[User::SourceServer]" on property "ServerName" cannot be evaluated. Modify the expression to be valid Is this just because the evaluation takes place prior to the command line parameters being set and I need to turn off validation Thanks, Chris Chris, Are you running RTM ...Show All

• CharlesBlair how can i sort my fieldnames alphabetically

  I want to use a "select into" command to sort the fields alphabetically into a new table. any help pls Why do you want to do this It doesn't matter in which order the columns are present in a table. You can always reorder and retrieve them if necessary for data export purposes. > The columns can be returned in *any* order Interesting.  Is the same true for TVF and VIEW 'select *' has limited usage for me, since  ...Show All

• lumakar_challa User-based security in Reports

  We understand that Report Server supports role-based security such that users in the different Windows user groups have certain rights with reports.  In addition to role-based security, we’re investigating Reporting Services 2005 to see if it suits our needs to providing user-based security in reports.  For example, user1 and user2 are both in the Windows Power Users group such that they can both browse a certain published report in r ...Show All

• nav13 Changing Database collation

  I am trying to use DTS to change the collation of a database.  I am using SQL 2000.  The default is Case Insensitive, and I am trying to change one of the databases from Case Sensitive to Case Insensitive.  I have created a new database with the proper collation, and I am trying to import all the database objects.  I want end up with the exact same database with the collation the only thing that is changed.  I have ...Show All

• lefty SSIS Access Denied Error

  I am getting an error when trying to access SSIS packages stored in the MSDB section. File access works, but I get an Access Denied error with the MSDB access. I've tried through the SQL Server Management Studio on the server and on a remote workstation. I've logged on with multiple users; to no avail. Has anyone encountered and solved this problem yet I've noticed several posts that appear to be similar, but there are no resolutions that work f ...Show All

• natashanatasha Can't connect to SSIS

  Hi,   I'm evaluating SQL server 2005 for planning a upgrade of our datawarehouse from SQL 2000 to 2005. We use a lot of DTS pacakages so that's my primary focus right now. I get this strange error when trying to connect to SSIS -> Stored Pacakges -> MSDB: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For hel ...Show All

• Sigurd DeMizar Drop login error

  Hi I am trying to drop a windows login via Management Studio (CTP June) but it comes up with ' Login domain\user' has granted one or more permissions. Revoke the permission before dropping the login (Microsoft SQL Server, Error: 15173) I cannot see of any permissions that this user has granted. Is there a system view in SQL 2005 which shows permissions this user has granted Thanks, Priyanga Thanks B ...Show All

• smar xp_cmdshell: a call to 'CreateProcess' failed with error code: '5' (under SQL2005 RTM)

  I get this error when trying to run xp_cmdshell. I have turned on xp_cmdshell via sp_configure and verified it is on (set to 1) by running sp_configure again. The login trying to run xp_cmdshell has sysadmin privileges. If anyone has a solution please let me know. Hello, I get the error 'System error 5 has occurred.' ,access is denied when I try to execute the command exec xp_cmdshell 'net localgroup grou ...Show All

• WN3335 SQL Server 2005

  Hi, Can I have an option where I choose “Start Recording my actions” and I would start clicking on the command buttons etc… and instead of the command buttons executing with the parameters I choose, all the actions and parameters would be saved to an XML file where using the same GUI I can open and execute them whenever I wish Can I output the execution status inside a big text box similar to how all Windows application now display the ins ...Show All

• TheFoZ Export Report

    Hi, How can i export a reporting services "report"  without using a report viewer From C# code  NB: i am using SQL server 2005 (RS 2005 too) Thanks Tarek Ghazali SQL Server MVP     not that I know of but if you do find a way could you post it here and let me know. Hi again. Do you have an example for using it What i ...Show All

• DanoruX Underlay possible?

  I'm converting Crystal reports to RS reports. One of the reports has a group header "underlaid" with the detail rows, with the effect that it appears to actually be on the detail row, like this : Column 1 Column 2 Column 3 -------- -------- -------- xxxxxxx  xxxxxxx  xxxxx xxxxxxx  xxxxxxx  xxxxxxx  xxxxxxx  xxxxxxx  xxxxxxx  xxxxxxx  xxxxxxx&n ...Show All

• rasmed Error creating ssis package job step

  ********************EDIT******************* * The issue resolved itself with a restart. * Sorry if I wasted anyone's time. ****************************************** Hi All, I wonder if anyone has seen this before. I'm on a fresh installation of Sql Server 2005 CTP (32 bit enterprise, running on win server 2003), attempting to set up a job to run an SSIS package. I create a new job, create a new step, select "SQL Server Integration Services Pack ...Show All

• Rogdie can anyone guide me

  i'm very new to SQl server, even i know nothing about it, all what i know about is Ms Access, i want to ask that :- 1) what is the differences between the queries and the stored procedures, i don't know till now i see both of them are the same thing. can anyone please till me what is the difference 2) i downloaded sql server express edition and it doesn't has interface , in the same time i can't install the managment studio , every time i ...Show All

• Ronald_D_Craig Howto do totaling in column wide in matrix table

  Hi Can some one help me please I am using matrix table and i need to do total column wide say example           priority 1      priority 2        P 3            $ 100           $ 500         $ 200&nb ...Show All

• I-D Attach Access Database to SQLServer

  Attach Access Database to SQLServer It seems it is necessary if I want to put it on the internet through IIS. I tried add data source through tools and tried most combinations, but nothing led in that direction. I also did a search. If not, the alternative is importing the data into sqlserver 2005.  What worries me about this is incrementally importing new tables, views, etc., and new rows.  Is this later possible dennist685 ...Show All