Viewing 15 posts - 556 through 570 (of 1,478 total)
As far as I know the serve doesn't store this information. You could have a trigger on LOGON, that will writes the login name, date and database name...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2010 at 12:50 am
Can you please write a small script that creates the table with the columns and insert few records into it and then show the requested results? I think that...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2010 at 12:33 am
You didn't specify how get the parts but in your example it was the first written name until the first space. If this is the criteria that you need,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 9, 2010 at 12:22 am
As you’ve just found out, openrowset function doesn’t accept variables as a parameter. This behavior is documented in BOL (Books on line). You could modify your code to...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 8, 2010 at 12:51 am
Here is one way:
SELECT schema_name(so.schema_id) as SchemaName, object_name(so.object_id) as ObjectName,
c.name, c.collation_name
FROM sys.columns c inner join sys.objects so on c.object_id = so.object_id
WHERE so.type = 'U' and collation_name is not null
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 7, 2010 at 9:54 am
You can right click on any place on the query pane. In the popup menu click on “connection..”, and then select “change connection…”.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 7, 2010 at 9:48 am
You already have one - Model database. Any new database is created according to the model DB. If you'll create some user defined objects on the model database,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 7, 2010 at 8:54 am
Can you explain what are you trying to find, how are you trying to find it and what is the results of your attempts? Based on the information that...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 2, 2010 at 1:11 am
You can query the relevant dynamic management views – sys.partitions, sys.partitition_functions and sys.partition_schemas.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 2, 2010 at 12:49 am
O.K, now I have to ask it – what was the font’s size:-)? To answer your question, I’ve got some big ugly SQL Statements in the past, but not...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 30, 2010 at 7:29 am
I know that you can use format file to specify which columns should be inserted (you can read about it in BOL or Google). I think (but I didn’t...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 30, 2010 at 6:39 am
I didn’t check your code. Instead here is a demonstration of how to get all the characters in one select statement (you can use it later on in insert-select...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 16, 2010 at 9:07 am
CirquedeSQLeil (8/13/2010)
I actually remember this one. Thanks for the question. Would you believe that there are still some installs of 6.5 out there in the world?
5 years ago...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 16, 2010 at 12:42 am
I’ve noticed that there is no group by, so I selected the answer with the syntax error. Seems that I was wrong and I lost 3 points....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 12, 2010 at 7:37 am
niall.baird (7/7/2010)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 8, 2010 at 3:27 am
Viewing 15 posts - 556 through 570 (of 1,478 total)