| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I am using SQL Profiler to monitor one of my database.
The temporary trace file is stored under C:\Documents and Settings\user
\Local...
akkha1234@gmail.com
|
04-17-2007 06:11 PM
akkha1234@gmail.com  | 3 | 47 |
| | | Hi
Does anyone know of a free query analyser tool. I want to connect to
sql server 2000 DB remotely and run some queries and stored procs. I
was...
Katie
|
04-17-2007 12:44 PM
Helmut Woess | 2 | 51 |
| | | I currently have two tables:
1: users
id_user
username
2: baned_users
id_user
i tought i could use something like this
1: users
Igor
|
04-17-2007 10:03 AM
Igor | 4 | 61 |
| | | Hi,
We have 2 servers. Server1 is a 2000 box, with SP3 (yes I know it is
not up to date). Server2 is a 2005 box, SP2.
I set up Server1 (2000) to...
sqlgirl
|
04-17-2007 01:31 AM
M A Srinivas | 2 | 39 |
| | | We have recently set up two SQL Server 2005 Standard Edition servers
with database mirroring. The mirrors function and fail over without a
problem,...
bosko19@gmail.com
|
04-16-2007 06:48 PM
bosko19 | 5 | 49 |
 | | Hi everybody,
there are several SQL-Server 2000 databases within a company located
on different servers in different domains. On every database you...
Josef Meierhofer
|
04-16-2007 06:25 PM
Erland Sommarskog | 2 | 290 |
| | | Hi Expert,
In my DB i have a big table like this:
Primary key | param1 | para2 | param3 | param4 | ... |...
Alex
|
04-16-2007 06:04 PM
Erland Sommarskog | 2 | 283 |
| | | Hi All,
let me try to explain what I'm trying to accomplish - I really hope someone
can help.
I have a table (tblArticles) which has the...
news.demon.co.uk
|
04-16-2007 01:29 PM
Ed Murphy | 6 | 39 |
| | | I am tasked with maintaining a large database still on SQL Server 7.0.
Performance is an issue not surprisingly and I've targeted two rather
large...
Zamdrist
|
04-16-2007 10:16 AM
DH | 22 | 135 |
| | | There is a transformational change going on in business intelligence.
Users are becoming more and more demanding. They want access to their
real-time...
YellowFin Announcements
|
04-16-2007 08:55 AM
YellowFin Announcements | 0 | 43 |
| | | I am using a dynamic order by statement;
ORDER BY CASE @sort
WHEN 0 THEN CAST( COALESCE( t2.RANK, 0 ) + COALESCE( t3.RANK,
0 ) AS CHAR( 5 ) )
WHEN 1...
Pacific Fox
|
04-15-2007 11:38 PM
Ed Murphy | 4 | 53 |
| | | Hi.
Could somebody kindly tell me what conventions and best practices are
used when naming a database server (not the database itself) and/or...
pbd22
|
04-15-2007 11:37 PM
Greg D. Moore \(Strider\) | 5 | 72 |
| | | I NEED HELP FROM A PERSON WHO WOULD ASSIST ME WITH INTEGRATION OF PHP SCRIPTS AD THE SETTING UP OF DATABASES
PLEASE RESOND TO
BOBBIE_BEST_TATTOO (AT)... |
04-15-2007 11:08 AM | 0 | 46 |
| | | I NEED HELP FROM A PERSON WHO WOULD ASSIST ME WITH INTEGRATION OF PHP SCRIPTS AD THE SETTING UP OF DATABASES
PLEASE RESOND TO
BOBBIE_BEST_TATTOO (AT)... |
04-15-2007 11:05 AM | 0 | 52 |
| | | I NEED HELP FROM A PERSON WHO WOULD ASSIST ME WITH INTEGRATION OF PHP SCRIPTS AD THE SETTING UP OF DATABASES
PLEASE RESOND TO
BOBBIE_BEST_TATTOO (AT)... |
04-15-2007 11:05 AM | 0 | 42 |
| | | how to check the connection state sql
if (oconn.State.tostring()="Closed")
or is there a more approiate way
thanks
MJ
Mike J
|
04-15-2007 08:28 AM
Dan Guzman | 1 | 42 |
| | | Hi all,
I have a SQL statement that allows paging and dynamic sorting of the
columns, but what I can't figure out without making the SQL a...
Pacific Fox
|
04-14-2007 05:39 AM
Pacific Fox | 1 | 45 |
| | | Hi all
Is it possible to install MS SQL Client 2005 on Windows 98 ? I tried to do
this today but I got error with informations about rejects in...
Grzech
|
04-13-2007 07:31 PM
Plamen Ratchev | 1 | 34 |
| | | I posted this to another group but I must not be subscribed as nothing
appeared. Sooo....
I've backed up a databse with the following...
Utahduck@hotmail.com
|
04-12-2007 05:22 PM
Erland Sommarskog | 1 | 36 |
| | | I have a table, that has a column which determines the file name. I
want to export a file and rename it immediately.
For Ex:
Select Id,...
gelangov@hotmail.com
|
04-12-2007 03:25 PM
gelangov@hotmail.com | 0 | 33 |
| | | I've been having some issues so forgive me if this double-posts.
Because I have some large but static Filegroups within a database I
prefer to...
Utahduck
|
04-12-2007 07:47 AM
Mohit | 1 | 32 |
| | | Hi,
SQL Server 2005 Standard (X64) edition.
Have a database which has its log backed up every hour during the
normal business day and each evening...
David Gray
|
04-12-2007 04:47 AM
David Gray | 2 | 37 |
| | | I am trying to create a report in Crystal Reports (v 8.5). I have a
stored procedure to pull data from two databases and parameters.
There are...
yin_n_yang74@yahoo.com
|
04-11-2007 08:10 PM
--CELKO-- | 6 | 47 |
| | | OK ... I am using UPS Worldship that issues an ODBC query to my MS2K
server ... Worldship can query either a table or a view and retreive
shipping...
wjreichard@comcast.net
|
04-11-2007 05:34 PM
Erland Sommarskog | 3 | 56 |
| | | I have a column in my table that is an Image (blob). The data stored
in this blob is basically pdf files. I need a query to determine the
total...
Connie
|
04-11-2007 03:09 PM
Connie | 4 | 49 |
| | | (SQL 2005)
I'm looking to create a stored procedure to first "select name from
sys.databases where name like '%site'" then pass each name to...
Fran
|
04-11-2007 11:55 AM
Utahduck@hotmail.com | 3 | 42 |
| | | Yellowfin has announced a new partnership with Extol, one of
Malaysia's largest ICT security solutions providers, in which Extol
will integrate their...
YellowFin Announcements
|
04-11-2007 09:13 AM
YellowFin Announcements | 0 | 40 |
| | | I am investigating a SQL server performance issue where the system
operates well at times and poorly at others. This SQL server is
connected to a SAN...
SCOTTs
|
04-11-2007 04:27 AM
Jack Vamvas | 1 | 35 |
| | | Post your resume free at http://www.Corp-Corp.com to receive available
HOT Requirements/Corp-Corp Contracts that match your Resume Profile.
Multiple...
shanmips
|
04-11-2007 02:26 AM
shanmips | 0 | 36 |
| | | FREE signup at http://www.Corp-Corp.com to receive HOT Resumes and/or
HOT Requirements everyday.
Features:
Say Good Bye to search process.. Signup...
shanmips
|
04-11-2007 02:25 AM
shanmips | 0 | 36 |
| | | Been trying to come up with a query to filter-down my sample set into
distinct records. For instance, lets say column1 is a sample set,
column2 is...
plaster1@gmail.com
|
04-10-2007 12:09 PM
plaster1@gmail.com | 6 | 52 |
| | | I am new to SQL and SQL Server world. There must be a simple solution
to this, but I'm not seeing it. I am trying to create a crystal
report (v8.5)...
yin_n_yang74@yahoo.com
|
04-09-2007 06:11 PM
yin_n_yang74@yahoo.com | 4 | 41 |
| | | Hi Experts,
I am working on SSRS 2005, and I am facing a problem in counting the
no of days.
My database has many fields but here I am using only two...
Dinesh
|
04-09-2007 06:10 PM
Erland Sommarskog | 3 | 47 |
| | | Hello,
I have some questions on my options available.
I have to export some tables to csv files to enable another department
to process the files. ...
Designing Solutions WD
|
04-09-2007 03:09 PM
klimenkor@gmail.com | 2 | 44 |
| | | Hi,
Please find the below scenario
Original Table
course branch_exist
BY 0
UI 1
PO 1
meendar
|
04-09-2007 09:22 AM
meendar | 3 | 56 |
| | | I am no DBA, but this is my task.
I have an SQL Server 2000 Database that has an "SQL Account" that has
execute permission on all Stored procedures....
DaBrain
|
04-08-2007 06:51 PM
DickChristoph | 2 | 44 |
| | | Consider the following table
Customer
custId char(10)
accountExpiryDate datetime
accountStatus bit
Now, I want to update the accountStatus to False...
shane.taylor81@gmail.com
|
04-08-2007 05:33 PM
Ed Murphy | 12 | 102 |
| | | I am receiving the following error when I run a stored procedure:
Server: Msg 7391, Level 16, State 1, Procedure spXXXX
The SP inserts data into a...
c-eric.geil@mci.com
|
04-06-2007 04:27 PM
Erland Sommarskog | 3 | 36 |
| | | I have this query that I need to speed up. I don't know where to
start. Any advise would be greatly apreciated
SELECT
centerID AS , StoreID AS ,...
Designing Solutions WD
|
04-06-2007 02:12 PM
Designing Solutions WD | 2 | 49 |
| | | In SQL 2005 (we use Enterprise 64-bit SP2), the users cannot see the
text of the stored procedures, functions, etc.
This is a production database,...
traceable1
|
04-05-2007 06:08 PM
traceable1 | 2 | 39 |
| | | Hi,
I just deleted about 1 million records from a SQL Server 2000 database. I
access it using Access 2000.
I have Compact and Repair available in...
JA
|
04-05-2007 06:01 PM
Erland Sommarskog | 2 | 45 |
| | | We have a script that I had to rework a little bit for 2005 that does
a full backup for every database on the server... For some reason on
some...
m19peters@gmail.com
|
04-05-2007 09:35 AM
m19peters@gmail.com | 2 | 47 |
| | | Due to unprecedented growth, ChannelAdvisor Corporation, the leading
provider of online channel management solutions, is hiring.
Who is...
Eileen
|
04-05-2007 09:19 AM
Eileen | 0 | 45 |
| | | I have a table 'cust' as follows :
rec_id name dept
------- ------- -------
1, 'john', 'a'
2, 'tom', ...
osa
|
04-05-2007 02:41 AM
M A Srinivas | 6 | 59 |
| | | Access front-end, SQL Server 2005 backend.
I have users connected to SQL Server via a Microsoft Access user-
interface.
Connection is via NT...
bubbles
|
04-04-2007 10:54 PM
Aaron Bertrand [SQL Server MVP] | 1 | 41 |
| | | Hi,
I have an Excel file with 400 rows of old values and the corresponding
new values. My table currently has 10 columns out of which 3 columns
use...
urprettyfriend
|
04-04-2007 08:44 PM
thelawrencebishop@gmail.com | 4 | 45 |
| | | Hi,
I want my application to audit any data changes (update, insert,
delete) made by the users. Rather than have an audit table mirroring
each user...
WombatDeath@gmail.com
|
04-04-2007 06:12 PM
--CELKO-- | 5 | 50 |
| | | I am trying to write a single SQL query that would retrieve the data
that I need. For example, I have a table called Athletes that has 2
fields: name...
AdrianG
|
04-04-2007 06:03 PM
Erland Sommarskog | 5 | 52 |
| | | Hi all,
I've a problem with sql server 2000 EE.
I've a DB with a table with lots of records. I run a SELECT from
query analyzer, and I've results in...
DzU
|
04-04-2007 06:01 PM
Erland Sommarskog | 3 | 61 |
| | | I have posted this before. Now I have SQL server 2005 with Service
pack 2.
The problem is:
I get intermittent problem either when I am loading a...
gelangov@hotmail.com
|
04-04-2007 04:03 PM
gelangov@hotmail.com | 0 | 59 |
