Build Not Completing Fully

Nov 13, 2007

All:
I have about 35 packages in a SSIS Project and have been successful at building and deploying until now. For some reason it build stops processing after 5 packages and does not update the bindeployment folder.

Are there any logs to which I can refer to find out what is going on? Any ideas why I am experiencing this weird behavior all of a sudden.

I had to delete a couple of packages from my project as I created new replacements for them. I then noticed however that the packages did not get deleted from the bin and deployment folders and so I manually deleted them from those directories. Could this cause any problems and if so can I fix it now?

I appreciate your help and advice!

View 8 Replies


ADVERTISEMENT

SQL Server 2000 - What Is Fully Patched And How Do You Get It Fully Patched Sp4+

May 14, 2008

Having read the following :

How to identify your SQL Server version and edition
http://support.microsoft.com/kb/321185/


How to obtain the latest SQL Server 2000 service pack
http://support.microsoft.com/?kbid=290211


Service Pack 4 for Microsoft SQL Server 2000
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32desksp4.htm#_1461463_hardware_and_software_requiremen_fzpy


Cumulative list of the hotfixes that are available for SQL Server 2000 SP4
http://support.microsoft.com/?kbid=894905


A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187
http://support.microsoft.com/?kbid=916287


Which appears to indicate
8.00.760 = sp3/sp3a
8.00.2039 = sp4
8.00.2187 = Cumulative rollup
8.00.2249 Final patch build number

I still have the following question which i would very much appreciate help in answering:
If support is required from Microsft what is the acceptable level of SQL Server patching before Microsoft will agree to look at a SQL Server problem. ?
SP4 Build 2039 + Build 2040 (awe fix)
SP4 Build 2187 cumulative rollup
SP4 Build 2249 fully patched as per KB894905
Do I need to apply builds 2187 to 2249 ?
If so where/how can I obtain the down loads from ( 8.00.2187 - 8.00.2249) ?

Have logged a call with microsoft support but as yet no responce.

View 8 Replies View Related

Stored Procedure Stops Before Completing

Feb 28, 2001

I have a stored procedure that is calling a cursor to populate some variables it then uses those variable to get more information and then inserts that info into a final table. The estimated number of records that it should insert is around 2 million. The procedure stops after about 6000 records inserted. It still apears to be running but in fact is not. Can anyone help? I have also attached the code.


SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO




ALTER PROCEDURE [dbo].[create_table1_tmp] AS

/* table1 variables */
declare@v_ARCKEY int
declare@v_INVKEY int
declare@v_ITEM char (15)
declare@v_BRAND char(15)
declare@v_PRICE decimal(12, 2)
declare@v_QTYORD decimal(12, 3)
declare@v_QTYSHP decimal(12, 3)
declare@v_CTCKEY int
declare@v_SOMKEY int
declare@v_ORDATE datetime
declare@v_FNAME char (15)
declare@v_CONTACT varchar (20)
declare@v_TITLE varchar (25)
declare@v_SALUT char (4)
declare@v_DEGREE char (6)
declare@v_SALESMN2char (3)
declare@v_TTL_CODEchar (4)
declare@v_SPECIALTYvarchar (30)
declare@v_COMPANYvarchar (35)
declare@v_ADDRESS1varchar (50)
declare@v_ADDRESS2varchar (50)
declare@v_CITYvarchar (20)
declare@v_STATEchar (10)
declare@v_KEYCODEchar (10)
declare@v_ZIPchar (10)
declare@v_COUNTRYchar (2)
declare@v_ARCSOURCEchar (5)
declare@v_SLSVOLchar (1)
declare@v_TYPEchar (8)
declare@v_NUMDRSdecimal(9,0)
declare@v_BEDSIZEdecimal(4,0)
declare@v_NUMLIVESdecimal(9,0)
declare@v_CODEchar (3)
declare@v_SUBKEYint
declare@v_SUBTYPEchar (1)
declare@v_STARTDATEdatetime
declare@v_TERMdecimal(2, 0)
declare@v_STATUSchar (1)
declare@v_STATDATEdatetime
declare@v_XRENEWEDdecimal(2, 0)
declare@v_EXPDATEdatetime
declare@v_SHPAMTdecimal(12, 2)
declare@v_SOMSOURCEchar (5)
declare@v_PMETHchar (1)
declare@v_EXTPRICEdecimal(12, 2)
declare@v_CTYPEchar (5)
declare@v_CTCKEY_SBSUBS int
declare@v_ACRONYMchar (8)
declare@v_PONUMvarchar (20)
declare@v_EMAILvarchar (50)
declare@v_ARCPHONEVARCHAR (20)
declare@v_ARCFAXNOVARCHAR (20)
declare@v_CMCPHONEVARCHAR (20)
declare@v_CMCFAXNOVARCHAR (20)
declare@v_DOFAXTINYINT
declare@v_DOPHONETINYINT
declare@v_DORENEWTINYINT
declare@v_DOMAILTINYINT
declare@v_DOUPDATETINYINT
declare@v_UPDONLYTINYINT
declare@v_EMAIL_INFOTINYINT
declare@v_EMAILPROMOTINYINT
declare@v_DISCdecimal(7,3)
declare @v_EUPDATETINYINT

