|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 INFORMATION_SCHEMA indexes Posted by Jay at 9/30/2007 8:44:15 PM 2000
Is index information stored in INFORMATION_SCHEMA? Thought it was, but I
can't see it anywhere and BOL sucks on this one.
If not, how can I tell if an entry in sysindexes is an index or there to
support a constraint for a table. The only way I can think of is: si.name is
not in sysc...more >>
Adding a wildcard to a stored proc parameter Posted by shmeian at 9/30/2007 6:18:00 PM Hi there,
I have a simple problem but I can't solve it.
I'm using the CONTAINS predicate to find names in a column called LAST_NAME.
eg:
SELECT bladebla FROM table bla
WHERE CONTAINS( [LAST_NAME], @nameparam)
But what I really want to do is something like this:
WHERE CONTAINS( [LAST_NAM...more >>
Automating a Stored Procedure Posted by Cindy Mikeworth at 9/30/2007 5:07:37 PM I needed a complex view of data to be created, and ended up hiring a
contract company. They created a stored procedure that I can run from
within SQL Server Management Studio (SQL 2005), that populates a temp table.
My challenge is that my users do not have access to SQL, nor do they have
t...more >>
Get Login and Password for first time after install... Posted by trint at 9/30/2007 4:42:56 PM I know this isn't very bright:
I just installed SQL Server 2005 Enterprise on one of our servers.
I don't remember ever being asked what my login and password would
be for the SQL Server Management Studio (I haven't transfered or
created
any databases yet on this new installation).
How can I f...more >>
Transparent Data Encryption Posted by Mike C# at 9/30/2007 4:00:37 PM Anyone know where the steps to turn on Transparent Data Encryption are
located? They don't appear to be in BOL, and I've googled the heck out of
it. I have found about 10 billion blogs that all say "SQL 2008 will feature
Transparent Data Encryption!" No one seems to want to tell how to turn...more >>
monitor anny data change with trigger on Table and database level Posted by Michel Posseth [MCP] at 9/30/2007 2:41:01 AM hello ,
actually these are 2 questions
system = SQL 2005
1. how can i write a mechanism that writes a value to a database when a
change is detected on a monitored database ( value written, deleted ,
updated to anny table in this database )
And
2. how can i do the same thing...more >>
SQL automation Posted by Andy at 9/30/2007 1:51:35 AM Hi,
is it possible to automate SQL Server 2005,
I'd like to open query builder from the c++ code.
thanks
...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |