anoop.mig29 (12/11/2013)

---

Hi friends

At one of our client side we are not abled to get logged in sql server through windows login and we donot have sa pwd or any...

this generates the basics of what you are asking; you'll need to further filter on the datatype of the columns(text,image,bit, others?); the first version i tested returned an error for...

didn't notice this was for SQL2005, so the TIME datatype is out, but the other two converts i posted will work.

Dave i think the easiest is cast your datetime as TIME datatype, but here's a quick example of the three i could think of:

/*

create_date ...

darth.pathos 62444 (12/13/2013)

---

Thanks Lowell, I'll have to review this a little more closely after I'm out of my meeting, but (and this may simply be a case of my missing...

well, there is a few contributions here on SSC that does some of what you are after and much, much more:

http://www.sqlservercentral.com/search/?q=database+documentation&t=s&sort=relevance

one of the four links for "Comprehensive Database Documentation" is...

you have to rebuild all the indexes on the table, including the clustered index i believe in order to free the space to the database again.

not enough information for us to offer more than vague things to check.

performance tuning is a wide subject, and the tiny bit you gave us so far isn't enough to...

the ACE drivers are required for a SQL server 64 bit version to...

i've heard the data dictionary as being the Extended Properties comments that are potentially included in a database to describe objects/tables /columns, but only if someone has gone to...

you have to change your query to query first from a Calendar table of some sort, which contains all possible dates.

then your CTE left joins to that Calendar table.

with that...

in the procedure itself, do you have something like RETURN @MyDateValue

the return of a stored procedure only can return an integer, and it typically means success(0) or failure(non zero) ,...

since it's happening on the server itself(local machine), look at the running processes, and see if there's an additional application or scheduled task or something that is running/trying to connect...

there is some support for patterns/regular expressions in SQL

this does what you are asking, i think. one expression tests exactly ten characters, the other test the first ten characters

WITH mySampleData(val)

AS

(

SELECT...

Stan for the portion where you stick the image into a table, you can do it via a CLR function;

the CLR would look like this:

[Microsoft.SqlServer.Server.SqlFunction()]

public static SqlBytes CLR_GetFileImage(SqlString RetailerId)

{

try...