| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Here is a thread I posted elsewhere that I wonder if someone here
could shed some light on...
The original question I had:
--- BEGIN ---
Which one...
csimam@gmail.com
|
09-04-2007 10:09 PM
csimam@gmail.com  | 2 | 40 |
| | | Hi,
I'm trying to concatenate a Description (nchar(100)) and Date
(datetime) as Description and my initial effort was just
"...description+'...
Chris H
|
09-04-2007 03:04 PM
Chris H | 2 | 38 |
| | | Using SQL Server 2000 in a view, if the data is Char and six
characters like: 081564
How do I convert it to a date that looks like: 08/15/1964 and...
robboll
|
09-04-2007 01:25 PM
Shiju Samuel | 1 | 62 |
| | | I'm working on a restore procedure for the case where all MDF files
are missing, but the LDF files are all intact. A full backup is done
every 24...
l0b0
|
09-04-2007 09:55 AM
l0b0 | 2 | 41 |
| | | Hello,
I've run as many keyword combinations searching for this as I can
think of, but cannot find a simple answer.
The situation: I have a...
downwitch
|
09-04-2007 08:42 AM
xman | 3 | 46 |
| | | Because of poor upgrading routines I have a SQL Server 2000 database
that has several collations on column level.
The SQL Server itself is correctly...
urquell@gmail.com
|
09-04-2007 05:15 AM
Erland Sommarskog | 1 | 40 |
| | | Yes (1), note though that the RAND function will resolve to the same value for all rows returned by
one query:
USE tempdb
CREATE TABLE t(c1 int, c2...
Tibor Karaszi
|
09-03-2007 11:24 AM
Tibor Karaszi | 0 | 38 |
| | | Yellowfin, Powered by J2EE, Jasper, BIRT, Spring, jfreeChart
Advanta releases ATLAS BI using Yellowfin Business Intelligence
3rd of August, 2007 -...
YellowFin Announcements
|
09-03-2007 09:37 AM
YellowFin Announcements | 0 | 40 |
| | | I want to create a string using the week number and year of a date.
For instance, if i have a date of 1/3/2007, which would be week 1 of
2007, i want...
rgintexas
|
09-03-2007 09:31 AM
Dan Guzman | 2 | 45 |
| | | Hi
I am relatively new to databases. I would like to be able to run a
query that returns the t_no, b_no, status and cpu for the latest
record for...
jrpfinch
|
09-03-2007 05:07 AM
Shiju Samuel | 1 | 48 |
| | | Thx everybody for your help! It works the way I wanted it to and I
learned some new things :).
Regards,
Bart
Bart op de grote markt
|
09-03-2007 03:23 AM
Bart op de grote markt | 6 | 45 |
| | | Hi,
We are implementing Log shipping feature of SQL Server 2005.
We are facing some issues when the RESTORE job is restoring the TRN
files on the...
pramodbura
|
09-03-2007 02:29 AM
pramodbura | 0 | 63 |
| | | We often have to migrate changes to sql server 2000 databases from
development to production. Normally we dump the sql from Enterprise Manager
for...
RichardLamont
|
09-01-2007 03:39 AM
Mork69 | 3 | 35 |
| | | MS SQL Server 2000
Location: Raleigh, NC | Duration: 6+ Months | Start Date: ASAP | Rate:
Open
We are willing to pay salary of 60K to 70K/year or...
NJ
|
08-31-2007 04:47 PM
NJ | 0 | 43 |
| | | Hi experts,
I am working on SQL server 2005 reporting services and i am getting a
problem in writting a query.
Situation is given below.
There is...
Dinesh
|
08-31-2007 04:17 AM
Dinesh | 2 | 43 |
| | | Hi,
I'm attempting a replication job on SQLServer 2000 sp3 bwteen 2
servers.
- Transactional push
- Continuous
- It contains 13 tables
- The...
JonBosker
|
08-30-2007 10:54 PM
JonBosker | 0 | 36 |
| | | Hi All,
I am trying to create multiple endpoints for mutiple database that has
service broker enabled. It allows me to create only one endpoint...
SQLMan_25
|
08-30-2007 04:24 PM
Najm | 1 | 43 |
| | | hi all
my query is how can i send mail by using sql server, i think by unsing
xp_sendmail store procedure we can do this but my problem is...
sachin shah
|
08-29-2007 05:35 PM
Erland Sommarskog | 5 | 50 |
 | | I can't seem to find a method of converting a CHAR(8) column in the form of
