duh...format 121 does exactly what you need, sorry i misread:

FormattedDate Code...

just use a combination of two built in CONVERT formats:

SELECT CONVERT(VARCHAR,@date,112) + ' ' + CONVERT(VARCHAR,@date,114)

--results: 20090407 20:58:00:280

nuts with over 100 posts, you know you should post the schema and data in a format everyone can use to help!

a wag of my finger at you!

CREATE TABLE...

i typically use this cursor to do the same thing...besides autoclose, i don't need to have the recovery at FULL on my developer machine:

USE MASTER

declare

@isql varchar(2000),

@dbname varchar(64)

declare c1 cursor for...

something like

SELECT * From YOURTABLE

WHERE FIELDNAME LIKE '%' + CHAR(10) + CHAR(13)+ '%'--vbCrLf

how about his:

exec sp_MSForEachdb 'SELECT ''?'' as DBName, ?.dbo.sysobjects.name AS TableName from ?.dbo.sysobjects WHERE ?.dbo.sysobjects.xtype=''U'''

I've got an upcoming article on how to do this in TSQL, with a complete solution:

all objects in dependancy order, along with the data.

while you are waiting for the article...

oops bad info removed. I'll read up and come back.

i had to google this, because i didn't know either;

http://lists.mysql.com/mysql/187971

you can find out your current setting with this comand

SHOW VARIABLES LIKE 'max_allowed_packet';

+--------------------+---------+

¦ Variable_name......¦ Value...¦

+--------------------+---------+

¦ max_allowed_packet ¦...

i think you could use something like this

select CASE

WHEN datepart(week,getdate()) %2 = 0

...

I completely overlooked point in time restores, tuning, development, etc., some of the many things we do outside of backups.

george is spot on; getting a point in time restore...

Marios Philippopoulos (4/6/2009)

---

With the advent of third-party enterprise-level backup solutions, such as Symantec or CommVault, how justifiable is it to maintain that DBAs should still be the owners of the...

sounds like gift Peddie's comments might be right then: upgrading a service pack to get the MDAC and drivers updated;

dunno if it makes a difference, but in my shop we...

i do it very similarly, Vijaya Kadiyala;

i always use a staging table, because once it's in a table, it's so easy to analyze...

BULK INSERT or bcp can be your friend...

we don't know...it could be something in your code...maybe you have ignore_dups in your import?

if it's from an application,say from the client-server or web and a session times out....starting a...