/* processing Variables */

declare @v_tmpint
declare@v_amtdecimal(9,3)
declare@v_loopint
declare@v_arckey_tmp INT
declare@v_ctckey_tmp INT
declare@v_invkey_tmp INT
declare@v_subkey_tmp INT
declare@v_arcDORENEW TINYINT
declare@v_cmcDORENEW TINYINT
declare@v_sbsDORENEW TINYINT
declare@v_arcDOFAX TINYINT
declare@v_cmcDOFAX TINYINT
declare@v_arcDOMAIL TINYINT
declare@v_cmcDOMAIL TINYINT
declare@v_arcDOPHONE TINYINT
declare@v_cmcDOPHONE TINYINT

/* cursors for retrieving online data*/



declarev_mast cursor for
select /*+ INDEX_COMBINE(arc) */
som.arckey arckey,
sot.invkey invkey,
sot.item item,
sot.price price,
sot.qtyord qtyord,
sot.qtyshp qtyshp,
som.ctckey ctckey,
som.somkey somkey,
sot.ordate ordate,
arc.phone arcphone,
arc.faxno arcfaxno,
arc.salesmn2 salesmn2,
arc.country country,
arc.source arcsource,
arc.slsvol slsvol,
arc.type type,
arc.specialty specialty,
arc.numdrs numdrs,
arc.bedsize bedsize,
arc.numlives numlives,
arc.code code,
arc.dorenew arcdorenew,
arc.company company,
arc.address1 address1,
arc.address2 address2,
arc.city city,
arc.state state,
arc.zipzip,
sub.eupdate eupdate,
sub.doupdate doupdate,
sub.subkey subkey,
sub.subtype subtype,
sub.startdate startdate,
sub.term term,
sub.status status,
sub.statdate statdate,
sub.xrenewed xrenewed,
sub.dorenew sbsdorenew,
som.shpamt shpamt,
som.source somsource,
som.pmeth pmeth,
sub.ctckey ctckey_sbsubs,
sub.updonly updonly,
sot.disc disc,
arc.dofax arcdofax,
som.ponum,
arc.domail,
arc.dophone
from sotran sot,somast som, arcust arc,sbsubs sub
where (som.arckey != '121449' and som.arckey != '1364166')

and (som.sotype not in (
select value from table1_param
where name = 'sotype') or
som.sotype is null)

and (som.sostat not in (
select value from table1_param
where name = 'somstat') or
som.sostat is null)
and arc.arckey = som.arckey

and (arc.code not in (
select value from table1_param
where name = 'code') or
arc.code is null)
and (arc.slsvol not in (
select value from table1_param
where name = 'slsvol') or
arc.slsvol is null)

and arc.foreign_ = 0
and sot.somkey = som.somkey

and (sot.sostat not in (
select value from table1_param
where name = 'sotstat') or
sot.sostat is null)
and sot.item > '0100'
and sub.subkey =* sot.subkey
order by arc.arckey,som.ctckey,sot.invkey,sub.subkey,sot.rq date desc

-- BEGIN PROCESSING THE CURSOR DATA HERE

OPEN v_mast

--pull all somast records where custno isn't 121449 or 1364166
--and sotype filtered and sostat isnot filtered

set @v_loop = 0
fetch next from v_mast into @v_arckey, @v_invkey, @v_item, @v_price, @v_qtyord,
@v_qtyshp, @v_ctckey, @v_somkey, @v_ordate, @v_arcphone, @v_arcfaxno, @v_salesmn2, @v_country,
@v_arcsource, @v_slsvol, @v_type, @v_specialty, @v_numdrs, @v_bedsize, @v_numlives,
@v_code, @v_arcdorenew, @v_company, @v_address1, @v_address2, @v_city,
@v_state, @v_zip, @v_eupdate, @v_doupdate, @v_subkey, @v_subtype, @v_startdate, @v_term, @v_status,
@v_statdate, @v_xrenewed, @v_sbsdorenew, @v_shpamt, @v_somsource, @v_pmeth, @v_ctckey_sbsubs,
@v_updonly, @v_disc, @v_arcdofax, @v_ponum, @v_arcdomail, @v_arcdophone
while @@fetch_status = 0--for v_rec in v_mast loop
Begin
set @v_loop = @v_loop + 1
set @v_expdate = dateadd(month,@v_term,@v_startdate) - 1
set @v_keycode = ''

--select company, address1, address2, city, state, zip
--from cmcship
--where ctckey = @v_ctckey

--if (@@rowcount = 0)
--set @v_tmp = null
--else
--begin
begin tran t1
set @v_company = (select top 1 company from cmcship where ctckey = @v_ctckey)
set @v_address1 = (select top 1 address1 from cmcship where ctckey = @v_ctckey)
set @v_address2 = (select top 1 address2 from cmcship where ctckey = @v_ctckey)
set @v_city = (select top 1 city from cmcship where ctckey = @v_ctckey)
set @v_state = (select top 1 state from cmcship where ctckey = @v_ctckey)
set @v_zip = (select top 1 zip from cmcship where ctckey = @v_ctckey)
commit tran t1
--end


--select company, address1, address2, city, state, zip
--from cmcadd
--where ctckey = @v_ctckey

--if (@@rowcount = 0)
--set @v_tmp = null
--else
--begin
begin tran t2
set @v_company = (select top 1 company from cmcadd where ctckey = @v_ctckey)
set @v_address1 = (select top 1 address1 from cmcadd where ctckey = @v_ctckey)
set @v_address2 = (select top 1 address2 from cmcadd where ctckey = @v_ctckey)
set @v_city = (select top 1 city from cmcadd where ctckey = @v_ctckey)
set @v_state = (select top 1 state from cmcadd where ctckey = @v_ctckey)
set @v_zip = (select top 1 zip from cmcadd where ctckey = @v_ctckey)
commit tran t2
--end

--select fname, contact, title, salut, degree, phone, faxno, ttl_code, dorenew,
--ctype, email, dofax, domail, email_info, emailpromo, docall
--from cmctac
--where ctckey = @v_ctckey

--if (@@rowcount = 0)
--RAISERROR ('cmc not found', 16, 1)
--else
--Begin
begin tran t3
set @v_fname = (select top 1 fname from cmctac where ctckey = @v_ctckey)
set @v_contact = (select top 1 contact from cmctac where ctckey = @v_ctckey)
set @v_title = (select top 1 title from cmctac where ctckey = @v_ctckey)
set @v_salut = (select top 1 salut from cmctac where ctckey = @v_ctckey)
set @v_degree = (select top 1 degree from cmctac where ctckey = @v_ctckey)
set @v_cmcphone = (select top 1 phone from cmctac where ctckey = @v_ctckey)
set @v_cmcfaxno = (select top 1 faxno from cmctac where ctckey = @v_ctckey)
set @v_ttl_code = (select top 1 ttl_code from cmctac where ctckey = @v_ctckey)
set @v_cmcdorenew = (select top 1 dorenew from cmctac where ctckey = @v_ctckey)
set @v_ctype = (select top 1 ctype from cmctac where ctckey = @v_ctckey)
set @v_email = (select top 1 email from cmctac where ctckey = @v_ctckey)
set @v_cmcdofax = (select top 1 dofax from cmctac where ctckey = @v_ctckey)
set @v_cmcdomail = (select top 1 domail from cmctac where ctckey = @v_ctckey)
set @v_email_info = (select top 1 email_info from cmctac where ctckey = @v_ctckey)
set @v_emailpromo = (select top 1 emailpromo from cmctac where ctckey = @v_ctckey)
set @v_cmcdophone = (select top 1 docall from cmctac where ctckey = @v_ctckey)
commit tran t3
--end

--select acronym, brand from invhead
--where invkey = @v_invkey

--if (@@cursor_rows = 0)
--set @v_tmp = null
--else
--begin
begin tran t4
set @v_acronym = (select top 1 acronym from invhead where invkey = @v_invkey)
set @v_brand = (select top 1 brand from invhead where invkey = @v_invkey)
commit tran t4
--end

set @v_amt = ((@v_qtyshp+@v_qtyord)*@v_price *(100-@v_disc))*.01

if @v_amt < 0
set @v_extprice = round(@v_amt,2)
else
set @v_extprice = round(@v_amt,2)

if (@v_arcdomail = 0 or @v_cmcdomail = 0)
set @v_domail = 0
else
set @v_domail = 1

if (@v_arcdofax = 0 or @v_cmcdofax = 0)
set @v_dofax = 0
else
set @v_dofax = 1

if (@v_arcdophone = 0 or @v_cmcdophone = 0)
set @v_dophone = 0
else
set @v_dophone = 1

if ((@v_arcdorenew = 0 or @v_cmcdorenew = 0) or @v_sbsdorenew = 0)
set @v_dorenew = 0
else
set @v_dorenew = 1

-- remove all but the newest orders

if @v_arckey = @v_arckey_tmp and @v_ctckey = @v_ctckey_tmp and
@v_invkey = @v_invkey_tmp and ((@v_subkey is null and
@v_subkey_tmp is null) or (@v_subkey = @v_subkey_tmp))
set @v_tmp = null
else
Begin
begin tran t5
set @v_arckey_tmp = @v_arckey
set @v_ctckey_tmp = @v_ctckey
set @v_invkey_tmp = @v_invkey
set @v_subkey_tmp = @v_subkey
commit tran t5
begin tran t6
insert into table1_tmp
(
arckey, invkey, item, brand, price, qtyord, qtyshp, ctckey, somkey,
ordate, fname, contact, title, salut, degree, salesmn2, ttl_code,
specialty, company, address1, address2, city, state, keycode,
zip, country, arcsource, slsvol, type, numdrs, bedsize, numlives,
code, subkey, subtype, startdate, term, status,
statdate, xrenewed,expdate, shpamt, somsource,
pmeth, extprice, ctype,ctckey_sbsubs, acronym,
ponum, email, arcphone, arcfaxno, cmcphone, cmcfaxno,
dofax, dophone, dorenew, domail, doupdate, updonly,
email_info, emailpromo, disc)
values (
@v_arckey, @v_invkey, @v_item, @v_brand, @v_price, @v_qtyord, @v_qtyshp,
@v_ctckey, @v_somkey, @v_ordate, @v_fname, @v_contact, @v_title,
@v_salut, @v_degree, @v_salesmn2, @v_ttl_code, @v_specialty, @v_company,
@v_address1, @v_address2, @v_city, @v_state, @v_keycode,
@v_zip, @v_country, @v_arcsource, @v_slsvol,
@v_type, @v_numdrs, @v_bedsize, @v_numlives, @v_code,
@v_subkey,@v_subtype, @v_startdate, @v_term, @v_status,
@v_statdate, @v_xrenewed, @v_expdate, @v_shpamt, @v_somsource,
@v_pmeth, @v_extprice, @v_ctype, @v_ctckey_sbsubs, @v_acronym,
@v_ponum, @v_email, @v_arcphone, @v_arcfaxno, @v_cmcphone,
@v_cmcfaxno, @v_dofax, @v_dophone, @v_dorenew, @v_domail,
@v_doupdate, @v_updonly, @v_email_info, @v_emailpromo, @v_disc
)
commit tran t6
End
fetch next from v_mast into @v_arckey, @v_invkey, @v_item, @v_price, @v_qtyord,
@v_qtyshp, @v_ctckey, @v_somkey, @v_ordate, @v_arcphone, @v_arcfaxno, @v_salesmn2, @v_country,
@v_arcsource, @v_slsvol, @v_type, @v_specialty, @v_numdrs, @v_bedsize, @v_numlives,
@v_code, @v_arcdorenew, @v_company, @v_address1, @v_address2, @v_city,
@v_state, @v_zip, @v_eupdate, @v_doupdate, @v_subkey, @v_subtype, @v_startdate, @v_term, @v_status,
@v_statdate, @v_xrenewed, @v_sbsdorenew, @v_shpamt, @v_somsource, @v_pmeth, @v_ctckey_sbsubs,
@v_updonly, @v_disc, @v_arcdofax, @v_ponum, @v_arcdomail, @v_arcdophone

end --while loop

close v_mast
deallocate v_mast

View 1 Replies View Related

Scheduled Job Running SSIS Packages Not Completing As Expected

Oct 2, 2007

I have a SQL Scheduled Job in SQL 2005 SP2 that executes a few different SSIS packages. When I update the SSIS Packages, SQL Agent runs the job and shows success; however, the underlying packages are not executed. The packages are located on the server but we are using UNC paths in the jobs since much of the time they are started manually from a remote workstation and the jobs seem to look at the initiating workstation's file server rather than that of the SQL Server. Is this a known issue?

Thank you,

Jennifer

View 7 Replies View Related

Business Intelligence Studio Crashes At The Point Of Completing Production Of A Model

Apr 11, 2007

Is there some memory limit on the size of models that can be successfully created as when I try to generate a model on a specific database I get the horrible Windows exception error in Visual Studio and it restarts leaving me without a model.



I have .99Gb of Ram, but a colleague has 1.99Gb of Ram and he appears to be able to generate the model successfully.



I can create models against older versions of the database successfully.



Surely there must be a friendlier way of trapping for insufficient memory problems rather than virtually completing a model and then robbing me of the model????



View 1 Replies View Related

Error On Build Solution, If SSIS Project Is Part Of Build

Mar 22, 2006

Hello,

we have automated build on every night. In our solution is SSIS project, where each package is encrypted per password. We call build process per command line like this..

C:ProgrammeMicrosoft Visual Studio 8Common7IDEdevenv.exe (c:DevelopmentX3\X3.sln /build Release)' in 'c:DevelopmentProjectsDailyBuild

Through build process we get a error:


External Program Failed: C:ProgrammeMicrosoft Visual Studio 8Common7IDEdevenv.exe (return code was 1):

We think a reason is, that on build of SSIS project must be entered a password. You can wonder for what we need that SSIS packages are part of our build. We hope that on build process is also created Deployment Utility, if so set in dtproject.user. Is it so? Is there any way to create Deployment utility on automated build process? Can be a password provided pre command line?

with best regards

Anton Kalcik

View 5 Replies View Related

RAM Not Being Fully Used?

Dec 6, 2007

Hello All,

