The max database size is 1,048,516 TB Cubed

This information can be found in BOL under "Maximum Capacity Specifications"

-------------------------

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website...

What release of SQL Server do you have on your client machine? I don't suppose you have a newer release of SQL server on your client, then on your...

Here is one way if you have the field that contains non-numberic data in a local variable. Isn't very short. Probably is a better method.

set @string = '2000'...

Might look at either one of these if you want to remove all the white space between words down to a single space

http://www.geocities.com/sqlserverexamples/#string1

http://www.geocities.com/sqlserverexamples/#string2

-------------------------

Gregory Larsen, DBA

If you looking for SQL Server...

quote:

---

Use the REPLACE() function on the column name - arguments are: column name, string to search for, string to replace with):

declare @string...

quote:

---

Use the REPLACE() function on the column name - arguments are: column name, string to search for, string to replace with):

declare @string...

Ooops. Clicked "Post New Reply" before I typed anything. Here is what I was thinking.

1) Have you looked at the execution plan to determine where you...

quote:

---

Oops

That should read 32 1/2 million rows

---

-------------------------

Gregory Larsen, DBA

If you looking for SQL Server...

When you manually run the DTS package it run under the security context of your current SQL Server connection/client machine. When you run the job under SQL Server Agent...

Here this might give you some ideas:

Create table #email (

email varchar(100))

insert into #email values ('rrrrrr@something.com')

insert into #email values ('eeeeee@something.com')

insert into #email values ('ppppp@something.com')

insert into #email values ('llll@something.com')

insert into #email values...

Here is an example of some code for the hack Andy was talking about.....

Create proc x

@rs cursor varying output

as

set @rs = cursor for select name from sysobjects

open @rs

go

-- to...

Well now you are asking a different question.

If you have not changed the name of the server since installation of SQL Server, or used sp_addserver to change the name you...

Never could get the 'out of range' message. Here are a couple of date selection examples that might help.

CREATE TABLE #TEMP (

DATE_CLOSED_DATE CHAR(12))

INSERT INTO #TEMP VALUES ('2002-09-11')

INSERT INTO #TEMP...

Here I took your sample code, and put some other code around it as a working sample. How does this code differ from yours?

create table mytable (

id int,

name char(10),

date...

Something like this will work:

create table #tmp_t (

[Server Net Name] varchar(1024)

)

insert into #tmp_t exec('master.dbo.xp_getnetname')

declare @netname varchar(1024)

select @netname = [Server Net Name] from #tmp_t

print @netname

drop table #tmp_t

-------------------------

Gregory Larsen, DBA

If...