DTS - Access Commection Properties

Feb 24, 2005

Does anyone know what the different values are (and what they mean) on the "Database Locking Mode" column off of the advanced button on a microsoft access connection within a DTS package on SQL server 7.0 ?

It's a 4 byte signed integer type with a default value of zero

Cheers,

Duncan

View 1 Replies


ADVERTISEMENT

Access And Extended Properties

Jun 6, 2007

Hello,
Can I read and write the extended properties with Access?


If it€™s possible is better create a project (ADP) or a classic MDB?



When I try with this query in the query panel (in a MDB)

SELECT objtype, objname, name, value
FROM fn_listextendedproperty
(NULL, 'schema', 'Person', 'table', default, NULL, NULL)



I have this error message:



The size of a field is too long



If I try with an ADP, when I ask a new query in design view, I have a message for some roblems between the Access version (2003) and SQL Server version (2005) and I can€™t save the query.



Tanks.

View 1 Replies View Related

Cannot Execute Sp/access Sp Properties Using Gui

Sep 5, 2007

I am not able to right click to execute a stored procedure or right click to access the stored procedure properties using Management Studio. Any ideas on what is causing this or if it is supposed to be this way?

Any help is much appreciated.

View 2 Replies View Related

Pragmatically Access To Package Properties?

Nov 7, 2007

Hi
We have a list of 40-50 SSIS packages and could grow up to 100. Each one loads 5-20 tables. I’d like to write a program (probably another package utilizing "Script task/component") to:

1- List all the packages by name
2- List input and output tables and/or file systems for each package
3- List child packages and procedures that are referenced in each package
So I need to have access to the Package properties.

I would like to hear your idea/clue/tips and or any helpfull direction.

Thanks so much.

View 4 Replies View Related

Grant Access To Extended Properties

Aug 28, 2006

Hi!I have a user on my database that has only "select" access(db_datareader).Problem is, I also want him to also be able to create/update extendedproperties on tables or views, but without modifying the tables'schema.I played around with GRANT but apparently, a member of "db_datareader"cannot create/modify extended properties on an object if he's not theowner of this object. I tried making this user a member of"db_datawriter", but it didn't work.Nothing short of making him member of "db_ddladmin" worked... but thenthis is too much, the user can now alter to delete tables: i DON'T wantthat!Any ideas anyone? Cheers!Ben

View 3 Replies View Related

How Do I Get Db Ddl Properties From Sql 2000 Like Documenter Does In MS Access?

Jul 20, 2005

Hi,I am looking for an easy way to get all of the properties from a SQL 2000database much like the documenter does in MS Access. Any ideas?

View 1 Replies View Related

How To Access The Properties And Methods Of Rdl From Webpage.

Aug 14, 2007



Hi,


I have created a report in reporting service 2005 and i have succesfully integrated the report in asp.net webpage.
But i want to know whether it is possible to access the methods and properties of (report)rdl file in the asp.net webpage.
If it is possible then please tell me how to implement it



Thanks and Regards
Altaf Hussain N

View 1 Replies View Related

Can't Access Properties On Stored Procedures

Jul 3, 2007

Hi. I have set up an instance of SQL 2005 on my local computer. I use MS SQL Server Management Studio to login into my 2005 instance via Windows login. When I expand "Stored Procedures" under "Programmability" of the Database I want and go to a stored procedure and right click, I don't see the "properities" selection.

I know it's there because I can get to it on other instances but I can't get to it on my local instance. I added my windows user to my Logins and then to my database users but it didn't help.

Can anyone please tell me what I need to do so I can access the properties of the stored procedures?



Thanks

View 3 Replies View Related

Content Manager Can't Access Rs Properties Page

Jan 12, 2007

Hi,

in one of our team projects users whom are members of the reporting services €œcontent manager€? role are not able to get onto the €œsql server€™s reporting services€? properties page of their team project. Instead of that page they receive the following error message:

The permissions granted to user '<UserName>' are insufficient for performing this operation. (rsAccessDenied)

With four eyes we double checked that the users really have the content manager role, we also tried all kinds of role combinations with no success.

The interesting thing is that as soon as they €˜only€™ in the Browser role they have access to that particular page €“ but as expected are unable to administer their team projects reporting services.

The reporting services forum doesn€™t really offer any answers to this problem, neither did goolge nor this forum.

Could anyone explain this behavior to me?

Pls let me know if you need additional information on this.

Thanks,

Tom

View 4 Replies View Related

Can I Access Another Component Properties From A Script Task

Nov 13, 2007

I have a component who's OnPreExecute event handler contains a Script Task. I would like to use this Script Task to access the component's properties. Can anyone provide script examples for doing this if this is possible?

View 6 Replies View Related

Cannot Access Expression Builder Via Variable Properties Window (no Ellipsis)

Sep 5, 2007

Has anyone encountered this before?

My colleague opens up an SSIS package with variables, many of which use expressions built with the Expression Builder. She cannot bring up the Expression Builder by clicking the ellipsis (...) in the "Expression" Property of the Property Window, regardless of whether "EvaluateAsExpression" is set to True or False.

I can open up this same package and use the Expression Builder just fine. Any ideas?

Apologies if this has been answered already, I did many searches to try to find the solution before posting here.

Thanks much!

Brian Pulliam

View 14 Replies View Related

SQL 2012 :: Connection Properties Versus SSMS Server Properties

Mar 16, 2015

I have an ODBC connection string that is working fine with the following properties:

Database="XXXXXXX",Network="YYYYYY"; strangely no server is specified in the string, but it is specified in the ODBC Connection file.

I am trying to do a new server registration in SSMS for this database.However, I don't understand where the network spec is placed.

Under Registered server name I've tried:

YYYYYYXXXXX

When I browse the server for the database instance list, I receive "network path was not found".

I even tried:"XXXXXXX",Network="YYYYYY" for the registered server name.Same error message.

What am I doing wrong ?

View 1 Replies View Related

Database Properties

Oct 31, 2007

is there anyway to retrieve the database properties and display in an asp.net web form as a quick over view rather than logging onto the server to check, items such as size, space available, last backup data etc? Cheers 

View 2 Replies View Related

Sql Login Properties

Oct 19, 2000

Hi and thanks for your help
specifying the default database means what. for instance when I add alog in user and I have to choose a default database. Does it make a difference if the Default database is Master or any other user database name. What is the significant to select Master vs any other database.


Thanks,

Ahmed

View 1 Replies View Related

Server Properties

Oct 11, 2002

Hello!
We are having problems with a single SQL Server where the Server properties will not save, and always revert to the default.
It occurs only on those tabs with "configured" and "running" options at the bottom. Other tabs will keep the settings we custom.
The big problem is with the memory and processor tabs which even when we've made only a single change and stopped and started the service, reverts back to a default.
Any clues - we are logged in as "sa" and have not removed the SA priviledges.

Thanks for any help,
Simon

View 1 Replies View Related

Properties Hangup

Apr 4, 2003

Once upon a time, I went to check the properties of an instance and EM just hung - anyone know why this might happen?

View 1 Replies View Related

Help ::: Extended Properties

Aug 15, 2002

Hi all,

Plz help me to know whats wrong with following script:

EXEC sp_addextendedproperty
@name = 'col_Programs_ID_Description',
@Value = 'The Unique Identifier for a specific Program',
@level1Type = 'Programs',
@level2Type = 'ID'

I get the following error:
Server: Msg 15600, Level 15, State 1, Procedure sp_addextendedproperty, Line 42
An invalid parameter or option was specified for procedure 'sp_addextendedproperty'.

NOTE: If I dont use the last 2 parameters this procedure runs fine, but it adds the Extended Property to the Database Level while I'm trying to add it to the TABLE-->COLUMN level.

Thanks
Mariah

View 2 Replies View Related

File Properties

Dec 30, 2004

Hi all,

I'm having a problem need your help:

I can see all properties of datafile (FilegroupName, FileID, FileType,
Location, CurrentSize, Space Used) by Enterpise Manager.

Please tell me how do I see all those properties by SQL Query Analyzer.
I want to know actual space used in data file to shrink file.

Thanks in advanced,
TN

View 5 Replies View Related

Right-click Db Properties EM Goes Bye Bye

Jan 11, 2005

Running SQL2000 SP3.

We installed an application named Streamserve. Now, if I go into Enterprise Manager I can expand the databases fine. But when I try to right-click properties Enterprise Manager goes bye bye. No error messages. I tried this on master and same thing. I currently have 2 different machines - a dev and a QA box and both are behaving badly.

Any ideas?

Thanks
Sharon

View 4 Replies View Related

Properties Of Jobs --&> New Job?!

Apr 25, 2008

Hi,

when ever I try to look at the properties of a job, the create new job window appears. what gives?

View 7 Replies View Related

Database Properties

Sep 28, 2007

When I create a new database it asks for information regarding the Data files.

What is it for? Will this file get creted to the location that I write?

How often will it get copied there?

View 1 Replies View Related

Server Properties

Dec 7, 2006

Help;Im New with a company and the sql server ismaxing out the cpu'sWe have 3 web servers load balanced....large volume of datathe current PropertiesComputer:4 amd 2.88 processors4 g MememoryRecomendations of good sql setupmemory, cpu etcThank youmike

View 6 Replies View Related

Missing Properties???

May 23, 2007

Has anyone tried to open a cube into Business Intelligence Studio and the properties for the database vanished (project menu, properties)?

How do you get them back?

View 3 Replies View Related

Image Properties

Jun 26, 2007

Hello



Im having abit off trouble with my images positioning..



I have 3 images in the header placed side by side with a rectangle around them sent to the back

In layout view the images look correct, however when i deploy the report the rectangle appears on top and then the images appear undernealth each other...when they should be inside the rectangle. is there something like float on top properties similar to objects in Word?



A separate question, I also have a table to the right off the table i have an image and under that image another image...when i preview the report the second image is pushed to the bottom of where the table ends...is there someway to make the image appear side by side to the table instead off getting pushed down to the bottom...something similar to a frame in HTML ?



thanks







View 3 Replies View Related

Database Properties

May 9, 2007



Hi.



I am trying to look for ways on how to get all the databse properties under each instance.

say I want to view the size, recovery model, physical location, etc.



The sys.database_files is only applicable per database. Is there a query, or a table in master database to get these or store these values?





thanks...

View 3 Replies View Related

Extended Properties

Jul 11, 2007

Hi:



Does anyone know of a good primer on extended properties and why I would want to use them. I have you the on-line books sections but that does a clear "why". I have search for white papers and similar documents.



I understand they are good for documentation, but I was looking for something that explain Microsoft long-term vision. How I might use them in template scripts, VSTS, etc.



Thanks in advance for your help.



Gene

View 1 Replies View Related

Set C# Parameter Properties

Jul 26, 2006

Hi all, Is it possible when creating a stored procedure through visual studio using a sql server 2005 project, to set the sizes of the parameters that are specified. For example:

public partial class test{ [Microsoft.SqlServer.Server.SqlProcedure] public static void addRecord(string name, string details) { ................. some code ................. }}
Would it be possible to set the size of the parameter 'details' to nvarchar(max) and 'name' to nvarchar(50) or something along those lines. The problem at the moment is that when this project is deployed both of the parameters are set to 4000 characters and sometimes the details parameter are greater than 4000 characters and it is being truncated.

I am currently running some sql that alters the procedure to set the sizes of the parameters but this isn't really an ideal solution.

Any help would be gratefully appreciated.
N


View 5 Replies View Related

Database Properties

Mar 4, 2008

I am trying to find information on Database properties - more specifically, what the 'Space Available' means, because right now when I look at the properties of a database I am setting up, which will grow substantially I am sure, it says the database size is 154 MB and the Space Available is 42 MB. What is the Space Available? What does this refer to and is it going to be restricting the growth of the database? Thanks.

View 7 Replies View Related

Set Chart Properties

May 12, 2008

Hi,

I have a chart that is created in SSRS with the size property set to '15cm, 8.5cm', I want to set the height based on a parameter that is passed to the chart ( so that it fits onto a 1 page report it is fed through to), I have tried putting =Code.SetChartHeight() in the height property but it brings up an error saying it needs to be in a format like '8.5cm'. The SetChartHeight() function just returns the height parameter + 5.

Does anyone know how I can do this?

Many thanks in advance

View 4 Replies View Related

How To Use Query To Get Sql Database Properties

Oct 2, 2006

Hi,I'm creating a User Interface to display Sql database Properties, but I cannot find the right query to retrieved the info on database properties. The status that I get is "ONLINE", but it should be "NORMAL". Cannot find the right query to get the date of last database backup, last transaction log backup, and maintenance plan, etc.. Please help me [:'(]  

View 2 Replies View Related

Where Are The SQL Server 7.0 Configuration Properties

Mar 22, 2000

Is there no longer a graphic interface for the parameters that are output with sp_configure?
There are many options that are settable that are not in the Sql Server Propreties, but
these items were in the 6.5 graphic interface through EM ex. number of open objects.
Is there a script to save these settings so the installation can be recreated?

View 1 Replies View Related

Changing Properties In A DTS Package

Sep 26, 2000

Is it possible to change the database name defined in the destinatation table definition of the transformation object programmitacally?

We have different database names between dev and prod. The package was created against dev. I'm trying to copy the package to the prod server and programmatically change the database name where necessary.

View 4 Replies View Related

Help !!! - DTS Package - Advanced Properties

Feb 27, 2001

Has anybody used the "Use fast load" or "Table lock" options in the advanced DTS package properties ? These are supposed to be in the Advanced tab of the Data Transformation Properties dialog box. I cannot seen to find them. I want to set them in order to have the load execute in nonlogged mode. Any help would be very much appreciated.

Thanks in advance.

View 2 Replies View Related







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