Answer Questions

• Nagie_Stopy Setting a value of the query result to scalar variable

  Hi! Is it possible to set a query result (scalar) to scalar variable. I would like to set a qery result (SELECT COUNT(*) FROM MyTable) to a scalar variable: DECLARE @temp int SET @temp = query result... Is it possible I couldn't find the way to do that... SET @temp = (SELECT COUNT(*) FROM MyTable) will do it. ...Show All

• Soydaner Ulker Cannot connect to remote SQL Server 2005 with ANY program - Please help!

  Hello all, Something odd has occurred on my computer. I have a remote sql server 2005 database on a hosting sites computer. I use the new ss 2005 mgmt studio to connect and administer my databases. I had connected to my db remotely many, many times through sql mgmt studio and then suddenly it stopped working. I now get the error # 26 - Error locating server/instance. I didnt change any settings in my system or install/remove any programs, th ...Show All

• Mulktide sa user account info

  i usually use the windows authentication mode when accessing my sql server but now that i need to use the SA account i can't seem to remember the password. is there any way that i could just reset the password for the SA account If you are a sysadmin on the SQL server, you can do this throug Enterprise Manager / Management Studio (depends on what version of sql server you are runing) or just by sp_password() stored procedure. ...Show All

• LonelyPixel User Defined Number Generator

  Hello all! I have a windows forms app and I'm trying to add functionality that would allow the user to enter a number into a textbox control on a setup form and then that number would autoincrement by one each time a new record on another form is inserted into the DB . I've searched high and low and can't seem to find much information on how I can put this together. I'm sure I'll need a "numbers" table in the DB that stores the n ...Show All

• EthanA Creating trigger with update

  Hello I am new to sql and asp, I am using visual web developer and have table that when it gets change I would like to see another table populated with the information. This is the two tables I have First one has the information in it that users will insert in it asset_id int Unchecked asset_desc varchar(50) Checked serial_no varchar(50) Unchecked model_no varchar(50) Checked category bigint Unchecked Manufacturer varchar(50) Checked Ma ...Show All

• Melvis Implementing co-related queries with EXISTS in MDX

  Hi, I am very new to AS 2005 and doing my 1st project of reporting. The current application is based on T-SQL queries running against a OLAP database. Me n my team has responsibility to change the current application and create cube & write MDX queries to get the required data. In T-SQL; we are using co-related queries with EXISTS clause. Can someone tell me how to implement same business rule [that we are currently implemented using c ...Show All

• markfield88 SSEM - How do you connect to an MDF file?

  I have SQL Server Express 2005 (April CTP) along with SQL Server 2005 Express Manager (SSEM).  I am trying to create an ASP.NET web site using VS 2005 and in the process I want to create and use a smallish SSE database using an MDF file.  I thought I could connect to the MDF with SSEM to populate the DB with some data but I can't figure out how to connect.  Does SSEM support this   Is there a better way to do this - perhaps f ...Show All

• MWade_MS Load images into Sql Server 2005

  Hi There I have not had much luck finding info in BOL for tsql or SSIS that tells one how to load images on the file system into sql server 2005. All i have really been able to find is that IMAGE data type will not be used in future and that one should use a varbinary(max) data type. I am thinking of using a for each file loop in SSIS, but then how do i load the images (.tif) into a sql server database table Perhaps i need to use a sql ...Show All

• xarcson June CTP - Underline hyperlink on mouse over

  Is there a way to underline a hyperlink (jump to URL) dynamically Thanks, Something we would like to add but this is currently not supported. ...Show All

• Dick Donny Synchronizing Very Large Database from PDA to SQL Server 2005.

  What is the best way to synch with a very large database (e.g. 40,000 products in Inventory Master) in connection oriented way and also offline mode for remote synchronizing the Data from PDA to SQL Server 2005. Kindly provide us some of the best practices on this concept. Thanks Hi,              Before jumping into answering your question, we need the following details: 1) &nb ...Show All

• Gaurav Singh Database connection fail

  I have got this error below which is similar with what has posted in forum. SQL_ERROR (-1) in OdbcConnection::connect sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. As i have found its solution in this forum. Here I would like to ask since my Ms SQL server epress set up fail due to the error above, but some of the previous setup is successful. In this case, am ...Show All

• kokain Export To PDF

  Hi, I have a table and a chart in my report .When i export it to PDF format the title of the report overlaps with the table and the chart spans 2 pages. Is there a remedy for this Hi, Thanks 4 ur reply... As 4 the first issue of overlapping i have solved it myself...had to do wit setting the Top width in the report.. As for the second issue,I am right now doing it the way u 've suggeste ...Show All

• Scott Kirk Scheduling SSIS Package

  Hi I am trying to scheduling package using "Executing Sql Server Agent Task" before that I create new job,But there is error in STEP "Command Line Parameter are Invalid" Anybody help me for configure jobs for Scheduling I am new to SQL Server Thanks in Advance    Doesn't matter. Execute your packages from the cmdexec subsystem using dtexec. You will get more useful error messages as expla ...Show All

• EddyQ Oleg at Ivolva Digital VS wizards

  Oleg at Ivolva Digital has even created VS wizards that start you off with the basic shell of a C# custom task or data flow component. http://www.ivolva.com/ssis_wizards.html does anybody know anything about these guys is this code safe to run ...Show All

• John Faris SQL Mobile Server Tools install on SQL 2000 SP4

  I am trying to install SQL Mobile Server Tools (beta 1) on my SQL Server 2000 SP4 server.  I have already installed the SP4 Replication Components upgrade and my existing SQL-CE databases replicate ok, however when trying to run the SQL Mobile Server Tools (beta 1) install it fails the System Configuration Check with the following error: "You must first install the Replication Components for SQL Server SP 3a or higher or the SQL Server 200 ...Show All