Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Sql Standard Varchar Size


i know ms sql allows varchar to reach a size of 8000. i've also read that oracle allows for 4000, though i've never used it and not sure about that. so my question is what is the sql standard for a varchar size?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Size To Specify For Varchar(Max) Field
After reading Dan Guzman's blog entry (http://weblogs.sqlteam.com/dang/archive/2008/02/21/Dont-Bloat-Proc-Cache-with-Parameters.aspx) I started modifying some of my code to try it out and ran into a stumbling block. What size would you specific for a varchar(MAX) field?
Since a varchar max field can hold up to 2 billion chracters I really don't think I need to specify 2 billion as the size. Anyone have any ideas?
 

View Replies !   View Related
VarChar Size Concerns
Is a near-empty VarChar 8000 any less space-efficient than a near-empty VarChar 100?

We're creating note fields that are usually near-empty, but could grow larger on occasion. We'd like to know for sure whether the only difference between a small and large VarChar is simply the maximum length allowed.

View Replies !   View Related
How Can I Increase The Size Of Varchar
Dearfriends,
please guide me,
i've a column with varchar(100).
presently, i need that column as varchar(500).



thank you very much.

Vinod

View Replies !   View Related
SQL Server 2000 Standard .. DB Size Limit
Hi all.

On the MS website (at this URL: http://www.microsoft.com/sql/evaluation/overview/default.asp) it says that the Standard edition of SQL Server 2000 has a database size limit of 1,048,516 terabytes.

Talking to a friend, he tells me this is not true, and that it has a database size limit of 12gb.

Is Microsofts site incorrect, or is my friend lost?

Cheers! :-)

View Replies !   View Related
7.0 Standard Desktop Database Size Limitation?
I am running 7.0 standard desktop on Workstation 4.0 and have run into a database size limitation of 10GB. I have all the newest
patches and have found no documentation that refers to a 10GB limitation. A September copy of VBA developer says that this edition
has a limitation of 4GB while the guides say that the Small Business Server edition would have a 10GB limitation. All other forms
of documentation say that there should be the standard mega-terabyte limit. I'm completely confused by this [lack of] documentation.
Any help???

View Replies !   View Related
Question Regarding Size Of Varchar Field
Hi,I am using MSDE together with Enterprise Manager.I have a table with a field named description.This field will be filled by a web forms's textbox web control.The textbox's maxsize attribute is set to "3000" characters.What size do I have to adjust for my DB field description?Is the size of 3000 in Enterpise Manager equal to 3000 characters for the textbox?I am just trying to avoid errors if MSDE cuts off the string that comes from the textbox webcontrol.

View Replies !   View Related
Changing The Size Of A Varchar Field
We have a small table of about 13 million rows that needs altered. A column in the table needs to be changed from a varchar(20) to a varchar(500). When we ran the alter table script, 3 hrs later and it wasn't done running. Any suggestions on what we can do to speed up the process?


Thanks ahead of time
DMW


Edit:
We are running SQL Server 2000 and the db at the time was running in simple mood

View Replies !   View Related
Question On Size Restriction For Sql Express And Sql 2005 Standard
If i create a database in SqlEX and then move it to a sever running Sql 2005 standard, am Is my database still limited to the 4GB size?
 
 

View Replies !   View Related
Buffer Size Of Varchar In SQL Server 2000
 

Hi all
 
I am Importing data from CSV to Table using DTS package it showing error "exceeded Buffer size",
What is Buffer size of varchar in SQL Server2000
 
 
Appreciated your help
 
 

View Replies !   View Related
Help! Limitations On Varchar Size And Not Being Able To Use TEXT In Stored Procedure
I am stuck! and need help!

I have a problem I can't seem to find the solution with this aweful limitations on VARCHAR fields of 255.

Within a stored procedure called Store_Check, I need to dynamically build a string (@string) using VARCHAR(255) since the text datatype can't be used in a stored procedure.

So,this string is built according to whether the Store ID is NOT NULL. So if the StoreID is not null, I start building this string 'Exec Update_Store_Address @StoreID1, @address2'. There are 20 StoreID's passed into Store_Check. IF all 20 StoreID's are not NULL, the executed String greatly exceeds 255 because the string winds up looking like this