We have a server running Windows Server 2003 with SQL Server 2005, it also does some minor file-sharing usage.
I noticed that the over 3/4 of our 2GB of RAM was being used by SQL and the pagefile was over 1.5GB constantly.
Needless to say this caused performance issues, so I upgraded to 4 GB of RAM.
However it would seem that nothing has changed.
The same amount of RAM is being committed to SQL resulting in the same size pagefile and 2GB of unused memory.
Should my Windows Processor Scheduling and Memory Usage be set to Programs or Background Services/System Cache for best performance and best usage of memory with SQL server?
Also when I look at the MS SQL server properties, what should these settings be for best performance and memory usage as they are currently set to:
NOT use AWE to allocate memory
0MB - minimum server memory
2147483647MB - maximum server memory
0KB - Index creation memory
1024KB - minimum memory per query

Any help with this problem would be greatly appreciated.

View 2 Replies View Related

When Will It Be Fully Supported?

Mar 23, 2006

Having sucessfully tested mirroring, I've suggested we should implement it at my place of work.

However, they are non too pleased that it is not yet officialy part of SQL Server 2005 and therefore not supported, does anyone know when it will be in standard edition? because I really really need to know...

Thanks







View 4 Replies View Related

Table Is Not Getting Updated Fully

Jan 31, 2008

Hi all,
i have a table1 with 3,25,000 records in US database.i want to upadate this table information in to table2 in SG database based on some condition (if prodid and skuno match in both tables, then update ordertransferind column in table2 from table1) what is happening is after 10,000 records query is not executing. in status bar it is displaying 'done'. but only 10,000 records are updating not the remaining ones. for this 10,000 records also it is taking more than 1 hour time. i tried by incresing the commandTimeout to max value(99999)...but still it is same...any advise...please suggest...
 i am using sql2005,visualstudio 2005....
 thanks for the help..
 
Anne

View 3 Replies View Related

Fully Editable Datagrid

Nov 10, 2005

I have been trying to formulate a fully editabe datagrid for a couple of days with no luck.  I have used code from 4guys and some other sites and am at the point where I can render the datagrid correctly (as a bouncolumn and template column-textbox) but when I try to update the database it all falls apart.  I am getting "input string was not in a correct format" and the error references ...Dim id as Integer = Convert.ToInt32(sls.DataKeys(dgi.ItemIndex))I suspect the problem lies in the area of primary indexes and such.  The table I am using is a simple two-column table with usernames, passwords.  Username is the primary field. Here is the actual code I am using...<code><%@ Page Explicit="True" Language="VB" Debug="True" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.OleDb" %><html>
<script runat="server">Dim Connect As OleDbConnection = New OleDbConnectionDim Adapter As OleDbDataAdapter = New OleDbDataAdapterDim DS As DataSet = New DataSetDim ConnectString, SelectStatement As String
Sub Page_Load(Sender As Object, E As EventArgs)
If Not IsPostBack Then SelectStatement = "Select * From Table"ConnectString = "Provider=SQLOLEDB;UID=;PWD=;" & "Data Source=;Initial Catalog=;"
Connect.ConnectionString = ConnectStringAdapter.SelectCommand = New oleDbCommand(SelectStatement, Connect)Adapter.SelectCommand.Connection.OpenAdapter.Fill(DS, "Items")sls.Datasource = DS.Tables("Items")Page.DatabindConnect.Close()End IfEnd Sub
Sub Click(sender As Object, e As EventArgs)  Dim myConnection as New OleDbConnection(ConnectString)Dim updateSQL as String = "UPDATE Table SET password = @Password WHERE Username = @ID"Dim myCommand as New oleDbCommand(updateSQL, myConnection)
Dim dgi as DataGridItemFor Each dgi in sls.Items  'Read in the Primary Key Field  Dim id as Integer = Convert.ToInt32(sls.DataKeys(dgi.ItemIndex))  Dim password as String = CType(dgi.FindControl("txtPass"), TextBox).Text
        'Issue an UPDATE statement...    myCommand.Parameters.Clear()  myCommand.Parameters.Add("@ID", id)  myCommand.Parameters.Add("@Password", password)
  myCommand.ExecuteNonQuery()Next
    End Sub
</script><body><form runat="Server">
<asp:datagrid id="sls" runat="server" AutoGenerateColumns="False" datakeyfield="Username">   <Columns>    <asp:BoundColumn HeaderText="UserName" datafield="Username"/>
         <asp:TemplateColumn HeaderText="Password">      <ItemTemplate>        <asp:TextBox runat="server" id="txtPass" Columns="10"              Text='<%# DataBinder.Eval(Container, "DataItem.Password") %>' />      </ItemTemplate>    </asp:TemplateColumn>
  </Columns> </asp:datagrid><asp:button id="Update" text="Update All" runat="Server" onclick="Click"/></form></body></html></code>Anyone have any idea as to why the id variable (error message above) is causing problems?

View 2 Replies View Related

Can You Fully Qualify A Server Name In T-SQL?

Jun 30, 2000

