Developer Edition allows developers to build and test any type of application with SQL Server on 32-bit, ia64, and x64 platforms. Developer Edition includes all of the functionality of Enterprise...

$55 an hour W2 or $75 an hour 1099.

this is really good stuff. thank you.

btw, this is also good for using to test a database mirror. i had to create a broken db once for testing failover. 😛

you would have to ALTER the database to remove the file. and with it being tempdb, you would have to restart the sql services.

i would leave it alone.

do you know what table in msdb holds the info on the designated CMS?

you can use Windows 2003 EE also.

2 nics are also required. 1 for heartbeat, one for local network.

the heartbeat must be on the same subnet.....

I wonder what kind of background the lead decision makers at your company have to suggest this? I too have heard rumblings of such things....(switching from SQL to MySQL)

In the...

a table or a column???

please post what your data looks like.

more than likely, Lynn is asking what is the point of your ORIGINAL question.

there are many variables to the question "Can 2 people access a table?"

the simple answer is "yes,...

declare @table varchar(128)

declare @cmd varchar(500)

declare @dbname varchar(128)

declare @RowCnt int

declare @myvalues table (dbname varchar(128), RowCnt int)

declare tables cursor for

select table_name from information_schema.tables

where table_type = 'base table'

open tables

fetch...

opc.three (4/24/2012)

---

Geoff A (4/24/2012)

---

if you have a high use server with multiple databases in full backup mode with trans logs getting backed up alot, and you do not rotate the...

if you have a high use server with multiple databases in full backup mode with trans logs getting backed up alot, and you do not rotate the logs often, reading...

SQLKnowItAll (4/24/2012)

---

Duran (4/24/2012)

---

Hello everyone,

I would like to set up some alerts on my SQL server 2008 machine, and I was wondering if there were any specific ones that would be...

Declare @test varchar(100)

select @test = 'ABCDEFG (9105) CDD ABCDEFG (1690) ENGINEERING'

select LEFT(@test,patindex('%ABCDEFG%',substring(@test,patindex('%ABCDEFG%',@test)+1,LEN(@test))))

a DBCC UPDATEUSAGE (Mydb) will probably fix those 4 errors.