DSO in SQL2005: default

Showing posts with label default. Show all posts

Thursday, March 29, 2012

DSN goes to wrong database

Hello!

I set up a system DSN but it connects to the wrong database. I have set the default database correctly but it seems to ignore it.

If i switch to the correct BD like this: "USE myDB SELECT * FROM myTable" then it works fine.

Am i missing something?

this is my connection string [in my ASP page]:

"Driver={SQL Server};" &_
"Server=myServer;" &_
"DSN=myDSN;" &_
"UID=myUserName;" &_
"PWD=myPWD;"

Thanks!What database is it defaulting to ?|||Looks like you're mixing up the ODBC connect string data. Use one of these formats

To use the System DSN you created use
"Driver={SQL Server};" &_
"DSN=myDSN;" &_
"UID=myUserName;" &_
"PWD=myPWD;"
(may or maynot work)

To use a DSNless connection use
"Driver={SQL Server};" &_
"Database=myDB;" &_
"UID=myUserName;" &_
"PWD=myPWD;"
(Should work, but haven't tested)

I'm thinking it's probably trying to use the user's default database set up in SQL Server. Your alternative would be to go into use manager and change the default db (or tell your DBA to do it).

Originally posted by rnealejr
What database is it defaulting to ?|||yeah i think it has something to do with the particular user. a different username and password will change the default database.

i'll try that connection string. thank you!

the problem is i am the DBA at the moment. the ususal guy is away for awhile.

dropping default constraints

Hello

We've got a product which uses merge replication with anonymous pullsubscriptions.
At most custome sites it's running on SQL Server 2000, a few with SQL 2005, which is running wich replication compatibility level 80 due to .
As it happens, db schema changes. So I have to drop a column with a default constraint. First the constraint, then the column.
This works excellently on the publisher - but not on the subscriber Sad

The schema script 'exec sp_repldropcolumn '[dbo].[role_modul_rmd]', 'rmd_modul_enabled', 1' could not be propagated to the subscriber. (Quelle: MSSQL_REPL, Fehlernummer: MSSQL_REPL-2147201001)
Hilfe abrufen: http://help/MSSQL_REPL-2147201001
The object 'DF__role_modu__rmd_m__3119DB2C' is dependent on column 'rmd_modul_enabled'. (Quelle: MSSQLServer, Fehlernummer: 5074)
Hilfe abrufen: http://help/5074
ALTER TABLE DROP COLUMN rmd_modul_enabled failed because one or more objects access this column. (Quelle: MSSQLServer, Fehlernummer: 4922)
Hilfe abrufen: http://help/4922

What can bi done?

Thanks for your advice
Aline

We had this exact same problem.

First to recover your replication you can go in and drop the column manually on the subscribers. Then replication should recover.

This happens because replication does not deliver the commands in the correct order, it tries to drop the column first before droping the constraint which it cannot do. The only solution is to drop the constraint first then wait for everyone to replicate then try dropping the column.

Martin

Tuesday, March 27, 2012

dropping default constraints

Hello

What can bi done?

Thanks for your advice
Aline

We had this exact same problem.

First to recover your replication you can go in and drop the column manually on the subscribers. Then replication should recover.

Martin

Sunday, March 25, 2012

dropdownlist -default value!

hi ,

need your help please

I have got a dropdownlist which is getting it's items and values from the table with in SQL server , everything works fine.

I just want to be able to select default item , so when the page is loaded the dropdown list default will be that selected item.

as an exmple if the drop downlist items and values are as follow

item --> value
-------
city --> 1
tokyo --> 2
london -->3

these info is imported from the database
and I want by default tokyo to be selected

many thanks

------------
here is my code:


 Dim sqlConnection As SqlConnection
 Dim sqlDataAdapter As SqlDataAdapter
 Dim sqlCommand As SqlCommand
 Dim dataSet As DataSet
 Dim dataTable As DataTable sqlConnection = New SqlConnection("user id=sa;password=testfirm;database=ken_live;server=csfirm03")
 'pass the stored proc name and SqlConnection
 sqlCommand = New SqlCommand("Select * From _aci",sqlConnection)
 'instantiate SqlAdapter and DataSet
 sqlDataAdapter = New SqlDataAdapter(sqlCommand)
 dataSet = New DataSet()
 'populate the DataSet
 sqlDataAdapter.Fill(dataSet, "AA")
 'apply sort to the DefaultView to sort by CompanyName
 dataSet.Tables(0).DefaultView.Sort = "bsheet"
 city.DataSource = dataSet.Tables("AA").DefaultView
 city.DataTextField ="bsheet" ' what to display
 city.DataValueField ="bsheet" ' what to set as value
 city.DataBind()

Dim li as ListItem

FOR EACH li in city.Items
IF li.value = 2 THEN
li.selected = true
END IF
NEXT

|||I would also advise using a DataReader object rather than a DataSet and DataAdapter. The DataReader is much faster and does not use nearly as much resources. Also be sure to clean up after you use the objects, for example:


city.DataBind()sqlCommand.Dispose
sqlCommand = Nohting
sqlDataAdapter.Dispose
sqlDataAdapter = Nothing
dataSet.Dispose
dataSet = Nothing
sqlConnection.Close
sqlConnection = Nothing

HTH|||------ Edited by Colt ------
<code/> tag was added
------ Edited by Colt ------

thanks for the reply

I've changed the code, ( no error messages ) but no effect almost


 Dim sqlConnection As SqlConnection
 Dim sqlDataAdapter As SqlDataAdapter
 Dim sqlCommand As SqlCommand
 Dim dataSet As DataSet
 Dim dataTable As DataTable
 Dim li as listitem sqlConnection = New SqlConnection("user id=sa;password=testfirm;database=ken_live;server=csfirm03")
 'pass the stored proc name and SqlConnection
 sqlCommand = New SqlCommand("Select * From _aci",sqlConnection)
 'instantiate SqlAdapter and DataSet
 sqlDataAdapter = New SqlDataAdapter(sqlCommand)
 dataSet = New DataSet()
 'populate the DataSet
 sqlDataAdapter.Fill(dataSet, "AA")
 'apply sort to the DefaultView to sort by CompanyName
 dataSet.Tables(0).DefaultView.Sort = "bsheet"
 city.DataSource = dataSet.Tables("AA").DefaultView
 city.DataTextField ="bsheet" ' what to display
 city.DataValueField ="bsheet" ' what to set as value
 for each li in city.items
 if li.value="CITY" then
 li.selected=true
 end if
 next
 city.DataBind()

|||The DataBind() should preceed the For Loop that is selecting the default value.


city.DataBind()for each li in city.items
 if li.value="CITY" then
 li.selected=true
 end if
 next

|||thanks again for following the case
but still the porblem does exist ( no error messages but no effect as well )

code:

session("A")="0"

'object vars
Dim sqlConnection As SqlConnection
Dim sqlDataAdapter As SqlDataAdapter
Dim sqlCommand As SqlCommand
Dim dataSet As DataSet
Dim dataTable As DataTable
Dim li as listitem

sqlConnection = New SqlConnection("user id=sa;password=testfirm;database=ken_live;server=csfirm03")

'pass the stored proc name and SqlConnection

sqlCommand = New SqlCommand("Select * From _aci",sqlConnection)

'instantiate SqlAdapter and DataSet

sqlDataAdapter = New SqlDataAdapter(sqlCommand)
dataSet = New DataSet()

'populate the DataSet

sqlDataAdapter.Fill(dataSet, "AA")

'apply sort to the DefaultView to sort by CompanyName

'dataSet.Tables(0).DefaultView.Sort = "bsheet"

city.DataSource = dataSet.Tables("AA").DefaultView

city.DataTextField ="bsheet" ' what to display

city.DataValueField ="bsheet" ' what to set as value

city.DataBind()

for each li in city.items

if li.value="CITY" then

li.selected=true

end if

next|||As you had presented earlier, the Value property of the DDL was populated with a numeric value and the Text property was propulated with the character description (i.e., CITY).


li.value = 2

or you can use


li.text = "CITY"

HTH|||hi again :(

it didn't work.

always it is coming up wit it's own default one ( which is the fist row of data in database)

please , please , any alternative way

again I'm no getting any error messages

many thanks|||Please post your current code.|||


public Sub page_load(sender As Object, e As EventArgs) If Not Page.IsPostback Then
 session("A")="0"
 'object vars
 Dim sqlConnection As SqlConnection
 Dim sqlDataAdapter As SqlDataAdapter
 Dim sqlCommand As SqlCommand
 Dim dataSet As DataSet
 Dim dataTable As DataTable
 sqlConnection = New SqlConnection("user id=sa;password=testfirm;database=ken_live;server=csfirm03")
 'pass the stored proc name and SqlConnection
 sqlCommand = New SqlCommand("Select * From _aci",sqlConnection)
 'instantiate SqlAdapter and DataSet
 sqlDataAdapter = New SqlDataAdapter(sqlCommand)
 dataSet = New DataSet()
 'populate the DataSet
 sqlDataAdapter.Fill(dataSet, "AA")
 'apply sort to the DefaultView to sort by CompanyName
 'dataSet.Tables(0).DefaultView.Sort = "bsheet"
 city.DataSource = dataSet.Tables("AA").DefaultView
 city.DataTextField ="bsheet" ' what to display
 city.DataValueField ="bsheet" ' what to set as value
 city.DataBind()
 sqlCommand = New SqlCommand("select distinct datepart(yy,dateincur) as tempdate from ken_non_matter where nonmat in (935,1035,1040) order by datepart(yy,dateincur) desc",sqlConnection)
 sqlDataAdapter = New SqlDataAdapter(sqlCommand)
 dataSet = New DataSet()
 'populate the DataSet
 sqlDataAdapter.Fill(dataSet, "tempdate")
 'apply sort to the DefaultView to sort by CompanyName
 ' dataSet.Tables(0).DefaultView.Sort = "tempdate"
 year.DataSource = dataSet.Tables("tempdate").DefaultView
 year.DataTextField ="tempdate" ' what to display
 year.DataValueField ="tempdate" ' what to set as value
 year.DataBind()
 End if
 for each li in city.items
 if li.value="CITY" then
 li.selected=true
 end if
 next
End Sub

|||As you had presented earlier, the Value property of the DDL was populated with a numeric value and the Text property was propulated with the character description (i.e., CITY).

li.value = 2

or you can use

li.text = "CITY"

You are using li.value="CITY" (this is wrong according to your previous posts)

USE li.value = 2

HTH|||You shouldn't need to loop through the liost collection, either.

After you databind (and you should always bind the list before you attempt to set a default value), simply do the following:

city.Items.FindByValue("YOUR VALUE OR FIELDNAME GOES HERE").selected = true;

You can also use FindByText, if you prefer (city.Items.FindByText("text").selected = true)

If the ddl might have already contained a selected item, be sure to use ClearSelection first, or you'll throw an error...|||this is going arround

I manage to find where I'm going wrong but don't know how to fix it

for each li in city.items

If (li.text = "CITY ") then
li.selected=true
response.write(li.value) ' just Entered it as a test ! which doesn't print at all

End if

It runs the FOR loop fine but doesn't enter the IF statment.

just for test if I add

for each li in city.items

response.write("-"+li.value+"-")

if (li.text = "CITY ") then
li.selected=true
response.write(li.value) ' just Entered it as a test ! which doesn't print at all

End if

it will print

-AFSC --CITY --HKONG --INDIA --NZ -

whitch there is a space after the string therefore , I add a space after the 'city ' in my code

for each li in city.items

response.write("-"+li.value+"-")

if (li.text = "CITY ") then
li.selected=true
response.write(li.value) ' just Entered it as a test ! which doesn't print at all

End if

but still it is not entering the IF section

any ideas|||You're writing too much code. Try the method I posted above...|||it is small code but I've explained it,
it doesn't run

Sunday, March 11, 2012

Drop Default values in Columns

I have Column A and Column B in my Table they have Default values 'A' and 0 respectively.

I want to alter table.

I wrote

ALTER TABLE EMPLOYEE

DROP DEFAULT FOR COLUMN A,

DROP DEFAULT FOR COLUMN B

It does not work. I am new to Sql Server. Can you help me how to write alter table statement for dropping those default values.

I will really appreciate it.

Nature:

Run an SP_HELP on your table:

sp_help employee

and look for something like this:

-- constraint_type
-- -
-- DEFAULT on column a
-- constraint_name
-- -
-- DF__EMPLOYEE__A__461FBB34

And then execute something like this:

alter table dropDefault
drop constraint DF__EMPLOYEE__A__461FBB34

Dave

|||Sorry, that table name in the DROP statement must be EMPLOYEE and not "dropDefault"|||

Mugambo wrote:
Sorry, that table name in the DROP statement must be EMPLOYEE and not "dropDefault"

You can edit your posts...|||

Thanks, Phil, I keep forgetting. PLEASE keep reminding me about this until I get it right.

Dave

Friday, March 9, 2012

Drop Column with default constraint in T-SQL

Hello,
I'm making an SQL script that has to drop some columns. The problem is that
the column has a default value and therefore I can't use the DROP COLUMN
directly. I've got to drop the 'default' constraint, but the problem is that
we have to use this script on different database and then the constraint nam
e
is not always the same.
(example:)
DB1 -> DF_COLUMNX_ddf87d67s68
DB2 -> DF_COLUMNX_ddf79djks90
I know how to get the Constraint name but I can't use that as a variable in
the DROP CONSTRAINT function.
Has someone a solution for this problem? It has to be done with scripting!examnotes (Martijn@.discussions.microsoft.com) writes:
> I'm making an SQL script that has to drop some columns. The problem is
> that the column has a default value and therefore I can't use the DROP
> COLUMN directly. I've got to drop the 'default' constraint, but the
> problem is that we have to use this script on different database and
> then the constraint name is not always the same.
> (example:)
> DB1 -> DF_COLUMNX_ddf87d67s68
> DB2 -> DF_COLUMNX_ddf79djks90
> I know how to get the Constraint name but I can't use that as a variable
> in the DROP CONSTRAINT function.
> Has someone a solution for this problem? It has to be done with scripting!
SELECT @.default_name = o2.name
FROM syscolumns c
JOIN sysobjects o ON c.id = o.id
JOIN sysobjects o2 ON c.cdefault = o2.id
WHERE o.name = @.tbl
AND c.name = @.col
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||You'll have to resort to dynamic SQL:
declare @.constraint varchar(8000), @.str varchar (8000)
set @.constraint = 'DF_COLUMNX_ddf87d67s68'
set @.str = 'alter table MyTable drop constraint ' + @.constraint
exec (@.str)
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Martijn" <Martijn@.discussions.microsoft.com> wrote in message
news:3C62E773-C60A-46ED-A8A0-32E5AFDC7ACF@.microsoft.com...
Hello,
I'm making an SQL script that has to drop some columns. The problem is that
the column has a default value and therefore I can't use the DROP COLUMN
directly. I've got to drop the 'default' constraint, but the problem is that
we have to use this script on different database and then the constraint
name
is not always the same.
(example:)
DB1 -> DF_COLUMNX_ddf87d67s68
DB2 -> DF_COLUMNX_ddf79djks90
I know how to get the Constraint name but I can't use that as a variable in
the DROP CONSTRAINT function.
Has someone a solution for this problem? It has to be done with scripting!|||To have more control over constraint names, create constraints using the
ALTER TABLE:
alter table owner.table
add constraint constraint_name
default (<default_value | default_expression> )
for column_name
with values
go
This way you control the names of constraints (in this case the name of the
default constraint).
ML

Drop column with default constraint

Hello
I have a table with column which have default constraint
(SQL server generated name of constraint).
Is there a way to drop this column without re-creating the table?
Example:
create table abc (xxx int, yyy int default 0);
alter table abc drop column yyy;
Thanks
TibXSee thread:
SQL Help with Drop Column
http://tinyurl.com/65nva
Bryce|||It's a good idea to give a default a meaningful name when you create
it. Query Analyzer will show you the name of the constraint in the
object browser (the name of a default begins with DF and includes the
table and column name). Then you can drop it in the usual way:
ALTER TABLE abc DROP CONSTRAINT DF__abc__yyy__208E6DA8;
ALTER TABLE abc DROP COLUMN yyy;
David Portas
SQL Server MVP
--|||Try,
use northwind
go
create table t (
colA int,
colB varchar(25) default ('aaaaa')
)
go
declare @.sql nvarchar(4000)
declare @.cnstname sysname
select
@.cnstname = [name]
from
sysobjects as so
where
xtype = 'D'
and parent_obj = object_id('dbo.t')
and col_name(parent_obj, info) = 'colB'
if @.cnstname is not null
begin
set @.sql = N'alter table dbo.t drop constraint ' + @.cnstname
execute sp_executesql @.sql
end
go
alter table dbo.t
drop column colB
go
alter table dbo.t
add colB varchar(25)
go
alter table dbo.t
add constraint df_t_colB default ('aaaaa') for colB with values
go
alter table dbo.t
drop constraint df_t_colB
go
alter table dbo.t
drop column colB
go
alter table dbo.t
add colB varchar(25)
go
create default df_t_colB as 'aaaaa'
go
execute sp_bindefault df_t_colB, 't.colB'
go
execute sp_unbindefault 't.colB'
go
drop default df_t_colB
go
drop table dbo.t
go
AMB
"TibX" wrote:

> Hello
> I have a table with column which have default constraint
> (SQL server generated name of constraint).
> Is there a way to drop this column without re-creating the table?
>
> Example:
> create table abc (xxx int, yyy int default 0);
> alter table abc drop column yyy;
>
> Thanks
> TibX
>|||The problem is that I have several installations
with generated name of that default constraint
and I need drop column by a script.
TibX
David Portas wrote:
> It's a good idea to give a default a meaningful name when you create
> it. Query Analyzer will show you the name of the constraint in the
> object browser (the name of a default begins with DF and includes the
> table and column name). Then you can drop it in the usual way:
> ALTER TABLE abc DROP CONSTRAINT DF__abc__yyy__208E6DA8;
> ALTER TABLE abc DROP COLUMN yyy;
>|||Try this:
DECLARE @.df SYSNAME
SET @.df =
(SELECT OBJECT_NAME(cdefault)
FROM SYSCOLUMNS
WHERE id = OBJECT_ID('dbo.abc')
AND name = 'yyy')
IF @.df IS NOT NULL
BEGIN
EXEC sp_rename @.df, 'df_to_drop', 'OBJECT'
ALTER TABLE dbo.abc DROP CONSTRAINT df_to_drop
END
ALTER TABLE dbo.abc DROP COLUMN yyy
David Portas
SQL Server MVP
--|||Thanks for your solutions.
I use
select name from sysobjects ...
TibX

Wednesday, March 7, 2012

drop and create constraint

Hi There,
I've to alter the default constraint, So i drop then create agains. Before
applying this changes to all database, do i need to tell users to log off. o
r
will it work even they are connected to the system
Thanks
GaneshOn Thu, 18 May 2006 09:11:01 -0700, Ganesh wrote:

>Hi There,
>I've to alter the default constraint, So i drop then create agains. Before
>applying this changes to all database, do i need to tell users to log off.
or
>will it work even they are connected to the system
Hi Ganesh,
You can drop and create constraints while users are connected to the
database.
That being said - if possible, do this during maintenance window or
during times of low usage. The creation of the constraint (except a
DEFAULT constraint) will also cause SQL Server to check all existing
data . On a big table, this will take some time - and others won't be
able to access the table during that time.
Hugo Kornelis, SQL Server MVP

Sunday, February 26, 2012

Drop a column

You just need to drop the default first:
ALTER TABLE dbo.ObjetName
DROP CONSTRAINT DF__ObjetName__ColumnName__41DEAF21
GO
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Thank you very much Paul
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:1d5801c4fd6d$739195c0$a301280a@.phx.gbl...
> You just need to drop the default first:
> ALTER TABLE dbo.ObjetName
> DROP CONSTRAINT DF__ObjetName__ColumnName__41DEAF21
> GO
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Now I can drop the constraint and the column in the publicator.
I run the snapshot, but when I try start sincronizing, it's give me this
error
The schema script 'exec sp_repldropcolumn '[dbo].[TableName]', 'ColumnName',
1' could not be propagated to the subscriber. The step failed.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:1d5801c4fd6d$739195c0$a301280a@.phx.gbl...
> You just need to drop the default first:
> ALTER TABLE dbo.ObjetName
> DROP CONSTRAINT DF__ObjetName__ColumnName__41DEAF21
> GO
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||David,
you only need to run the snapshot agent if you're resynchronizing - and not
here. I suspect you have indexes/defaults on the subscriber that are
preventing the alter table working there. Now that the alter table is in the
queue, you'll have to remopve these constraints by hand before
synchronizing, or reinitialize. If you choose the former, it should be
obvious what is blocking the subscriber, but if not, have a look at logging:
http://support.microsoft.com/?id=312292
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Friday, February 17, 2012

drilldown group expanded by default

Hello!!

I have a matrix in a report with groups and subgroups like this :

*group1

*subgroup1.1

item1

item2

etc.

I would like to show the group expanded by default so when I view the report I see:

*group1

subgroup1.1

*group2

subgroup 2.1

Right now I've played with InitialToggleState and visibility->Hidden properties but I don′t know how to do it....help me please

Thanks

You need to set the visibility of the inner group to true. Right click and edit the group in the matrix.|||

I published an article showing the steps for this (at least an example similar enough to be useful, hopefully):

http://www.databasejournal.com/features/mssql/article.php/3527321

This was for MSRS2000, but the logic should be good in SSRS2005.

Good Luck!

Bill

William E. Pearson III
CPA, CMA, CIA, MCSE, MCDBA
Island Technologies Inc.
931 Monroe Drive
Suite 102-321
Atlanta, GA 30308

404.872.5972 Office

wep3@.islandtechnologies.com
wep3@.msas-architect.com

www.msas-architect.com
-- -- --

Publisher Sites:

http://www.databasejournal.com/article.php/1459531

http://www.sql-server-performance.com/bill_pearson.asp

http://www.informit.com/authors/bio.asp?a=862acd62-4662-49ae-879d-541c8b4d656f

http://www.2000trainers.com/section.aspx?sectionID=17

Tuesday, February 14, 2012

Drill down problem, report jumps to top of table!

Hi
I have a report with a table which has two groups. Each group is collapsed
by default when the report loads. When I click on the first group expand
icon (+) the group expands but also the report jumps up the screen so that
the top of my first data row in my table is alligned to the top of the IE
window. This is really annoying and I do not understand why it is happening.
Is this a known bug in RS or has anyone else had this problem and been able
to solve it? It also happens when I expand/collapse the second group.
I think it only started happening after I added a few images to my report. I
have tried removing the images from the report but this does not get rid of
the problem.
Any help/ideas would be greatly appreciated.
Kind Regards
Lewis Holmes
eNateHi
Problem solved!
In Visual Studio I had the page setup so that the body of the report was
larger than the area visible on the screen and so my footer was off the
screen. I have now changed this so that the body of the report is just large
enough for the contents of the body. Now the report does not jump around
when I expand/collapse groups.
Hope this may help anyone else with the same problem.
Regards
Lewis Holmes
eNate
"l.holmes" <enate@.newsgroups.nospam> wrote in message
news:u1ST$9g3FHA.2552@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have a report with a table which has two groups. Each group is collapsed
> by default when the report loads. When I click on the first group expand
> icon (+) the group expands but also the report jumps up the screen so that
> the top of my first data row in my table is alligned to the top of the IE
> window. This is really annoying and I do not understand why it is
> happening. Is this a known bug in RS or has anyone else had this problem
> and been able to solve it? It also happens when I expand/collapse the
> second group.
> I think it only started happening after I added a few images to my report.
> I have tried removing the images from the report but this does not get rid
> of the problem.
> Any help/ideas would be greatly appreciated.
> Kind Regards
> Lewis Holmes
> eNate
>|||Hi Lewis,
It's great to hear you have resolved it and thanks so much for sharing your
experience with us.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Thursday, March 29, 2012

DSN goes to wrong database

dropping default constraints

Tuesday, March 27, 2012

dropping default constraints

Sunday, March 25, 2012

dropdownlist -default value!

Sunday, March 11, 2012

Drop Default values in Columns

Friday, March 9, 2012

Drop Column with default constraint in T-SQL

Drop column with default constraint

Wednesday, March 7, 2012

drop and create constraint

Sunday, February 26, 2012

Drop a column

Friday, February 17, 2012

drilldown group expanded by default

Tuesday, February 14, 2012

Drill down problem, report jumps to top of table!

DSO in SQL2005

Blog Archive

About Me