Hi,
I am facing an issue while updating a value in a table.
While I am executing a update query with condition, its executing fine but its returning total count of the rows of the table....
Hi there,
I have setup serveral maintenance plans on my design server and I now want to roll them out to the development, test, production servers.
Can I export the maintenance plan and ...
I need the query below modified to make this output, instead of the one listed.
TYPE = 1 (START) TYPE =2 (STOP) TYPE =3 (PAUSE)
------------------------------------------------------------...
We have set up a development SharePointServer 2007, connected to a stand alone SQL server, which we are running in a AD Domain. Everything has been setup and is working properly. We were just ...
I just successfully migrated the backend of an Access 2000 database into SQL Server 2005. Some of the column names in a couple of the tables were altered in the migration process and need to b...
I have a file I made from SQL Management Studio and am trying to run it from command prompt for backing up my machine. In the following command, what is CITRIX_METAFRAME??
sqlcmd -S .\CITR...
Is there a way to check image sizes in SQL Server and compress them if they are over a certain size?
I have a table that consists of a few keys and an XML fragment. I need to decompose that xml fragment and load it into a new table, with one row for each XML node. The XML node needs to be bro...
I have this Oracle query: SELECT FOI_CLIENT_ID_SEQ.NEXTVAL FROM DUAL that get the next client ID, and I would like to do a similar query in SQL Server 2000, considering that the table is empty...
Hi,
I'm trying to put together a very simple wen app that uses SQL server 2005 endpoints. I'm following an example by Peter Debetta. He makes it sound so easy ???
Below is the code I use...
I am setting up a test environment for SharePoint to mirror our production environment. However, on the test side I'm trying to use VMware to create a virtual machine for the SQL database.
...
Hi,
I have an insert trigger and an update trigger added and what i am finding is that on the insert occisionally it can cause a block on a process.
It is an ERP system (sage line500) th...
Is there any posibility to delete report on report server during deployment from Visual Studio - e.g. via some utility during build events? We are talking about 2005 version.
I found simila...
Hi
I am working with C# and SQL 2005
and add form, data source, bindng source, and some fields from my table
what I want to know is what is the best way to search any field that in t...
How do you make a SQL job using SQL not the GUI?
Here is my questions when running SQL2005 setup to install SSRS:
1) Is setup supposed to be run with all other components marked with red X except SSRS?
2) What is the difference betwee...
Hi,
I have a SQL Agent job which fires an SSIS package. The package contains 2 tasks which process an AS2005 database. Each cube/dimension is set to process in its own transaction. The s...
Hello Experts,
I have created oracle database with the following sql script(attached) .What changes do you suggest to have the same exact database in ms sql server 2005 .I never used sql se...
I am using a clustered instance of SQL Server 2005 Standard Edition on a 2 box cluster. I have the SSRS web server instance running on the same box.
What I'm noticing is that the Report ...
I have 2 tables. Sales_Detail and Sales_Detail_Discounts.
Sales_Detail Table:
Str_id * Rgst_id* Tran_id * Tran_Ln_Num * QTY
----------------------------------------------------------
1...
Ok this is a simple question and I am just starting out .When we deploy an GUI application buil in VB.NET that uses SQL SERVER EXPRESS EDITION, how do we embed it in the final installation pro...
I was trying to find the pros and cons of using this approach, but thought I would also ask everyone on here as well.
In Sql Server 2000 and 2005 I have used xml to perform multiple updates...
I tried to copy the resultset in sql server2005 to Excel.but i could copy only the results not the column names.can anyone tell me How to copy the result in mangement studio in sql server 2005...
Dear EE
I am working with Reporting Services 2005 and I want to limit the number of rows inside the report with either tabular report or Matrix report
How can I do that?
Please advise me w...
Dear Experts,
I wrote the query below a while back to select all products which are associated with an outlet.
I now wish to add in another layer which only selects a product when produc...