I know that you can fully qualify a database and dbo in a statement, but is it possible to do this for different servers? For example, if you have three different servers registered in Enterprise Manager, can you write a script that could query any of the three servers?

View 1 Replies View Related

Server Not Connecting Fully

Nov 11, 1999

I am managing a number of SQL Server 6.5 systems via lan and wan connections.
I have a couple of servers which, althought I have an administrator account on the server and access through the fire walls, I can only connect if I set up entries under the client config utility using named pipes with the relevant ip address.
The servers are set up to use both tcp/ip and named pipes. When I do connect I dont get the traffic lights, and Service manager shows the servers in indeterminate state although I know they are running OK.
When I expand the server in EM, the SQL Executive also does not appear, again the service is running.
I am connecting to the server as sa, and can perform all sa functions.
I have connected to the server through security manager and it shows me as an administrator with sa rights.
We are using standard security on these servers.

Anybody any ideas ?

Thanks in advance

Tom

View 1 Replies View Related

Not Fully Qualified Files

May 24, 2006

Hi all,

I need to create flat file connection managers. The connection Manager editor forces me to use fully qualified file names. Is there a possibility to use unqualified file names, because I need to reference to files in different directories with the identical file strcture.

Any Ideas?

Guido

View 1 Replies View Related

SQL Server CE V3.1 Not Installing Fully

Oct 25, 2007

I downloaded the windows installer: SQLServerCE31-EN.msi

When I run it, it creates a directory in Program Files The directory has a number of dll files, a Readme file, a word document, and a text document. There is no link to actually launch SQLServer though. I've tried repairing, and removing and reinstalling but the results are the same. Can someone help me figure out how to actually launch this application?

Thanks.

View 1 Replies View Related

Schema, Owner And Fully Qualified Name

Mar 27, 2008

I have a database that has been upgraded from SQL 200 to 2005. The database was owned by 'Joe' and all objects were also owned by 'Joe'. In SQL 2000 when Joe logged in he could simply issue 'select * from table' and would get results.

The upgraded db now has a user Joe and a schema Joe. All objects now belong to the schema Joe. Joe the user has his default schema set to Joe and he is the owner of the schema. When Joe logs in and tries to 'select * from table' he gets an invalid object. He can 'select * from joe.table'.

How can I set it up so that the objects are still owned by the schema Joe and a simple 'select * from table' works when user Joe logs in? I was convinced that is he owned the schema and this was his default schema it should work.

Thanks
scott

View 1 Replies View Related

SQL Search :: Expansion Not Being Utilized Fully

Jun 3, 2015

SQL Server 2008 R2

Issue: In the globalts I have 

<Expansion>
<sub>Multi-lan</sub>
<sub>Multilan</sub>
</expansion>

my where clause.. is similar to.'where Contains(Word, ''formsof(thesaurus,"'+@curWord+'") OR "'+@curWord+'*"'')'When i pass in Multi-Lan, i get results for Multi-LAN and MultiLAN.. however.. when i pass in Multilan.. i dont get results for Multilan nor Multi-lan.I have double checked my formats, and i have checked to see if this word was used in a previous expansion set.. everything checked out.  I also have many other expansions that function without issue. BT and Bluetooth are interchangeable.

View 2 Replies View Related

Statement Failed Not Fully Quailified

Nov 7, 2007



I have a database that is released as part of a thrid party product. I sent out an update but it failed at one of the customer sites because the objects were not fully quailified. The original statement work at all but one of the sites. The altered statement is what finally worked. The SQL Server instances are installation and configuration are controlled by our interface so all instances are installed and configured the same. Any idea on how this would happen? It has never happened on previous updates.

Original Statement:
SELECT * FROM tblProcesses WHERE ProcessName='Name'
IF @@ROWCOUNT=0
INSERT INTO tblProcesses(ProcessName, GroupTypeID, ProcessDesc) VALUES('Name', 1, 'Description')
GO

Altered Statement:
SELECT * FROM dbname.dbo.tblProcesses WHERE tblProcesses.ProcessName='Name'
IF @@ROWCOUNT=0
INSERT INTO tblProcesses(ProcessName, GroupTypeID, ProcessDesc) VALUES('Name', 1, 'Description')
GO

View 2 Replies View Related

How To Extract The Filename From A FULLY QUALIFIED NAME?

Nov 29, 2007

hi folks,

i am using foreach loop to load a whole load of files.
but these files are placed into various folders and with distinctive names.

each file is name is certain conventions that imply what sort of data is held in it. like

marketing_extract_20071204.csv
customers_extract_20071224.csv

but within the foreach loop i have a variable with the FULLY QUALIFIED NAME (FQN)as in:

Y:data_filesmarketing_extract_20071204.csv

thus i would like to find out how i can extract the filename from the FQN?

could i use a derived column expression or a script task?


many thanks for your assistance,

Nicolas

View 5 Replies View Related

Known Bug: Visual SVN Integration Not Fully Working With RS/VS.net

May 21, 2008

