SQL Server 2000 SP4. Hoping to find a logical explanation for a certain
behavior.
Consider this script:
USE pubs

I am having an issue with a query that is trying to compare a string date to
today's date
I have a table like this
     PC Name

I have an SQL database with rows that have parens in the data.
If I run a select statement such as:
SELECT SongName
FROM Songs

I am trying to reference files in my SQL db which are stored on my
database. I do not want to store the files in the actual database.  I
have a web interface where the user searches for the file finds the
referenced file then tries to download it.  But for some reason when

I give up - will someone please tell me why in _Oracle_ I can do
something like:
select 'CREATE PUBLIC SYNONYM '||table_name||' FOR
SYSADM.'||TABLE_NAME||';'

how can i grant a user a temporary SA permission for a spesific action (like
alter a column in a table)?
thanks

I am new to SQL 2000 Administration.  My SQL Server has started indicating a
lot more disk activity than it has done in the past.  There are no jobs being
run and it is degrading the performance of the system.  How can I track the
problem to the source?

I have question about RAISERROR command.
Look at the example above. first select shows one record in table, that
means that transaction was committed. second select shows that transaction
was not committed.

First post so apologies if this sounds a bit confusing!!
I'm trying to run the following update. On a weekly basis i want to
insert all the active users ids from a users table into a timesheets
table along with the last day of the week and a submitted flag set to

dim gConn as new adodb.connection
           gConn.open "...."
           strSQL = "sp_rename 'mytable', 'mytable1','OBJECT'"
           gConn.Execute strSQL, , adCmdStoredProc

I wrote a store procedure like this:
declare @dbname nvarchar(50)
declare db_cursor cursor for
select name as database_name from master.dbo.sysdatabases

Hi all, I am sanju,
To generate report I am using table named as "tempTest" for displaying
count of dealer.
On back end i am using oracle.

I parse a querystring from a .net website into a stored proc;
ALTER PROCEDURE Postlists_CreateList
(
@Groups varchar(255) = NULL

I am trying to write something to give me back all the data for a
sertain time range for today.
So for example: I need to get all records where change_date is <= today
2pm and > today at 8pm.

I am new to SS2005, and I've just started working on a small test/dev
database.
I recently read that one should store things like tables, views,
constraints, etc. in the *.ndf file rather than in the *.mdf file.