Answer Questions

• Srinivasa Rao Logon Failu unknown user name or bad password - using xp_cmdshell or bulk insert

  We had some SQL Server automated web routines that stopped working when some security patches were applied either to SQL Server 2000 or Windows Server 2000. The Web users would upload a file to a directory on the web server. Then a Stored Procedure would be executed that would do a bulk insert into our SQL Server table. The bulk insert now fails giving this error #1326: Logon Failure: unknown user name or bad password. It used to work flawlessl ...Show All

• Avia Graetz UK Datetime parameter problem SQL 2005 RS

  Hi, I am having a problem with the DateTime parameter option in SQL 2005 reporting services. Note that Server, workstation and database are set to British/English (UK) date/time localisation (dd/MM/yyyy) for example 25 th December 2005=25/12/2005. I create a simple query with a parameter on a datetime column and set the report parameter to Data type: DateTime in the report parameters dialog. On preview or after deploy ...Show All

• ching username password

  hi, it s just a stupid question but i installed MS SQL Server without enteing username and password and now it s asking for them. what username and password could it be thank u Try to use Windows Authentication mode: BUILTIN\Administrators can logon to MSSQL by default. Did you ever find a solution to this problem I am going through the same problem right now. ...Show All

• Jorg Plumacher Question about the way that some element are displayed in the viewer

  Hi! I've notice in some reports that some lines doesn't appear in the viewer but if i print the report or if i export it to PDF i can see the line. I can't figure out what is the cause of this. Anyone know what is the cause of this Thanks ! Would you mind opening an issue via the below url and attaching your report so we can take a look http://lab.msdn.microsoft.com/ProductFeedback/Default.aspx Than ...Show All

• Jubin SP1 Install Caused Problems

  Had a couple questions about some Event ID 6702 errors on the server I’ve been getting recently. I can’t seem to find any intelligible information on Microsoft’s site about it; however, I did find this: http://support.microsoft.com/kb/842006/en-us#XSLTH5294121122120121120120 There are no replication partners for all I know on this server. As far as the A records that it wants me to check, when I take a look at dnsmgmt ...Show All

• jizhang sp_helprotect

  Does anyone know how can i use sp_helprotect just on the user tables and stored procedures.. thanks thanks for the reply, but i am really a beginner for the pseudo code.... Something like this will do it. declare @sSql varchar(300) DECLARE my_cursor cursor FOR SELECT sqlstm FROM #sql OPEN my_cursor FETCH NEXT FROM my_cursor INTO @sSql WHILE @@FETCH_STATUS = ...Show All

• _wim About SQL Mobile Server

  I need to export(import) data from Pocket PC(SQL Mobile Server) to SQl Server 2005(central data storage) in real time, if anyone knows how it would be better and faster to do...Maybe someone have done something like this... Sorry for my English, I use it at first for last 6 years...))) I think same... I install full SQL 2005 Server and Mobile Server with native Client..So also think that if i synchronize databaseses they will updat ...Show All

• DannyMc Trigger BEFORE ?

  I want to execute a procedure before a INSERT. I create a trigger assigned to the INSERT event of my table, but i just can choose INSTEAD OF or AFTER. in other database engine like PostgreSQL, i can use the keyword BEFORE for fire my procedure before the real event. How can i do this in SQL Server Hi JMattias,   This is not correct. In the CREATE TRIGGER syntax, FO ...Show All

• ly ReportingService.Render(CSV)

  I am calling a reporting service proxy's Render Method passing "CSV" as the  format . Dim result As Byte () = ReportingService . Render ( "/SomeRPT" , "CSV", ...) Return Text . Encoding .Unicode. GetString ( result ) This returns a unicode byte array. This array has four leading bytes (255,254,83,0) that do not belong in the output. If I use the GetString method all of the null chars are stripped out, but this leaves three leadi ...Show All

• Denver Griffith Unable to set Default Schema for a group

  We're using Windows Authentication with our SQL Server.  We've added a domain group to the SQL Server groups and would like to give it a default schema.  The properties window is the same for users and groups but the default schema field is enable only for user entities.  We cannot add a default schema to a group.   Is this by design,  a bug or a problem with our SQL Server installation Updated on ...Show All

• Jason Browne declare programaticly a X number of variables

  Hello everyone, I really need some help; I need to declare dinamicly an number of records to be pulled out of the table.. so I need to declare first DECLARE @NumberOfRecords int  then DECLARE @i int set @i=0 and WHILE @i<@NumberOfReocords     begin                declare                     & ...Show All

• andyhoff Grouping question

  I have a report that is actually going to be printed on NCR (carbon) paper to be written on. On this report I have a table that displays items from five different groups plus adds blanks for written entries. The data displays correctly under each group along with the extra spaces for written data, however what I need to know is how to "force" a group that does not have any items. Is there a way to do this Thanks for any informati ...Show All

• RonBonBon A Problems after the install of the Hotfix

  After installing SP1 and then the hotfix: http://support.microsoft.com/Default.aspx id=918222 We now get the following error when trying to work with date parameters in Report Builder: Query (6, 117) The '[VBA].[DateSerial]' function does not exist. ---------------------------- Semantic query execution failed. ---------------------------- Query execution failed for data set 'dataSet'. ---------------------------- An error has occurred duri ...Show All

• stakei Fix mistake in fact table

  Following is the business problem: - say there are invoices coming from customers - those invoices are assigned to accounts - invoices are assigned to wrong accounts and this is not discovered for months - users correct the mistakes and the way the source system is built - all invoices are reassigned to the NEW account - NO CHANGE DATE though So, say they found that the account is wrong and fix mistake that updates invoice records all ...Show All

• jpvalappil Programmatically loop over variables in the variable dispenser?

  In my custom task, I would like to loop over the variables in the variable dispenser, and only modify those that are of a certain type. Is this possible Thanks! Can I ask why you want to this How does the type identify the variables you want to modify I ask in case there is some better way which we could suggest to acheive your business case. Donald That would work, but I should clarify my que ...Show All