Details here: http://groups.google.com/group/visualsvn/browse_thread/thread/b05c327597d9cfae

Why not email them here

support@visualsvn.com

and get them to hurry up and fix it!

View 2 Replies View Related

SQL ERROR Not Recognizing The Fully Qualified Table Name

Aug 8, 2007

 Why am im i getting this error I am trying to join four table from different databases.select INBTable.InBound_Calls, OUTTable.OutBound_Calls, INBTable.Line_Number as INLine_Number,
OUTTable.Line_Number as OUTLine_Number, INBTable.Hold_Time as INHold_Time,OUTTable.Hold_Time as OUTHold_Time, INBAbandonInfo.INAbandon_Calls as INBAbandon_Calls,
OUTAbandonInfo.OutAbandon_Calls as OUTAbandon_Callsfrom sql2.XMWin_Test.dbo.temp_Report20070807IN as INBTable
JOIN sql2.Juniper_I.dbo.temp_Report20070807OUT as OUTTableon INBTable.Line_Number = OUTTable.Line_Number
sql2.XMWin_Test.dbo.temp_GraphIN_INAbandon as INBAbandonInfoJOIN sql2.Juniper_I.dbo.temp_GraphIN_OutAbandon.Line_Number as OUTAbandonInfo
on INBAbandonInfo.Line_Number = OUTAbandonInfo.Line_Number
 My Error Message:
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near 'sql2'.
 

View 2 Replies View Related

Fully Qualified Query Accross Databases

Sep 21, 2007

Are there any perfmonace or query optimization limitations or issues that arise when issueing a fully qualified query across multiple databases on the same Instance of SQL Server. In other words are all features of query optimization fully supported in queries that span databases on the same Instance.

View 3 Replies View Related

When To Use Fully Qualified Names ([database].[schema].object)

Dec 29, 2006

I wihsh to discuss whether to use fully qualified names:[database].[schema].objectof objects to operate (create, query..) on is good or not?If someone change order of sql code blocks in my script - this may causelose of it's context (like: use master / use <mydb>..). I wish to have mysript independed on changes like this and always produce correct result.Does using full name make use of 'use <db>' statement unnecessary?

View 8 Replies View Related

Static Analysis Of Scripts Not Containing A SQL Object Fully Qualified Name?

Mar 21, 2008

Hello everyone...

Our team has a DBA governing body that refuses to accept any T-SQL script that our dev group writes where fully qualified names of the objects aren't used. These non fully named objects in scripts just aren't accepted in their world.

So, all the scripts the developers now have to write must have fully qualified names in them. Of course, the Query analyser in Managment Studio could care less about object names as long as ambiguity is not found. So, I need some sort of Static Code analysis of these scripts that my team creates in order to hand them over to our DBA's to run.

The DBA's intend to make this inspection a manual process (they have time to kill I guess)... but my team doesn't have that luxury. It is not easy to ensure all scripts have this qualification in them with some many of them being written.

Does anyone know of any algorithim, tool, or options that could help me detect the presence of non-fully qualified names in T-SQL scripts?

Thanks for any ideas...
Ron D.

View 3 Replies View Related

Report Server Queue Not Fully Utilizing Resources

Mar 30, 2007

We've set up a report farm with two servers, both 64 bit with 4 CPUs each. One has 16Gig and the other 8Gig of memory. We're using Windows NLB and the load test software confirms that the NLB is working. When we run a number of concurrent reports, both servers get utilized, but they only work on a few at a time. The report server queue doesn't seem to be fully utilizing the hardware. From a prior post I've learned that the report server queue automatically runs 4 reports per CPU. This is not occuring for our setup. Has anyone else experienced the same? Are there any configurations that need to be set to open the queue up? The reports are heavy (300,000 records grouped and summed). Does this affect the queuing process?

View 4 Replies View Related

Do I Need To Fully Process The CUBE, If Structural Change To Fact Table Happens

Mar 31, 2007

I have a requirement.

I have a CUBE in SQL 2000. I need to change the structure of Fact Table and i need to add one more dimension to my CUBE.

What are the problems will arise if i do this. i need to Fully process the CUBE?


PLS help me

View 1 Replies View Related

Reporting Services :: Server Not Fully Functional After Migrating To New Domain

Jun 19, 2015

I had to migrate my report server (2008R2) to a new domain. I built new server and restored the old ReportServer and ReportServerTempDB into new server and also restored the certificate from old server. The Report Server is running but I don't have full access to all server futures anymore, looks like it's AD authentication messed up. My new account is Admin on new server but I can't see all options, like New Data Source, or wehn going on report level to manage to see all option such as Parameters, Subscriptions, Data Source.

View 2 Replies View Related

Are Integration Services Fully Supported On Named Instances Of 2005?

May 30, 2008

Hi folks
I have deployed a package from file resources to sql server named instance. I did not receive any errors. msdb..dtspackages90 table have rows for my package.
But when I try to connect to integration services using ssms like 'serverinstance', I am getting an error saying that 'serverinstance' names are not supported by integrated services and I should use just a servername.
What am I doing wrong? Is that really integration services are not supported on named instances or i miss something?

