Parthi i mentioned before that while you can use CAST and CONVERT on the columns, it's best practice to stay within the same datatype by using DATE ADD/DATEDIFF functions;

when...

VNC/Remote Desktop/ TeamViewer / PCAnywhere / GoToMyPC are desktop viewers,

you don't need that.

SQL Server Management Studio is the interface of choice and is backwards compatibile, and can connect to ...

it's pretty basic:

--get just the data we need to...

ricardo_chicas (8/20/2010)

---

Ok lets do this, forget about the original problem

what I really want to know is for a suggestion on what is the best way to retrieve large amount of...

newbieuser (8/20/2010)

---

Hi friends,

I'm creating an application role, the password for the role should be read from a table. Is it possible to do this?

The table need to...

chopping stuff up with substrings not hard to do...but we need...

ouch; Steve's analysis is right on....it'll be tough to determine what changed and what should be kept, especially if competing applications used two different databases at the same time.

Lesson i...

sharp analysis drew... i would not have inferred the regional settings affecting the implicit conversion.

here's my version of the procedure, which seems to return the data with seconds:

CREATE FUNCTION [dbo].[fn_JulianDateConversion](@JulianDate...

yes, of course. sql supports two kinds of...

something like this, maybe?:

CREATE ROLE [MyNewRole]

--Select permission (assuming every object, not specific tables)

ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [MyNewRole]

--Insert update delete permission (assuming every object, not specific tables)

ALTER AUTHORIZATION ON SCHEMA::[db_datawriter]...

looks like mine is similar to yours; just different fields that i'm capturing.

here's what i see as the differences:

I'm using sp_GetDDL not sp_GetDDLa, which returns multiple rows. i am using...

i remember having to restart when i was playing around with lots of traces;

when C2 auditing is on, c2 traceid = 1, the default trace = traceid 2, and any...

i'm very sure you need to simply change the c2 audit setting, then just stop and start the server;

i've done it quite a few times, and that's all i did.

well i am not na expert in xml by any means, but i googled a bit and got this to almost work; this might give you some ideas:

--the query to...

I'd recommend the method Krishnraj suggested; this is especially true with big tables with lots of constraints or foreign keys or other dependancies....the GUI does all the grunt work behind...