Answer Questions

• UriPar NEWSEQUENTIALID behavior changed from Apr CTP to June CTP

  There may be a bug in the June CTP version of NEWSEQUENTIALID. NEWSEQUENTIALID had very predictable behavior in the Apr CTP build. It incremented in obvious, clear, consistent amounts. Doing inserts right after another or having widely range time intervals between inserts made no difference. With the June CTP build, things are not as predictable and do not appear to be sequential. The following output shows the guids that were created. The tes ...Show All

• Anitha51560 cannot used reporting services in classic ASP

  Hi I found that after i run the reporting services in classic ASP, the report can disply but it will disable my form posting. All value cannot be posted through <input type="Submit" ...>. I just used "response.redirect "/ReportServer /MyFolder/MyReport" anyone can help Regards Siang ...Show All

• Beat SQL 2005 and Windows Vista

  I'm unable to install SQL Server 2005 b2 on Windows Vista b1 SQL Server-installation asks me to install .net 2.0, and .net 2.0-installation says that it's already there, part of the operating system. Is this by design, so I can just forget about testing it Hi, that is because in windows vista is another .net version included than your sql server was build with. Did you look for any oportunity to remove the e ...Show All

• Tore Birkeland Legacy dts style execution display.

  My manager wants me to produce a legacy dts-style display of an executing package in an asp.net grid view. It would be color-coded the same way: red, green, black showing the status of each step with start and finish time. Any ideas on how to do this One quick way would be to log to SQL table, or XML file, and refresh the ASP page regularly. Or you could look at our reporting pack for logging ( http://www.micr ...Show All

• RussellReed Can I set a default range for the identity values for merge replication?

  Hello, We have a couple of tables that can have quite a bit of data each day prior to replication. Can we increase the default values for a table for each subscription For example we have a table called table1 and on the sqlexpress client they could enter in 10000 rows a day, on table2 it's just 100 rows a day. How can we increase the values to where we do not get the error for table1 stating that the insert failed because it conflicted with ...Show All

• Charly M Transfer Logins: The source server can not be the same as the destination server

  I am replacing a server so I need to migrate everything. The old server is running SQL2000 and the new server is running SQL2005. I am trying to write an SSIS solution to migrate everything for me and I can't even get started because I get the error "The source server can not be the same as the destination server". At the same time I am changing the name of the Domain so the two machines arenot even members of the same Domain. I am doing this ov ...Show All

• kainaw Running a batch command using scheduler

  Hi, I have a batch file that runs an isql script. The sql accepts command line arguments as parameters. I want to invoke this batch file using windows scheduler. How do I pass parameters to my sql Somebody please help. Thanks. Thanks for the reply :) I am not sure about the batch file idea, but SQL server has a job scheduler built in called sql agent. You would be much ...Show All

• Divamatrix Pivot Error

  Hi : I am getting the following error message when I am trying to do the Pivot operation. Msg 265, Level 16, State 1, Line 1 The column name "FirstName" specified in the PIVOT operator conflicts with the existing column name in the PIVOT argument. Msg 265, Level 16, State 1, Line 1 The column name "LastName" specified in the PIVOT operator conflicts with the existing column name in the PIVOT argument. Msg 81 ...Show All

• JRMcFetridge about multiplication in sql

  what is the value when running sql script select cast( cast(.0000006 as numeric(38,10)) * cast(1.0 as numeric(38,10)) as numeric(38,10)) the result is .0000010000. why the result is not .0000006000 Well... speaking as someone who has just changed a whole bunch of tables, views, functions, etc. without fully appreciating that decimal (38,10) was not, perhaps, such a clever idea... I can only su ...Show All

• slhilbert active x script task error

  Hi, I am working with an active x script task and I keep getting this error. [ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x01DF3DD4. I have tried to delete all but the first couple of lines but I keep getting this error. Does anyone have any ideas on how I can fix this. This code worked fine in SQL Server 2000. Thanks Brian This is a snippet of my code Function Main() Const a ...Show All

• mAuo GACing components

  Hi, help please!! I'm trying to GAC a component that I've built. I had one of my company's .Net gurus help me out with this and we did a few things without me actually following what was going on. Stuff like creating a public key, creating a .snk file in C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents...I have to confess I didn't really follow what he was doing! But, we did manage to succssfully get my component into the SSI ...Show All

• pierguido Using a Report parameter in the Subscription query?

  Hi, I have a report that uses the Report Parameter 'DatasetID' in its queries. I want the query of a data-driven subscription to also use this DatasetID parameter. I tried 'DatasetID' and '@DatasetID' and 'Parameters@DatasetID.Value' to reference this parameter in the subscription query. But it just does not seem to work. Does anyone know how and if this will work Thanks a lot in advance!! Regards,  Philip ...Show All

• Roger_Wolter_MS database design - joins on which fields?

  Hi, I,m trying to develop a relational database but confused so much & need help to streamline the basics of the the database design error free. Below is the case, There r six databases with the joined fileds as below, Buyer( filed used to join with style / po / production / shipped = Buyer Name ) Factory ( filed used to join with style / po / production / shipped = Factory Name ) Style ( one style have multiple pos ) ( filed used to j ...Show All

• C. Venkata chary Installing sql express on a sql standard server installed machine

  Hi, i have sql server 2005 standard installed on my machine. I want to work on express edition and learn about it but on the installation its gets stuck because a higher version is installed. If the express version is free why cant have both versions installed on my machine. Thank you. They don't co-exist well. Just curious, why not use the standard install to do your training You can't install express and standard on the same machi ...Show All

• Doddsy Select date year below 1950 not valid?

  i am doing a select statement, the .sdf database file has dates from 1910 to 2020 Dim fullcurrent_date As Date = New Date(1950, 10, 2) Dim sqlstr As String = "SELECT * FROM table WHERE Start_Month <= '" & fullcurrent_date & "'" it seems to work alright, but if i were to initialize the Date as Dim fullcurrent_date As Date = New Date(1949, 10, 2) it doesn't seem to work, is there a limit somewhere as long the year ...Show All