How does one find out what type of licensing is employed on a SQL
Server Box.  i.e is it Per Process or Per CAL?
Martyn

I'm trying to duplicate a set of values in a table for a second user. The
table only has 2 columns one containing a username and the other containing
a code. Given the following, how would I insert new rows with a different
username using the same values of another username from ...

I'm having a problem with a SQL statment.  I've got two tables:
Table Stage:
Location    Date      Sales       Exp     Tax
NewYork      1/1/01    100.50     5.75    11.25

When trying to do a full backup, I get write on
c\xxxxxxx\shipmatedb_20050715xxx - failed status 112.
It allow however to do the backup is I select "overwrite existing media"
The only thing that has changed today was that I shrunk the log file.....

I'm doing a update on a table in SQL Server. The fields I am updating are
skill_major_1 through skill_major_20 each of these skill major's has a
skill_sub_1_1 through skill_sub_1_5, the first number changes for each major.
What I'm trying to do is search for a possible value like

Hi to all,
excuse my english ( i'm an italian student... )
I have the necessity of make a stored procedure that convert one
parameter passed from base64 to binary before store in a field image.

I have a table using an identity column as its Primary Key and two
columns (table reduced for simplicity) EmployeeNumber and ArrivalTime.
CREATE TABLE [tblRecords] (
    [ID] [bigint] IDENTITY (1, 1) NOT NULL ,

The current way the name column is set is last,first,middle seperated by
commas.
How would I create 3 seperate columns to break out the information? This is
a SQL 2000 database

I have some multibyte characters and I want to put them into table fields.
how I can do this? Just storing them will result in a ? when reading /
showing them.
thanks & regards

Recently I came to know that using View inside another View will decrease the Performance
(1)Is this true.
(2)And If I use View instead of SQL Statements inside a stored procedure, Will this also decrease the performance.
Any help on this will be appreciated

can we connect named instance through IP like in the network utility I just
defined the IP of the server where the named instance installed and define
the port....
Client Netowork Utility > Alias >

There must be a way to convert the binarydata field in the SQL trace output
to text data when the event type is a show plan.  SQL Profiler does it but
how can it be done from an imported table?
Danny

My msdb database is marked as suspect. This means that my maintenance plan
doesn't work. I'm a novice when it comes to sql server so now I'm wondering
if anyone could give a hint on how to fix the suspect msdb database? Does
this database contain any vital information? What could ...

In MS SQL Management Console I can right-click on any Table and I have
the option All Tasks > Export Data where I can export the table to
Excel.  In a View however this isn't there.  I have many views I want
to simply export to Excel, but the only way I've found to do it is

is there any tool which is capable to convert query initially written for
msaccess database to query for mssql server.
I have tons of queries which contains iif, trim and similar functions which
should be converted to case, ltrim(rtrim(, etc. etc.