I'm working on a small app for a law firm. The supporting database allows
for multiple Cases per Client, so it
has ClientID and CaseID to identify each Client and Case, respectively.
For each Case, there is a physical file maintained by the law firm that

I use SQL Server Management Studio on my development system but my client
will use the Express version which does not allow you to schedule jobs like
the Enterprise version does. So I want to run backups via a storedprocedure
if that is possible.. I'm still learning about stored ...

Create table #t2
(userid int,
noteddate datetime)
insert #t2 values(1,'2007-12-1 06:00')

Create table #t1
(userid int,
entrydate datetime,
productid varchar(5))

What's the prevaling view of using Select * only in views, not in stored
procs, if a rule exists that the client applications will only use stored
procs to return data, and views are only to be used by the stored procs?

I was assigned to develop a SQL database using Access front end with SQL
Server backend. I connect to the SQL Server through the MS Server Management
Studion. I am getting an error message while assigning users to use the
database. I am currently has the right of creating the ...

I have a table with a large number of columns.  One of the columns is
an
integer (int, not null), and another is a bit (bit, null).  If the
integer value

BOL for SQL Server 2008 says that the geometry and geography data types
support a subset of GML functionality. Does anyone know if MS has a
shortened version of the GML XML Schema available that reflects the features
that are actually implemented in 2008?

We are using SQL Server 2005.
We have 2 tables, say tblA and tblB.
tblA has a column called Account, which is its primary key.
tblB has a column called Account, which is its primary key and a foreign key

I have a table that has 2 rows..
Table1
outputvalues
0

What is the best way to produce the Schema from one Database in SQL 2005 and
load it into another database?
This has to be automated using scripting.
Possible parameters are source server, source DB, target server, target db.

I need to parse a field in a table called comment. That field looks like this:
<SN>1089153</SN><SNH>1803553</SNH><SNPCB>H52516</SNPCB><CN>C246-06-180</CN>
There is no problem to extract the serial which is between the <SN>, </SN>
tags. I am doing this with:

I have a few VB6 applications that access a remote Oracle database and store
information obtained from the Oracle DB in a Sql Server 2005 database.
Currently, the connection code for the Oracle database (along with the
password) is in my VB 6 code.  

Good evening,
I am not technically inclined so I am asking for a little help :)
When I start the computer I get an error message
"SQL Server - Your SQL Server installation is either corrupt or has been

Can you tell me where I can ask the question? I am afraid that I do not
understand SuperGumby's answer?