Thank you, Gene.

View 4 Replies View Related

Sqlcmd With Trusted Connection And IP Address Or Fully Qualified Hostname

Nov 9, 2006

The command sqlcmd seems to fail when using trusted connection and an IP address or a fully qualified hostname. For example:

sqlcmd -E -S nnn.nnn.nnn.nnn

where nnn.nnn.nnn.nnn is the real IP address of the machine, or

sqlcmd -E -S hostname.domain.com

where hostname.domain.com is the fully qualified hostname of the machine, gives the error:

Msg 18452, Level 14, State 1, Server 380GX280B05, Line 1
Login failed for user ''. The user is not associated with a trusted SQL Server c
onnection.

On the other hand, sqlcmd -E -S 127.0.0.1 works, and so does sqlcmd -E -S hostname, or sqlcmd -E -S tcp:hostname,1433.

This is on a clean machine, with SQL Server 2005 freshly installed as Administrator with mixed authentication, and the test runned also by Administrator.

Is it normal or is it a bug?

Thanks.

Georges

View 1 Replies View Related

Sqlcmd With Trusted Connection And IP Address Or Fully Qualified Hostname

Nov 9, 2006

The command sqlcmd seems to fail when using trusted connection and an IP address or a fully qualified hostname. For example:

sqlcmd -E -S nnn.nnn.nnn.nnn

where nnn.nnn.nnn.nnn is the real IP address of the machine, or

sqlcmd -E -S hostname.domain.com

where hostname.domain.com is the fully qualified hostname of the machine, gives the error:

Msg 18452, Level 14, State 1, Server 380GX280B05, Line 1
Login failed for user ''. The user is not associated with a trusted SQL Server c
onnection.

On the other hand, sqlcmd -E -S 127.0.0.1 works, and so does sqlcmd -E -S hostname, or sqlcmd -E -S tcp:hostname,1433.

This is on a clean machine, with SQL Server 2005 freshly installed
as Administrator with mixed authentication, and the test runned also by
Administrator.

Is it normal or is it a bug?

Thanks.

Georges

View 12 Replies View Related

One Or More Of The Server Network Addresses Lacks A Fully Qualified Domain Name (FQDN).

Jun 11, 2007

Hello Guys,

I had been trying to solve this error with no success :



One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.

The syntax for a fully-qualified TCP address is:
TCP://<computer_name>.<domain_segment>[.<domain_segment>]:<port>



I had installed three instances on my local machine to test Data base mirroring :

Principal : running SQL Developer Instance

Mirror : running SQL Developer Instance .

Witness : Running SQL Express.



Database mirroring already enabled using startup flag : -T1400



i even tried to configure it with out a witness but still have the same error .



I used the follwoing server name in the mirroring wizard(not localhost) :

Principal : TCP://Ali-laptop:5022

Mirrored : TCP://Ali-laptop:5023

Witness : TCP://Ali-laptop:5044



whats the problem guys?!

View 25 Replies View Related

SQL Server 2005 Evaluation Edition Conversion To Fully Licensed Version

Nov 30, 2006

We downloaded and installed the trial software of SQL Server 2005 Enterprise edition a month ago. We have purchased a fully licensed version of SQL Server 2005 Standard Edition and would like to apply the licensed version to our workstation clients since their SQL software will eventually expire. Our SQL Server is not an issue since we purchased a new Server and installed the new licensed version of SQL on it.

Is there an easy way to accomplish this or is an uninstall & reinstall of SQL on every workstation required?

Thanks,

ChrisB

View 1 Replies View Related

Upgrading From SQL Server 2005 Standard Evaluation Edition To A Fully Licensed Version.

Jan 3, 2007

I just received my licensed disks for upgrading my SQL Server 2005 Evaluation version to a fully licensed version. Do I simply run the two disks over top of the evaluation version or is it a little bit more complicated? Any input would be greatly appreciated. A little new to SQL.

Thanx

Chad

View 1 Replies View Related

Communications To The Remote Server Instance Failed Before Database Mirroring Was Fully Started

May 12, 2006

command in principal server

ALTER DATABASE database name

SET PARTNER = 'TCP://<mirror_server_name>:5022'

return:

Msg 1413, Level 16, State 1, Line 1

Communications to the remote server instance 'TCP://<mirror_server_neme>:5022' failed before database mirroring was fully started. The ALTER DATABASE command failed. Retry the command when the remote database is started.

This problem is only in production database any testing database include adventureworks mirroring sucessfuly. Why is problem:?

size? database > 9GB

slow HW? Principal database Intel D 3Ghz,4GB RAM, 4x 15k RPM HDD RAID 5 / Mirror database 2x Xeon 3Ghz,4GB RAM,6x HDD 10k RPM RAID 10

Slow LAN? both servers connect 1Gb/s

please help me

THX

View 17 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved