|
|
|
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 31 query to give me db sizes Posted by Hassan at 5/21/2005 3:39:17 PM Id like to have a query that gives me the all the total db data sizes such
as
DB1 100GB
DB2 25GB
...more >>
Permission to execute a job Posted by Dave at 5/21/2005 3:04:57 PM I have a stored proc that refreshes data and then does a table swap.
As part of the table swap I need to drop and create a table. This requires
basically dbo permissions.
So I create a job to run my proc and the job runs under the sa accout.
But I need an account that is not sa or dbo to ...more >>
Dynamic Where clause Posted by Kenny M. at 5/21/2005 1:53:01 PM Hi
I have an array like this: myArray(n) ,and I need to make a dynamic WHERE
clause
e.g
Where Value = myArray(0) or myArray(1)...
But the where clause can not be explicit because the length of the array is
variable
What is a professional way to do something like this?
Thks
...more >>
Help with Paging SPROC Posted by scott at 5/21/2005 12:11:21 PM I'm trying to learn from SQLMag.com's InstantDoc #40505 called "Server-Side
Paging with SQL Server "
This was a well written main feature story, however, their syntax in Listing
4 below is giving me errors. Can someone paste the below code into QA and
help me find which quotes are incorrect...more >>
"simple" security? Posted by Paul Pedersen at 5/21/2005 12:03:40 PM I've heard that SQL Server's security system is good, but complicated. What
is the easiest way to:
1. Limit who can make structural changes to the database, including stored
procedures.
2. Limit read access to certain tables or fields, and limit write access for
others.
At this poin...more >>
Subquery in an EXISTS predicate Posted by J. M. De Moor at 5/21/2005 9:01:26 AM When using EXISTS, is it generally better to use * or 1 as the selected
column in the subquery? I understand that (in SQL Server at least), using *
allows the optimizer to choose the column used in the subquery. Does that
mean that
WHERE EXISTS (SELECT * FROM ATable WHERE ...);
generally...more >>
setup to access Oracle data Posted by ykffc at 5/21/2005 5:56:02 AM Newbie one with SQL. I used to access Oracle data from within an MS Access
application, using ODBC.
How do I setup my system to access Oracle data using SQL stored procedure?
Our Oracle database server is separate from the SQL server box. Please
provide me a sample Select statement to read...more >>
Table export fails: "The server could not find DCOM" Posted by kd at 5/21/2005 3:38:03 AM Hi All,
Exporting a table fails with the following error:
"The server could not load DCOM"
Only the table is copied, the data is not exported.
How to get over this error?
Thanks
kd...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Access permission to run SQL debugger Posted by kd at 5/21/2005 12:21:06 AM Hi All,
When I try to step into the stored procedure (for debugging) in from vb.net
environment, it gives the follwoing error.
"Security hasn't been set up correctly for SQL debugging on server
<servername>. SQL Debugging terminated. See SQL Debugginh documentation on
how to set it up co...more >>
IDENTITY column Posted by Lisa Pearlson at 5/21/2005 12:00:00 AM Hi,
Do many people use the IDENTITY type for a column?
The advantage is that every time you add a row, that identity column is
automatically incremented, however, I have always wondered about the
following issues that I could try to test and find out, but my testing will
not necessarily re...more >>
Group all transaction's updates - or getting current transaction id Posted by Ido Ben at 5/21/2005 12:00:00 AM Hi all,
I need to find a mechanism to put triggers on tables, and when an update
takes place - group all updates which happened in the same transaction
togheter. (Thanks, nr...)
For example: Let's say i have 3 tables : Hotel, RoomType and seasson.
Now, let's say that i'm invoking a series o...more >>
Syntax Help Posted by The Gekkster via SQLMonster.com at 5/21/2005 12:00:00 AM Hi all,
My crash course in T-SQL has just passed 60 hours this week (so far), and
right now I'm drawing a complete blank (definite brain overload)on the
correct syntax to put an example such as this into a similarly functioning
update that will hit all appropriate rows:
DECLARE @M varch...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |