DB Engine :: What Are ACID Properties

Jun 19, 2015

I want to understand ACID properties through sql queries.

I have seen real world example everywhere but if I want to test it then how do I use sql queries to understand practically on my PC?

[URL]

View 15 Replies


ADVERTISEMENT

Practical Use Of ACID Property

Apr 2, 2008

Can anyone tell me the practical use of ACID properties. I know theory available in books. But where it will implement practically I am confused.

View 8 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

Best Way To View Table Properties

Apr 28, 2003

Can anyone help me with displaying several table properites at once. I know I can use sp_help 'tablename' to get one at time. What is the best method to get several databases at a time?

View 5 Replies View Related

How To Use The Dynamic Properties DTS Task

Jan 10, 2005

Hi,

I recently came across a DTS made by an experienced DBA and was impressed by the use of Dynamic Properties DTS Task used. As I understood the DTS was generic and if I'm not mistaken, can be easily transferred to another server/machine on an AS IS basis and without having to change any of the properties (server name, login, password etc.) for the source or destination server.

This seems to be a really neat feature.

I tried to put this to use but am having problems regarding how to proceed... Unfortunately I have not been able to find any article either which addresses this particular request and takes a novice step by step so that this feature can be used.

Will appreciate any help.

Thanks

View 3 Replies View Related

How Check Database Properties?

Nov 19, 2004

Hello, Everyone:

There are some databases in a SQL Server. How to check,
1. User database numbers
2. Backup plan
3. Configuration
4. User database size
5. Nightly process

Thanks a lot

ZYT

View 1 Replies View Related

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 View Related

Database Properties Query

May 17, 2007

I've been asked to provide some information about databases on an sql server.

I can use the following query to provide the names of all the databases:

select * from master.dbo.sysdatabases

What I'm also looking to provide is the current "size" of the database. I'm trying to find a table that I can link to that would provide the database size. I can manually find this number by right clicking on the database from enterprise manager, selecting "properties" and picking it up from the general tab.

This is sql server 2K...

Thanks.

View 2 Replies View Related

Table Properties In SSMSE

Apr 18, 2008

Hello. I just started using SQL Server Management Studio Express. I am creating a new table by right-clicking the "Tables" folder and selecting "New Table". Then i hit F4 to bring up the "Properties" (because I want to associate a Schema to the table, but when the "Properties" section appears, it's blank. I can't figure out a way to get anything to appear there. Any ideas? Thanks!...

View 2 Replies View Related

Some SQL Server Network Properties

Jun 19, 2008

DECLARE@Stage TABLE
(
RowID INT IDENTITY(0, 1) PRIMARY KEY CLUSTERED,
Data VARCHAR(90),
Section INT
)

INSERT@Stage
(
Data
)
EXECxp_cmdshell 'ipconfig /all'

DECLARE@Section INT

SET@Section = 0

UPDATE@Stage
SET@Section = Section =CASE
WHEN ASCII(LEFT(Data, 1)) > 32 THEN @Section + 1
ELSE @Section
END

SELECTMAX(CASE WHEN x.minRowID IS NULL THEN NULL ELSE s.Data END) AS Header,
MAX(CASE WHEN s.Data LIKE '%Host Name%' THEN RTRIM(SUBSTRING(s.Data, 45, 90)) END) AS HostName,
MAX(CASE WHEN s.Data LIKE '%Media State%' THEN RTRIM(SUBSTRING(s.Data, 45, 90)) END) AS MediaState,
MAX(CASE WHEN s.Data LIKE '%Description%' THEN RTRIM(SUBSTRING(s.Data, 45, 90)) END) AS [Description],
MAX(CASE WHEN s.Data LIKE '%IP Address%' THEN RTRIM(SUBSTRING(s.Data, 45, 90)) END) AS IPaddress,
MAX(CASE WHEN s.Data LIKE '%Physical Address%' THEN RTRIM(SUBSTRING(s.Data, 45, 90)) END) AS PhysicalAddress
FROM@Stage AS s
LEFT JOIN(
SELECTMIN(RowID) AS minRowID
FROM@Stage
GROUP BYSection
) AS x ON x.minRowID = s.RowID
WHEREs.Section > 0
GROUP BYs.Section
E 12°55'05.25"
N 56°04'39.16"

View 2 Replies View Related

Description Properties In SQL 2000

Jul 15, 2001

A query to get the Table and Column Description fields in SQL Server 2000.


SELECT so.name, sc.name, sc.xtype, sc.length, sc.colid,
tableprop.value as TableDescription,
colprop.value as ColDescription

FROM

sysobjects so

INNER JOIN syscolumns sc ON sc.id = so.id
INNER JOIN sysproperties tableprop ON tableprop.id = so.id and tableprop.type = 3
INNER JOIN sysproperties colprop ON colprop.id = sc.id and colprop.type = 4
and colprop.smallid = sc.colid

WHERE so.type='u' and so.name = 'TableName'

Order by sc.ColID





Damian

View 2 Replies View Related

Db Properties-Number Of Users

Apr 9, 2007

when i see the number of users on my local connection. It says 4 and another DB says 12. But nobody is connected to these DB but me. Why is it showing 4 and 12?

View 1 Replies View Related







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