'Exec Update_Store_Address @StoreID1, @address1 Exec Update_Store_Address @StoreID2, @address2 Exec Update_Store_Address @StoreID3, @address3 Exec Update_Store_Address @StoreID4, @address4 Exec Update_Store_Address @StoreID5, @address5 Exec Update_Store_Address @StoreID6, @address6 etc. etc.'

I am not executing this string within the StoredCheck procedure. It needs to be passed as ONE string to a VB program and it gets executed by the VB program. Even if I create 4 local variables and concatenate them, it stops at the 255th character.

Also, a local varialbe of type TEXT cannot be declared within stored procedure.

What can I do? I am stuck!
Angel

View Replies !   View Related
SQL 2005 Resize Initial Log Size: MODIFY FILE Failed. Specified Size Is Less Than Current Size.
 
I am trying to resize a database initial log file from 500M to 2M. I€™m using€?

ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "

 

And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.

 

Any help with this process?

View Replies !   View Related
Compare Standard Evalulation To Standard License Version
Hi All,

 

Good Evening.

 

I need a comparision between Evaluation copy and Standard license version of SQL Server 2005 /SSIS.

 

I'm assigned a task to evaluate SSIS and migrate a project to SSIS.

 

I have downloaded SSIS evaluation version and started working on that.

 

Now i'm being posed questions for the complete functionality of the tool...

 

- Whether it has a Bulk load trasformation ?

- Whether the evaluation version contain all the features of a standard license version ?

 

I need to submit a consolidated report for SSIS in comparision to the current ETL tool features.

 

Can you please let me is there any considerable features not given with a evaluation copy ?

 

Thanks in advance,

Suresh N

View Replies !   View Related
Problems Moving Data Over 8000k In DB2 Varchar Column Into SQL Server Varchar(max) Using SSIS
 

I have looked far and wide and have not found anything that works to allow me to resolve this issue.
 
I am moving data from DB2 using the MS OLEDB Provider for DB2.  The OLEDB source sees the column of data as DT_TEXT.  I setup a destination to SQL Server 2005 and everything looks good until I try and run the package.
 
I get the error:
[OLE DB Source [277]] Error: An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available.  Source: "Microsoft DB2 OLE DB Provider"  Hresult: 0x80040E21  Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
 
[OLE DB Source [277]] Error: Failed to retrieve long data for column "LIST_DATA_RCVD".
 
[OLE DB Source [277]] Error: There was an error with output column "LIST_DATA_RCVD" (324) on output "OLE DB Source Output" (287). The column status returned was: "DBSTATUS_UNAVAILABLE".
 
[OLE DB Source [277]] Error: The "output column "LIST_DATA_RCVD" (324)" failed because error code 0xC0209071 occurred, and the error row disposition on "output column "LIST_DATA_RCVD" (324)" specifies failure on error. An error occurred on the specified object of the specified component.
 
[DTS.Pipeline] Error: The PrimeOutput method on component "OLE DB Source" (277) returned error code 0xC0209029.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
 
Any suggestions on how I can get the large string data in the varchar column in DB2 into the varchar(max) column in SQL Server 2005?
 
 

View Replies !   View Related
The Data Types Varchar And Varchar Are Incompatible In The Modulo Operator
I am trying to create a store procedure inside of SQL Management Studio console and I kept getting errors. Here's my store procedure.
 



Code Block
CREATE PROCEDURE [dbo].[sqlOutlookSearch]
-- Add the parameters for the stored procedure here
@OLIssueID int = NULL,
@searchString varchar(1000) = NULL
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
IF @OLIssueID <> 11111
SELECT * FROM [OLissue], [Outlook]
WHERE [OLissue].[issueID] = @OLIssueID AND [OLissue].[issueID] = [Outlook].[issueID] AND [Outlook].[contents] LIKE + ''%'' + @searchString + ''%''
ELSE
SELECT * FROM [Outlook]
WHERE [Outlook].[contents] LIKE + ''%'' + @searchString + ''%''
END
 
 
 

And the error I kept getting is:

Msg 402, Level 16, State 1, Procedure sqlOutlookSearch, Line 18

The data types varchar and varchar are incompatible in the modulo operator.

Msg 402, Level 16, State 1, Procedure sqlOutlookSearch, Line 21

The data types varchar and varchar are incompatible in the modulo operator.
 
Any help is appreciated.
 