YYYYMMDD to an actual date such as mm/dd/yyyy
Can anyone point me in the...
rdraider
|
08-29-2007 12:37 PM
Piero 'Giops' Giorgi | 18 | 80 |
| | | Hi All,
Hoping someone can assist with this. Is there an SQL trace flag, or
other method, where I can get the SQL server error logs (2000 and
2005)...
snafu66@hotmail.co.uk
|
08-29-2007 01:57 AM
snafu66@hotmail.co.uk | 0 | 82 |
| | | Hi!
I'm testing SQL Turbo (From Quest Software)
Any of you guys ever used it? Impressions? Advice?
P
Piero 'Giops' Giorgi
|
08-28-2007 08:07 PM
Piero 'Giops' Giorgi | 0 | 37 |
| | | I just downloaded the SQL Server 2008 CTP. Anyone here check it out
yet? Thoughts?
rcamarda
|
08-28-2007 05:33 PM
Erland Sommarskog | 1 | 38 |
| | | Hi all,
We have this morning used DTS to copy some objects from one database
to another.
We removed the tick to "Copy all objects" and selected...
RS200Phil
|
08-28-2007 05:37 AM
RS200Phil | 0 | 41 |
| | | I have 2 variables, one is the column name of the table and the other
one is the table name and I need to write this in the "Execute SQL
task" of a...
gelangov@hotmail.com
|
08-27-2007 05:58 PM
Erland Sommarskog | 12 | 86 |
| | | I've built a development server for my SQL 2005 production
environment. I've restore the databases from a backup, and I want to
copy the users from...
rcamarda
|
08-27-2007 02:30 PM
rcamarda | 2 | 48 |
| | | I'm using SQL 2005 Management Studio and am having a problem
connecting to Reporting Services. I get the following error when I
attempt to connect. ...
Tech4Me
|
08-27-2007 10:15 AM
Tech4Me | 0 | 36 |
| | | I have inherited a SQLS erver 2000 instance where the client never
implemented a backup startegy for the "master" and "msdb" databases.
MSDB is now...
Mr.Kane
|
08-25-2007 01:00 AM
kb | 1 | 47 |
| | | Hello All,
I am having trouble coming up with the correct SQL to accomplish a
task. Most of the SQL I use is quite simple and I rarely have...
Paul
|
08-24-2007 06:45 PM
Paul | 2 | 46 |
| | | I have a bak file of a sql server express database from another server,
and I'd like to restore it to my dev box as a different database. Does
anyone...
nano
|
08-24-2007 05:49 PM
Erland Sommarskog | 1 | 50 |
| | | Having problems joining three tables. I only want the Title field but
need them to give me the correct data.
Here are my three tables and their...
JJ297
|
08-24-2007 05:46 PM
Erland Sommarskog | 1 | 48 |
| | | I have to create a script to install a database, and one of the tables
has about 200 rows of static data... I dont want to have to manually
type in...
rhaazy
|
08-24-2007 03:51 PM
info@sqlscriptbuilder.com | 6 | 40 |
| | | I am on a project right now where we are going from ASA10 database
into SQL Server 2005.
In ASA10 there are some system function names that do not...
Jon Chase
|
08-23-2007 06:56 PM
Jon Chase | 0 | 40 |
| | | I am on a project right now where we are going from ASA10 database
into SQL Server 2005.
In ASA10 there are some system function names that do not...
Jon Chase
|
08-23-2007 06:53 PM
Jon Chase | 0 | 42 |
| | | hi,
I am trying to
1)get all the names of a table that match another table
2)while count=0, then I want to insert into another table 'group'
after...
lhiregoudar@hotmail.com
|
08-23-2007 06:43 PM
David Portas | 2 | 57 |
| | | I can't seem to find a way to convert an INT type in the form of YYYYMMDD to
an actual date form of mm/dd/yyyy
Can anyone pointt me in the right...
rdraider
|
08-23-2007 06:41 PM
rdraider | 0 | 42 |
| | | Hi all,
these are my tables :
CREATE TABLE .(
IDENTITY(1,1) NOT NULL,
(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL,
(50) COLLATE...
aCe
|
08-23-2007 05:54 PM
Erland Sommarskog | 1 | 50 |
| | | Hi there,
I have a problem that's beginning to do my head in and hope someone
can help!!!
I've got a SQL Server 2005 database which is partly...
Michael Burgess
|
08-23-2007 05:33 PM
Michael Burgess | 0 | 42 |
| | | Hi!
I'm using the Thesaurus search on a SQL Server 2005 Db
The thesaurus file is built like this (Reduced version)
<XML ID="Microsoft Search...
Piero 'Giops' Giorgi
|
08-22-2007 06:12 PM
Piero 'Giops' Giorgi | 0 | 41 |
| | | Hi there
As many people nowadays, I have 2 XP installations on my laptop - one
running natively and one in vmware box running on ubuntu...
HP
|
08-22-2007 05:58 PM
Erland Sommarskog | 1 | 44 |
| | | I folks.
I Have installed sql server 2005 express and choosed windows
authentication on instalation, but i make a mistake and now i need
mixed...
Fonseca
|
08-22-2007 05:55 PM
Erland Sommarskog | 2 | 50 |
| | | sql server 2000 sp4 build 2184
runs stats with maintenance plan
sp_msforeachtable
stored procedure updating full stats for each table and the...
Massa Batheli
|
08-22-2007 05:46 PM
Erland Sommarskog | 6 | 63 |
| | | Hi All,
I am facing a problem while executing a statement through C++ code
using OLEDB API of Sql server.
There is a problem with DB_OWNER role. If...
monty
|
08-22-2007 05:36 PM
Erland Sommarskog | 7 | 54 |
| | | Hello,
Suppose I have the following table...
name employeeId email
--------------------------------------------
Tom 12345 tom (AT) localhost...
Yas
|
08-22-2007 03:13 AM
Luuk | 6 | 42 |
| | | My basic situation is this - I ONLY want duplicates, so the opposite
of DISTINCT:
I have two tables. Ordinarily, Table1ColumnA corresponds in a one...
aknoch@gmail.com
|
08-21-2007 08:36 PM
Roy Harvey | 1 | 40 |
| | | Hi,
I am trying to create an update statement
on a table with a foreign key to the Users
table (userid).
I am getting the error:
An expression of...
pbd22
|
08-21-2007 06:25 PM
pbd22 | 2 | 65 |
| | | Hi,
MSSQL 2000 booth servers. Booth running DTC.
Now, the client application, is starting in DB1 a procedure.
The connection open to db, is within...
Matik
|
08-21-2007 11:42 AM
Matik | 0 | 32 |
| | | We have a simple problem:
We have a table Assets and a table
Asset_Versions. In addition, there are columns
added by replication for storing the...
yashgt@gmail.com
|
08-21-2007 08:19 AM
yashgt@gmail.com | 0 | 32 |
| | | Hello,
I have 2 tables, Table1 and Table2. I have copied all data from Table1
to Table2.
However Table1 is dynamic it has new rows added and some...
Yas
|
08-21-2007 07:01 AM
Roy Harvey | 14 | 72 |
| | | HI,
I have a table
Create table test(a int identity(1,1), b int)
insert into test(b) values(12)
insert into test(b) values(30)
insert into test(b)...
satish
|
08-20-2007 06:06 PM
Roy Harvey | 3 | 36 |
| | | Hi,
What is the SPID column for in SQL Profiler?
I have many databases but I only want to view the transactions on one
particular database. What...
wesleym312@gmail.com
|
08-20-2007 05:56 PM
Erland Sommarskog | 3 | 45 |
