-
- error
by guddu567568
- 14 Replies
- Last post
by guddu
- hi i have one varchar field i m convarting that field to datetime in format of dd/mm/yyyy
but i m getting eror
select top 30000 CMS_Upload_Details_ID,Scheme_Code,DrCr, convert(varchar(10),cast(AdditionalField5 as datetime),103) 'ValDate' ,AdditionalField13 'dept_slip',AdditionalField14 'dept_dt',Cheque_No 'Instrm_No',Amount,CONVERT (varchar(11),Instrm_Date,103)Instrm_Date ,AdditionalFiel
-
- Conversation enpoints are not getting cleaned up on target end
by Prashant jain
- 6 Replies
- Last post
by Roger_Wolter_MS
- Hi,
We are using service broker between two different instances. But were facing issues with increasing row count in conversation_endpoints view. We found that this was because we were using default value for lifetime for the conversation which is value of size int. Later on we changed the lifetime to 1 minute and conversation_endpoints view start getting cleaned up after 30 minutes
-
- RDA problem
by mj_realm
- 2 Replies
- Last post
by mj_realm
- Im having problems with my Pocket PC application deployed in Pocket Pc 2003 se Emulator... Im using the Pull method of RDA. I get the error "A request to send data to the computer running IIS has failed.". I have setup my desktop IIS and I can access the dll agent through Internet explorer. But when I try to access it on the Internet Explorer of the Emulator using the ip of my desktop in
-
- List of Store Procedures Called
by Vivekb
- 1 Replies
- Last post
by ggciubuc
- Hi
I want to know the Store Procedures called when i run my application.We want to disable / drop the store procedures that are not called. Is there any Trace Template available to do so . We ar e using Sql Server 2000
thanks
-
- .sdf databasse and programming
by Sheba
- 1 Replies
- Last post
by ErikEJ
- i need to access an .sdf database using microsfot visual forpro
what drivers/connection strings do i need
-
- Trigger to set status code using multiple conditions (EXISTS)
by JulieB
- 1 Replies
- Last post
by Nikhil Mehrotra
- My goal is to create a trigger to automatically set the value for a status id on a table based on set criteria. Depending on the values of other fields will determine the value that the status id field is assigned. So far, I have written the trigger to update the status id field and I go through a seperate Update statement for each status id value. The problem is that I can't get this to work at t
-
- Case Statement With Bigger than?
by Carel Greaves
- 6 Replies
- Last post
by Kent Waldrop Au07
- Hi
How can i create a case statement with a bigger and smaller than sign in it. I keep on getting an error.
Here is the piece of code i'm working on and simply enough, the idea of what i am trying to accomplish.
Code Snippet
SELECT Weight . Weight ,
Height . Height ,
( Weight . Weight /( Height . Height * Height . Height )) AS BMI ,
CASE BMI
-
- [Help Request]Editor Error
by Sazm
- 5 Replies
- Last post
by Sazm
- http://omni.game-host.org/1.jpg
http://omni.game-host.org/2.jpg
http://omni.game-host.org/3.jpg
http://omni.game-host.org/4.jpg
-
- Using parameter values in subscription fields?
by dj1smsu
- 0 Replies
- Last post
by dj1smsu
- Anyone know if it is possible to reference the parameter values stored for a given subscription, in the subscription fields (subject/comment)
So instead of just @ReportName at @ExecutionTime it could be @ReportName at @ExecutionTime (@ReportParameter1)
I know I can do this in data driven subscriptions, but was wondering if it was possible without.
Thanks,
-
- integrated authentication
by Qrx
- 1 Replies
- Last post
by Jimmy Wu - MSFT
- Hi,
I am writing project in asp .net with sql server 2005. But I need support him by some applications like deamon in linux systems.(but it will be in windows) So i write it in java. I download jdbc driver and install it. I wrote simple project:
package MainW;
//import javax.mail.*;
//import javax.mail.internet.*;
//import com.sun.mail.smtp.*;
//import javax.swing.*;
-
- remote access for windows form application
by craig11
- 3 Replies
- Last post
by Hemantgiri S. Goswami
- I have a windows based software application that connects remotely to a sql server 2005 and calls stored procedures. There is someone that I work with that is cautioning the company strongly that this is a bad thing to do in terms of security. Isn't this a very common thing to do Assuming that the SQL Server installation is setup appropriately. Is this a bad practice
-
- Coding a select statement for today's date and time
by AngelinaPerez
- 8 Replies
- Last post
by Soyuz
- Hello Everyone, I have a line of VB / SQL Server code as follows: Dim Command As New SqlClient.SqlCommand("SELECT * FROM CUSTOMER_MEET WHERE (MT_WEEK = CURRENT WEEK OF THE YEAR) AND ( MT_DATE = TODAY'S DATE )", conn). My problem here is how to code today's date in a format like this - October, 09 2007. The MT_DATE column on the database table has Varchar datatype - Varchar(21). Your h
-
- Reporting Services - statistics
by fafnir
- 5 Replies
- Last post
by ?®€?§Q?
- Where can I find statistics (if it is publicly available) on how many companies worldwide are using SQL Server Reporting Services
-
- IS IT A Challenge?(cOnfigurE a vIrtuaL dIrectorY fOR sYncronizatioN wIthouT wEB sYnchronizatioN wIzarD)
by Selimbd
- 1 Replies
- Last post
by Satya SKJ
- if you R Right Person Help Me Please.....
-
- SQL Server 2005 doesn't allocate available memory
by Urs_Eichmann
- 1 Replies
- Last post
by Amit Banerjee - MSFT
- running Sql Server 2005 SP2 on Windows 2003 Server SP1 with 2GB RAM. After start-up, the sqlservr.exe does only take up around 100 MB of RAM, and it stays roughly there even if the DB is used heavily. This leads to very poor performance, even timeouts on simple querys. In the task manager, I see that of the 2 GB of RAM, more than 1 GB is still available. I don't understand why SQL Server won't tak
-
- Selecting data from datalist
by Paarul
- 1 Replies
- Last post
by Phil Brammer
- Hi all
I am having problem in selecting the data from my datalist. Here is teh sample code
< asp:datalist id="dlAttrName" runat="server" OnItemCommand="dlAttrName_SelectData" DataKeyField="attrID" >
< ItemTemplate >
< asp:LinkButton ID="lbSelect" Runat="server" CommandName="Select" style="dis
-
- populate catalog Full Text Search SQL 2005
by FranzIt
- 10 Replies
- Last post
by sujoyduttain
- Hi To All
I'm trying to populate catalog in SQL 2005, but it doesn't work because in tables there are ntext fields.
In SQL 2000 it works normally.
I've made some test in both sql server.
Why Is there something to set in sql 2005
Thanks
Bye
-
- Merging a database into another
by Jade Skaggs
- 2 Replies
- Last post
by JadeS
- Hi everyone. I am working on an application that will use SQL Server Express locally installed on the client machines. We want to be able to deploy MDF files and merge those files into the clients existing database. For example, their databases will have a Produce table which will contain prices and varieties of products we give to the clients to sell. The clients will also have some records of th
-
- Limited Query Builder in sql2005 sms
by PDR
- 3 Replies
- Last post
by Jens K. Suessmeyer
- Can any body point me in the right direction before i pull all my hair out, (not much left).
Moving from sql 2000 to 2005, yes very pretty, but all i want 2do is quickly query a table, like u could in 2000 by right click the table name and select Query, my experiance of 2005 has been very frustrating, why remove useful features, not impressed.
anyway
Is it possible to invoke, from wit
-
- SQL Server 2005 service hung ... "Change Pending"
by JJKusch
- 10 Replies
- Last post
by tschi2001
- Have an interesting situation.
I have a NeverFail cluster on which I loaded SQL Server 2005 and SP1.
All was great. Both nodes had no issues with the initial setup or the SP1 update.
When I forced a failover to the inactive node, MOST of the services like SSIS, Full-Text and SQL Browser came up like a champ.
BUT ... the SQL Server service and the SQL Agent did not come up (or shall I s
-
- Installing SQL 2005 Express on VISTA
by St&#233;phane Beauchem
- 4 Replies
- Last post
by Stephane Beauchemin
- Hi,
I'm preparing to install VS2005 along with SQL Server 2005 express on VISTA. Honestly, I just hope nothing will get screwed up...
- After installing VS2005, I will first install SQL Server 2005 express from my VS2005 DVD
- I will then install SQL Server 2005 express with Advanced services SP2 as well
as SQL Server 2005 express toolkit SP2 upgrades.
A few t
-
- CREATE ASSEMBLY error: could not be installed
by rwbta
- 9 Replies
- Last post
by chris fitzmartin
- I ran the following: CREATE ASSEMBLY A3rdPartyDLL FROM 'C:\Program Files\3rdPartyComponents\3rdParty.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS and got the following error message: Assembly 'A3rdPartyDLL' could not be installed because existing policy would keep it from being used. How can I change the 'existing policy'
-
- Creating a script file from a diagram
by Dawid
- 2 Replies
- Last post
by Arnie Rowland
- Hi there,
I have created a diagram on my development SQL2005 database and want to transfer this diagram to my live environment. How do I go about creating a script to do this
thx
Dawid
-
- How to update the Pvot sheet?
by Joshker
- 1 Replies
- Last post
by Darren Gosbell
- I have a cube in SSAS 2005. I have created a Pivot sheet report from the same and published it via web-access as a webpage for the endusers.
I would like the pivotsheet data to be updted everynight after the cube is processed. How can I achieve that automatically
or is it simply that after the cube is processed the pivot also gets refreshed
Regards
Josh
-
- SSIS Error Running on SQL Cluster
by cawhetze
- 9 Replies
- Last post
by DouglasL
- I have the following setup:
1. Clustered Microsoft SQL Server 2005 (Build 3790: Service Pack 2) with .net 2.0 - Server A
2. Separate server containing the SSIS services (Per Microsoft - SSIS isn't cluster aware). - Server B
I am getting the following error when I run a SSIS package through a scheduled job on the Server A:
Description: The task "Set dynamic f