View Replies !   View Related
Any Easy Way To Change Column Length Like Varchar 30 To Varchar 100?
I would like to increase the length of the column fromLOCNumber VARCHAR(30) DEFAULT ''toLOCNumber VARCHAR(100) DEFAULT ''without losing any data currently stored in the field.And it has an index on it defined asCREATE INDEX LOCIndex ON BookData(LOCNumber)Thanks for any help.

View Replies !   View Related
SSIS - Importing Varchar From Access Into SQL2005 As Varchar
For the life of me I cannot figure out why SSIS will not convert varchar data.  instead of using the table to table method, I wrote a SQL query so that I could transform the datatype ntext to varchar 512 understanding that natively MS is going towards all Unicode applications. 

The source fields from Access are int, int, int and varchar(512).  The same is true of the destination within SQL Server 2005.  the field 'Answer' is the varchar field in question....

 

I get the following error

 

Validating (Error)



Messages

Error 0xc02020f6: Data Flow Task: Column "Answer" cannot convert between unicode and non-unicode string data types.
(SQL Server Import and Export Wizard)


Error 0xc004706b: Data Flow Task: "component "Destination - Query" (28)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)


Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)


Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)


DTS used to be a very strong tool but a simple import such as this is causing me extreme grief and wondering of SQL2005 is ready for primetime.  FYI SP1 is installed.  I am running this from a workstation and not on the server if that makes a difference...

Any help would be appreciated.

 

 

 

View Replies !   View Related
Datatype Question Varchar(max), Varchar(250), Or Char(250)
 

I have a table that contains a lot of demographic information. The data is usually small (<20 chars) but ocassionally needs to handle large values (250 chars).  Right now its set up for varchar(max) and I don't think I want to do this. 
 
How does varchar(max) store info differently from varchar(250)?  Either way doesn't it have to hold the container information?  So the word "Crackers" have 8 characters to it and information sayings its 8 characters long in both cases. This meaning its taking up same amount of space?
 
Also my concern will be running queries off of it, does a varchar(max) choke up queries because the fields cannot be properly analyzed? Is varchar(250) any better?
 
Should I just go with char(250) and watch my db size explode?
 
Usually the data that is 250 characters contain a lot of blank space that is removed using a SPROC so its not usually 250 characters for long.
 
Any insight to this would be appreciated.

View Replies !   View Related
How Do SQL 2000 Service Packs Play A Role In Upgrading?i.e.Can SQL 2000 Standard With No SP Be Upgraded To SQL 2005 Standard
How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack??

View Replies !   View Related
Sql 2005 Install Error. MODIFY FILE Failed. Specified Size Is Less Than Current Size.
I installed sql 2005 a while back. Then I recently found out my file system was fat32 (I don't understand why the hardware people did this...) and I had to convert to NTFS. Naturally the sql service no longer worked so I uninstalled inorder to reinstall now I can't reinstall it I keep getting this message

 

native_error=5039, msg=[Microsoft][SQL Native Client][SQL Server]MODIFY FILE failed. Specified size is less than current size.


I'll try to post the full log in a new post.

 

 

View Replies !   View Related
Error - Output Param - SP - Size Property Has An Invalid Size Of 0
Using C#, SQL Server 2005, ASP.NET 2, in a web app, I've tried removing the size from parameters of type NCHAR, NVARCHAR, and VARCHAR.  I'd rather just send a string and let the size of the parameter in the SP truncate any extra chars if need be. I began getting the error below, and eventually realized it happened only with output parameters, as in the code snippet below.String[3]: the Size property has an invalid size of 0.   par = new SqlParameter("@BusinessEntity", SqlDbType.NVarChar);  par.Direction = ParameterDirection.Output;  cmd.Parameters.Add(par);  cmd.ExecuteNonQuery();What's the logic behind this? Is there any way around it other than either finding out what the size should be, or assigning a size larger than would ever be needed? ThanksMike Thomas 

View Replies !   View Related
SPROC Problem - String[1]: The Size Property Has An Invalid Size Of 0.
Hi folks,Can anyone enlighten me here? I'm trying to use a SPROC which, when supplied with an int, looks up the table and returns certain columns from it. I'm using a SqlCommand, here's my codebehind: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SqlCommand dataSource = new SqlCommand("retrieveData", new SqlConnection(dbConnString));        dataSource .CommandType = CommandType.StoredProcedure;        dataSource .Parameters.AddWithValue("id", poid);        dataSource .Parameters.AddWithValue("title", title).Direction = ParameterDirection.Output;        dataSource .Parameters.AddWithValue("creator", creator).Direction = ParameterDirection.Output;        dataSource .Parameters.AddWithValue("assignee", assignee).Direction = ParameterDirection.Output; etc, etc... And the SPROC:------------------------------------------------------------------------------------------------------------------set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[retrieveData]    @id int,    @title varchar(50) OUTPUT,    @creator varchar(50) OUTPUT,    @assignee varchar(50) OUTPUT,    @contact varchar(50) OUTPUT,    @deliveryCost numeric(18,2) OUTPUT,    @totalCost numeric(18,2) OUTPUT,    @status tinyint OUTPUT,    @project smallint OUTPUT,    @supplier smallint OUTPUT,    @creationDateTime datetime OUTPUT,    @amendedDateTime datetime OUTPUT,    @locked bit OUTPUT        AS    /**SET NOCOUNT ON;    **/    SELECT    [title] AS [@title], [datetime] AS [@creationDateTime], [creator] AS [@creator], [assignee] as [@assignee],    [supplier] as [@supplier], [contact] AS [@contact], [delivery_cost] AS [@deliveryCost], [total_cost] AS [@totalCost],    [amended_timestamp] AS [@amendedDateTime], [locked] AS [@locked]    FROM purchase_orders    WHERE [id] = @id; ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  The id being passed in is definately not null, and is set to a value of an item I know exists. The resulting error is:

Exception Details: System.InvalidOperationException: String[1]: the Size property has an invalid size of 0.Line 63: retrievePODetails.Connection.Open();Line 64: retrievePODetails.ExecuteNonQuery();[InvalidOperationException: String[1]: the Size property has an invalid size of 0.] System.Data.SqlClient.SqlParameter.Validate(Int32 index) +717091... ... Can anyone see anything I'm missing? Thanks,Ally   

View Replies !   View Related
Reduce The File Size Less Then Original Size In SQL 2000
I have one db test with one .mdf and .ldf file...mdf file size is 100mb and for some reson i removed all the tablesfrom that .mdf file and transfer it into new secondary file so all thetables moved into secondary file now i want to reduce the first .mdffile from 100 mb to 50mb is that possible,it's showing 90mb is free.Please reply

View Replies !   View Related
Optimal RAID Stripe Size And OS Cluster Size?
I need to setup HP NetServer, which will run mainly SQL 7
on Win2K (it'll also run an aplication server, which would
connect to SQL but it wouldn't take too much resources).
The server has 3 ULTRA3 SCSI 18GB, 10.000rpm hard drives
connected to HP NetRAID-1M Controller. To provide some
redundancy I basicaly have just one choice: RAID5.

But what would be the optimal RAID stripe size and Windows
cluster size to provide the best performance for SQL
Server? Controller support stripe sizes from 2KB up to
128KB.

So far I expect to set 64KB stripe size and have a couple
partitions:

- one, with 4KB cluster size, for OS, SQL binaries, logs
and all other program and auxiliary fiiles,
- another one, with 64KB cluster size, for SQL databases
and transaction logs.

Is it the best possible disk configuration considering
available hardware?

Thank you for any comments/suggestions.

Victor

View Replies !   View Related
Encrypted Data Size By Original Size, Algorithm ?
I want to know encrypted data's size for designing database field size.

For example, cardnumber varchar(20)  Encrypted by Triple_DES and PassPhrase, How match size does need to encrypted data store field.

I think the size does not depend to PassPhrase char length.

Regards,
Yoshihiro Kawabata

View Replies !   View Related
String[18]: The Size Property Has An Invalid Size Of 0
I am getting error to run stored procedure using executenonquery method. The Stored Procedure is having OUTPUT parameter.
ExecuteNonQuery statement is called using SqlHelper.
Error : String[18]: the Size property has an invalid size of 0

View Replies !   View Related
Best Practice For Data Size/Log Size Ratio
Just wanted to know what is a general rule of thumb when determining log file space against a database's data file.We allow our data file for our database to grow 10%, unlimited. We do not allow our log file to autogrow due to a specific and poorly written process (which we are in a three month process of remove) that can balloon the log file size.Should it be 10% of the Data file, i.e. if the Date file size is 800MB the log file should be 8MB?I realize there are a myraid of factors that go against file size but a general starting point would be nice.ThanksJeff--Message posted via http://www.sqlmonster.com

View Replies !   View Related
Estimating Data Size And Log Size In A Database
Question 1:
I wonder if anyone could help me on estimating the acutal data size and its log size for MS-SQL Server version 7. I know that on-line book specifies the procedure of the data size but I have some data items with attribute of data type as "Text".
In order to include the data type "Text" how many bytes of overhead and fill factor to be considered for data size calculations?

Question 2:
Also, I want to know that if anyone can help me with log size calculation for a table. It's just not good enough if the on-line book says to take from 25 to 50 % or something....it is too vague and I can not take the answer.

Here are the example of the table and if anyone can include the answers to the questions above. It will be great.

(Example:)
Can anyone help me to figure out the data and log size respectively based on the conditions below:
----------------------------------------------
1. Table Name: A_TBL
2. Table Format:
Item Data Type Length
--------------------------------------------------------
EmployeeNumber Char 20
EmployeeName Char 50
EmployeeURL TEXT 16 -----pointing---> 256
EmployeeMemo TEXT 16 -----pointing--->1000
EmployeeTitleNo Int 4

3. DB(Table) access frequency per transaction:
Insert = 1 time/transaction
Update= 2 times/tranaction
Select = 6 times/tranaction

4. Transaction occurred: 10 times, therefore; 10 INSERT, 20 UPDATE, 60 SELECT statements are issued.
(I guess 60 SELECT statements are not subject to be in the log so forget the SELECT statement)

5. Fill Factor 100 for all the data type.

6. Non-Clustered index is set for the above.

I really want to know about it, please help me on this.


Regards,

View Replies !   View Related
Difference VarChar(50) And VarChar(500)
 
Hey,

I was doing some research on how SQL stores data on disk.
MSDN states that when storring a varchar, only the length of the data itself is used plus two bytes.
So, if you store "car" in a VarChar(50) it will take 5 bytes.
But when you store "car" in a VarChar(500) it will also take 5 bytes.

What is the reason users should define the parameter lenght?
Can you use VarChar(8000) whole the time, without any drawback?

 
Thanks

View Replies !   View Related
Sql 2005 Upgrade Sql Standard 2005 To 2005 Standard Sp2 (using A Command Prompt)
First of all I am planning to install sql 2005 standard and sql standard sp2
on vista ultimate professional using vs 2008 pro
I have some questions about installing sql 2005 what is the best way to install sql 2005 on
vista My article  I got this from ms 403393 (upgrading sql standard 2005 to sql standard  2005sp2) 
1 sql standard .(shortcut right click  from cd/dvd not possible)  I have heard  command prompt  start menu, click cmd    
type run D: cd/dvd      exe     
From a wizard (sql sp2)  

2. sql standard sp2
a. upgrade using a wizard
b. open a command prompt (not sure if right click is best option)
install dvd media example dqlserver2005sp2-kb921896-exe SKUUPGRADE=1(is run as administrator option on media)
do I type run or what do I type ?
c.   go to system configuration page(where is this) you should see a single warnining you need to install
    sp2, the edition should say success if it does not please reapply
d. on the registration page please enter your registeration number
e. on the comments to install please enter database services, reporting services
    workstation components, books online and development tools( I wish to install
   all components)   

f. on the instance page click default  instance(default install)
g. finish rest of wizard
h. apply sql sp2  

I also have of seperate question of upgrading sql from vista using a Configuring local admin account
account (configuring administration from a wizard-will this notify
me by default) I do not want my administrative priviledges elevated.
I will be using default configurations for my installations.........     
I often wish there would a nice picture examples of doing this  
Please help  

View Replies !   View Related
Size Of Backup Is Less Than Size Of Database
any of you know why the size of the database dump (prod_dump.dat) is less than the size of the database (prod)
prod size is 3000 MB ( in EM and sp_helpdb)
used is 1092 MB ( datasize - data available )
however e:dumpproddump.dat is only 1.5 GB and the backup task completes with no errors.

why the discrepancy??

View Replies !   View Related
DB Size Not The Actual Physical Size
Hi,

An MSSQL DB running SAP indicates a smaller DB size (MMC & SAP) than the actual physical size. The difference is about 8 GB.

A lot of records were deleted before this. Did they remain in the DB as NULL values or something ?

Does anyone know what the reason for this could be ? And how to clean this up ?

Thanks in advance,
Paul

View Replies !   View Related
Table Size And Database Size
Hi,
i use this script that show me the size of each table and do the sum of all the table size.
 
SELECT
X.[name],
REPLACE(CONVERT(varchar, CONVERT(money, X.[rows]), 1), '.00', '') AS [rows],
REPLACE(CONVERT(varchar, CONVERT(money, X.[reserved]), 1), '.00', '') AS [reserved],
REPLACE(CONVERT(varchar, CONVERT(money, X.[data]), 1), '.00', '') AS [data],
REPLACE(CONVERT(varchar, CONVERT(money, X.[index_size]), 1), '.00', '') AS [index_size],
REPLACE(CONVERT(varchar, CONVERT(money, X.[unused]), 1), '.00', '') AS [unused]
FROM
(SELECT
CAST(object_name(id) AS varchar(50)) AS [name],
SUM(CASE WHEN indid < 2 THEN CONVERT(bigint, [rows]) END) AS [rows],
SUM(CONVERT(bigint, reserved)) * 8 AS reserved,
SUM(CONVERT(bigint, dpages)) * 8 AS data,
SUM(CONVERT(bigint, used) - CONVERT(bigint, dpages)) * 8 AS index_size,
SUM(CONVERT(bigint, reserved) - CONVERT(bigint, used)) * 8 AS unused
FROM sysindexes WITH (NOLOCK)
WHERE sysindexes.indid IN (0, 1, 255)
AND sysindexes.id > 100
AND object_name(sysindexes.id) <> 'dtproperties'
GROUP BY sysindexes.id WITH ROLLUP) AS X
ORDER BY X.[name]
 
the problem is that the sum of all tables is not the same size when i make a full database backup.
example of this is when i run this query against my database i see a sum of 111,899 KB that they are 111MB,but when
i do full backup to that database the size of this full backup is 1.5GB,why is that and where this size come from?
 
THX

View Replies !   View Related
Select Convert(varchar(16), Getdate(), 101)+LEFT(REPLACE(convert(varchar, Getdate(), 108), ':', ''),4)
 

select convert(varchar(16), getdate(), 101)+LEFT(REPLACE(convert(varchar, getdate(), 108), ':', ''),4)
 
From above query I get
 
mmddyyyyhhmm
 
but it' s yyyy and hour  can not be separated
 
04/12/200702:05
 
How can I separated the year and hour ?
 
Thanks
Daniel

View Replies !   View Related
Sql Server 2005 Standard Cd = Sql Server 2005 Standard Volumn License Cd
HI,
 
may i know the sql server 2005 standard cd  is equal sql server 2005 standard volumn license cd ?
 

View Replies !   View Related
Script To Check Free Data Size And Free Log Size In MS SQL 6.5
Dear all,

Is there any sql script to get the szie for free data space and free log space in MS SQL 6.5?

sp_spaceused and dbcc sqlperf (logspace) doesn't seem to provide the answer.

Thanks for yr help.

Rgds
Ung

View Replies !   View Related
SQL2005 Data Import Error, Unicode Data Is Odd Byte Size For Column &&<n&&>. Should Be Even Byte Size
Hi, I have a problem importing data from SQL Server 2000 'text' columns to SQL Server 2005 nvarchar(max) columns.  I get the following error when encountering a transfer of any column that matches the above.
The error is copied below,

Any help on this greatly appreciated...

ERROR : errorCode=-1071636471 description=An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Unicode data is odd byte size for column 3. Should be even byte size.". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider)


Many thanks

View Replies !   View Related
Converting Date To Varchar? And Varchar To Date?
I have a column of data in a table that has date formatted as '2006-03-26 00:00:00.000'

What T-SQL command that will alter the column so that it is now Varchar '03-26-2006'?I also want to know how to do the opposite... if I have '03-26-2006' via command, how do I convert the column of the table to be datetime from varchar

View Replies !   View Related
Sql Size Vs. Access Size
I have a SQL Server database that is showing 2853.44 mb in size but when Iexport the data into MS Access the size is less than 1 mb. Can anyone tellme how to reduce the size of my SQL Server database so that it's less than15 mb?Thanks in advance! Rob

View Replies !   View Related
Getting Database Size And Log Size
Hi,
I am using
exec sp_helpdb
go
dbcc sqlperf(logspace) for
getting database size and log size. Is this gives the correct
database size and log size or Is there any other way to get the logsize and database size by means of query analyzer.

Thanks in Advance.

Seenu. S

View Replies !   View Related
Backup Size 2x DB Size
Why is it that lately our full backup (.bak) file size is more than 2x the size of the actual database file size (.mdb)?

View Replies !   View Related
Log Backup File Size Not Matching Log File Size
I have a log file that is approximately 50 GIG.  I backed up just the log and the file size of the .bak is 192 GIG .  Why is this?  Shouldn't it be closer to the 50 GIG.
 
Normally I wouldn't let log grow this much. But we are in process of getting new server up and running and don't have backups going yet.  They are working on getting that up and running this week.
 
So I did a log backup to give me back some log space for now but was concerned when I saw the size of the .bak file.
 
When I view media contents of the backup device it shows one tranaction log back up and size of 192 GIG.
 
What is up with this. I know in SQL 2000 the log backup files where never this big. they were about the size of the log itself.
 
Any ideas?
 
Stacy
 
 

View Replies !   View Related
Data Files Size And Log Files Size
Hi!
I'm using SQL Server 2000!
How to know then Data files size and Log files size by Store Procedures or Sql query?
Thanks!

View Replies !   View Related
SQL Standard
I just want to know which SQL Standard does the SQL Server & Oracle follows?
SQL-86
SQL-89
SQL-92
SQL1999
SQL-2003



 

 





 





 
 




 

 

 

 


 

 

 

 


 











 

View Replies !   View Related
Standard Schemas?
Hi,Anyone know an online source for database schemas, or schemas for singletables i.e. where can I download a schema for an addresses table?--Richhttp://www.badangling.com -= Sea fishing badly explained =-

View Replies !   View Related
Coding In Standard SQL ?
Hi;Is there an **easy** way to tell tsql apart from standard sql?Will sqlserver run scripts written only in standard sql?What about variable definitions?Thanks in advanceSteve

View Replies !   View Related
SQL 6.5 And Standard Security
Hiya all....

I've inherited a SQL 6.5 server running on Windows NT 4.0. An application was written (I believe in VB 6.0) to access tables on the server. From the documentation that I have received, I believe that the Security mode for this server is supposed to be "Standard". When I first got my hands on the server, the security mode was set to "Integrated". I have since changed it "Standard" but the users still get the same error:

Connection failed:
SQL State" '08004'
SQL Server Error: 18450
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed. User: MCLEANC Reason: Not Defined as a valid user of a trusted SQL Server connection.

I looked in the Microsoft Knowledgebase and read an article on SQL Server Error 18450 (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q164167). I followed all of their suggestions but the server still seems to be stuck in "Integrated" mode.

Any thoughts would be greatly appreciated.

Thanks

Greg

View Replies !   View Related
Enterprise To Standard
Does anyone know if it is possible to go from the Enterprise edition of SQL, back to Standard?

In other words, Enterprise Edition is installed, but what we really want is Standard. Is there any way around this, other than uninstalling and reinstalling SQL?

I assume not, but thought I would check...

View Replies !   View Related
Standard Vs Desktop
Hi There,

Does anyone know of any differences between the Standard and Desktop Edition installations of SQL 7.0. I have noticed that dbcc sqlperf(logspace) misses some of the user databases when ran against a Desktop Edition compared to a Standard Edition installation...

Cheers,

Davy

View Replies !   View Related
SQL 2005 Standard With 5 CAL
Hi,

I currently use SQL 2005 express advanced. I connect to it from approx 20 pc's simultaneously and all works well. Each "client" connects with the same user, therefore I have one user setup within SQL server and then all client pc's connect to the database with the same user and password. This works well.

Owing to the database file size restriction of 4 gig, I now need to purchase full SQL 2005 Standard.

My question is, if I buy SQL 2005 Standard with 5 CAL (client access licences) does that mean that I can no longer connect my 20 client pc's to the server at the same time, even though I am only actually logging in with 1 user only?

Any help is greatly appreciated as I can't seem to get an answer to this question via microsoft at all, and a 20 user licence of full sql 2005 is beyond my budget.

many thanks

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved