security check
Mon, 15 Mar 2010 12:49:03 -0500
hi, how to check if my database server is accessed from internet and the
port activity like is being hacked? Please advcie. Thanks.
...
|
SQL tip
Mon, 15 Mar 2010 15:18:31 GMT
hi guys i have this table. i've tried things but i am not skilled enough to
make it to work.
date quantity
1/1/2009 1
2/1/2009 3
5/1/2009 7
9/1/2009 2
1/1/2010 4
2/1/2010 1
3/1/2010 8
and would like to have a recordset to look like this:
year jan feb mar april may jun jul ...
|
RE: User 'public' does not have permission to run DBCC TRACEON
Mon, 15 Mar 2010 07:25:41 GMT
When it crashes you get a SQL server login box up with "Options" Application name will say Microsoft Query....change that to anything else and it will work.
From http://www.developmentnow.com/g/118_2007_2_0_0_932485/User-public-does-not-have-permission-to-run-DBCC-TRACEON.htm
Posted via DevelopmentNow.com Gro ...
|
Locating Invalid rows after restoring S2K db to S2K8 (DBCC error 2
Fri, 12 Mar 2010 05:29:01 -0800
After doing a restore to migrate a SQL 2000 database to SQL 2008 we ran the
DBCC CHECKDB DATA_PURITY command which identified Invalid Rows in several
tables.
The data type of many of the identified columns was numeric(16,2), and we
have been attempting to follow the directions for locating invalid rows with ...
|
JTDS support for shared memory access
Fri, 12 Mar 2010 01:48:51 GMT
Can anyone tell me if JTDS supports shared memory access?
I would like to access the DB with TCP and Named Pipe DISABLED
Appreciate your replies. Thanks!
From http://www.developmentnow.com/g/118_0_0_0_0_0/microsoft-public-sqlserver-server.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com ...
|
how do i stop a maintenance plan?
Thu, 11 Mar 2010 09:38:28 -0500
I have a maintenance plan that runs every night. Sometimes it takes too long to run and it affects production for the
following morning. I can see and kill the process it is currently running but then the next task starts and i have to
kill that too. How can i stop the thing once it has started?
thanks
...
|
SQL database connections and access from multiple clients
Thu, 11 Mar 2010 05:18:28 -0800 (PST)
How many concurrent connections can SQL Express 2008 support ?
I have a situation where 10,000 clients need to access and update SQL
Express database.
Is it ok that all the clients directly connects to SQL express and
update the database ? What issues can come up in the scenario ?
OR is it advised that we wri ...
|
|
|
Query on multiple servers, sort by server name
Thu, 11 Mar 2010 12:35:25 +0100
Hello
I'm running a query on the sysjobhistory table on multiple servers. This
works fine, except that the results are not sorted by server name, which is
quite annoying. As the column "server name" is not part of the query, is
there a way to sort by this column ?
Pierrot
...
|
SQL 2005 attemted to read or write protected memory.
Thu, 11 Mar 2010 00:46:01 -0800
When we works on the SQL server itself with the SQL Server Manager, we
receive regular the following error message:
attemted to read or write protected memory. this is often an indication that
other memory is corrupt.
Google find the following for me, http://support.microsoft.com/kb/926421/,
but this u ...
|
sql queries
Wed, 10 Mar 2010 21:27:10 -0800
Hi Suri,
I need a help
Table: airlines_data
Table Structure:
Airlines Airport
ADAMAIR US
AERLINGUS UK
AEROFLOT US
AIRBERLIN US
I want the records in given below format
Airport ADAMAIR AERLINGUS AEROFLOT AIRBERLIN
US YES NO YES YES
UK NO ...
|
