| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | This is a very basic question, perhaps more of a Windows XP
Professional OS permissions question than a dB or programming
question: how to create and...
raylopez99
|
04-01-2007 04:02 AM
Erland Sommarskog  | 9 | 51 |
| | | how could I start learning SQL SERVER
Im just student
any_Girl
|
03-31-2007 07:00 AM
Luuk | 1 | 57 |
| | | Hi.
I just downloaded and installed Sql 2005 from the MS site.
I see that my instance of Sql 2000 is still on the same computer.
I assumed that Sql...
pbd22
|
03-30-2007 04:43 PM
Erland Sommarskog | 1 | 34 |
| | | I would like to allow a particular user to truncate a log file in a
stored procedure that the user runs every day. At this moment the only
personnel...
hedgracer
|
03-30-2007 04:41 PM
Erland Sommarskog | 1 | 36 |
| | | How can I create a field in a view that takes a date field and
converts it to a month?
For instance, if I have a field called "CreatedOn" with a date...
lisa.moffitt@gmail.com
|
03-30-2007 04:34 PM
Erland Sommarskog | 1 | 50 |
| | | Hello, I have a resultset as follows:
fields: Name, RankID
values:
Prorduct A, 4
Product B, 33
Product C, 221
(etc)
Mike
|
03-29-2007 09:31 PM
Plamen Ratchev | 3 | 37 |
| | | I am encountering a weird issue with SSIS.
I have a very simple SSIS package that executes a .bat file. Here's
the
actual file it executes:
@Echo...
ansonee
|
03-29-2007 11:41 AM
ansonee | 0 | 32 |
| | | Hi all,
I'm having a problem restoring backup from 2000 to 2005. The actual
restore process went ok. However, the database user of the...
Gerd
|
03-29-2007 02:08 AM
kb | 2 | 50 |
| | | im writing a service that will be on a app server
this is one of many service's to process Recordsets from Sql Server...
1 service may have 20...
DaveP
|
03-28-2007 05:41 PM
Erland Sommarskog | 1 | 42 |
| | | Please bare with me here:
I have been running an SQL Express backend for a small project i've
been working on. We've recently added a "small...
MacRae
|
03-28-2007 05:36 PM
Erland Sommarskog | 3 | 40 |
| | | Hello
I watchet some posts but did not find answer to my question : how to
import data from xml into mssql 2000 using t-sql?
i tried:
USE...
AJA
|
03-28-2007 06:35 AM
AJA | 4 | 43 |
| | | Following is our test steps.
1. Create directory E:\firefly in E:.
2. Create a test file a.txt in E:\firefly.
3. Create E:\firefly\test.bat file ...
Amber
|
03-27-2007 08:33 PM
Amber | 5 | 42 |
| | | Hi all,
ISSUE:
====================
In SQL 2005 (sp2) I get the following error when preforming a bulk
insert with an associated xml format...
Peter Nofelt
|
03-26-2007 05:36 PM
Peter Nofelt | 0 | 38 |
| | | Once I've added Files for a database across mulitple SAN drives will
SQL 2005 automatically partition data across the Files automatically?
Will it...
Erik G
|
03-26-2007 04:25 PM
Erland Sommarskog | 1 | 31 |
| | | Hi,
We have a SQL-cluster with over 6300 databases, most of them pretty
small in size and usage.
For this reason all these databases are on...
Icemokka
|
03-26-2007 04:21 PM
Erland Sommarskog | 5 | 42 |
| | | Hi,
We have stored proc name proc_test(str nvarchar(30)). So far this proc
has been invoked from a .NET application assuming that only...
yashgt@gmail.com
|
03-26-2007 02:34 PM
Razvan Socol | 1 | 38 |
| | | I am MCDBA, I like your group, and i need to join it as a member
but i do NOT know How .
Please help
Thank You
maged.
magedsql@gmail.com
|
03-26-2007 11:38 AM
AlterEgo | 4 | 45 |
| | | Hi friends,
First I would like present me. My name is Eduardo, I am publisher of
the Mr.Bool Portal (that can be accessed through the address...
Eduardo Spínola
|
03-26-2007 10:05 AM
M A Srinivas | 1 | 39 |
| | | Hi,
I would like to know details about the table name starts with prefix
in sql server 2000.
Actually i'm working on existing code.
The existing code...
plmanikandan@gmail.com
|
03-25-2007 09:56 PM
DickChristoph | 7 | 41 |
| | | I have the following 2 tables:
(BATCHES)
BatchID KEY
ID
OrderID
Action1DateTime
Action2DateTime
Action3DateTime
Action4DateTime
Henrik Juul
|
03-25-2007 05:56 PM
--CELKO-- | 3 | 35 |
| | | Hi,
I am bloody amateure and I was wondering if someone could help me edit
the statement below so it groups the field SCDMASTER.SCTY_CLASS_CODE
and...
Andreas
|
03-23-2007 08:14 PM
Ed Murphy | 3 | 41 |
| | | How do I make a view non updateable? I want to create a view so that I
will not be able to update, insert or delete the view so that base
table is...
othellomy@yahoo.com
|
03-23-2007 05:05 PM
Hugo Kornelis | 4 | 57 |
| | | Hi,
very new to SQL queries, and strugling with join concept
I had to do a join based on a single field:
select
*
from
tableA, tableB
dave
|
03-23-2007 01:30 PM
Plamen Ratchev | 2 | 43 |
| | | Some of my receiving service side applications usually work offline, and
they only are supposed to get connected to the network once/few times a...
fireball
|
03-23-2007 12:09 PM
Alan Brewer [MSFT] | 1 | 42 |
| | | Hello,
I am trying to develop a database solution for an organisation in
Indonesia.
This organization has a number of offices and users throughout...
Michael
|
03-23-2007 04:54 AM
lyle fairfield | 1 | 42 |
| | | Hi!
I need to refresh an entire database.
I can recompile SPs with sp_recompile (or DBCC FLUSHPROCINDB), and
refresh views with sp_refreshView, but...
Ben
|
03-22-2007 04:48 PM
Erland Sommarskog | 5 | 50 |
| | | Does anyone know where to start if I want an exported copy of home
appliances, cars, cell phones etc.
I just need to populate my database and I want...
vilasack.phothisan@gmail.com
|
03-22-2007 04:31 PM
AlterEgo | 1 | 37 |
| | | W23K 64 bit SQL 2005 SP1 64 bit (clustered).
Whenever I start mail with sysmail_start_sp it starts and then stops
with the following entries in...
DBA99
|
03-22-2007 10:33 AM
DBA99 | 0 | 74 |
| | | Hi,
I have a Sybase dataserver containing lots of (huge) tables that I
would like to access from SQL Server (two different applications,
using two...
arshad.tanveer@gmail.com
|
03-21-2007 10:44 PM
arshad.tanveer@gmail.com | 3 | 56 |
| | | We are planning a SQL Server 2005 install on VMware ESX, as the
backend to a Sharepoint Services 3.0 web front end..
Do I gain anything at all by...
tlyczko
|
03-21-2007 09:45 PM
Tom van Stiphout | 1 | 40 |
| | | I have two tables (T1 and T2). In T1 I have a field FT1 that is a
primary key in T2 I have a field FT2 that is a foreign key linked to
FT1. These...
ebade2000@gmail.com
|
03-21-2007 05:06 PM
ebade2000@gmail.com | 3 | 45 |
| | | my query:
select Product_List.*, Product_Sales.*
from Product_List
left outer join Product_Sales on Product_List.ID = Product_Sales.ID
this works...
knowzero
|
03-21-2007 04:56 PM
Ed Murphy | 3 | 46 |
| | | create table t1(c1 int, c2 varchar(10))
insert t1 values(1,'Hello')
insert t1 values(2,'')
insert t1 values(3,NULL)
select *
from t1
c1 c2
1 Hello
othellomy@yahoo.com
|
03-21-2007 02:01 PM
Hugo Kornelis | 6 | 54 |
| | | Hi,
I would like to compare two sql server databases.
I need to find the difference in the two database(i.e table, colums,
data type)
Is there any...
plmanikandan@gmail.com
|
03-21-2007 11:55 AM
darek | 2 | 44 |
| | | I discovered that many of my very busy colleagues are having an
extremely difficult time pulling themselves away to take vital
training when it...
whosesocks
|
03-21-2007 11:51 AM
tlyczko | 1 | 57 |
| | | NeoEdge Networks
www.neoedge.com
We're looking for a Senior Database Administrator, for our office in
Toronto, Ontario Canada.
Position...
jsaccomanno@gmail.com
|
03-21-2007 09:42 AM
jsaccomanno@gmail.com | 0 | 47 |
| | | NeoEdge Networks
www.neoedge.com
We're looking for a Senior Database Administrator, for our office in
Toronto, Ontario Canada.
Position...
jsaccomanno@gmail.com
|
03-21-2007 09:34 AM
jsaccomanno@gmail.com | 0 | 57 |
| | | Hi,
I am planning to automate a nighty restore of a DB on another server
can someone point me in the right direction with the SQL script to
modify...
blueboy
|
03-21-2007 07:39 AM
blueboy | 14 | 110 |
| | | Hi,
I have a need to create a table detailing the ID of all contacts and the
last time they were contacted. This information is stored in 2...
Mintyman
|
03-21-2007 06:20 AM
Mintyman | 2 | 47 |
| | | Hello,
I have a problem with XML schema update for one XML column (problem
exists in both SP1 and SP2 for SQL Server 2005).
1. I have a table that...
eduardasm
|
03-21-2007 05:56 AM
eduardasm | 0 | 43 |
| | | The first query returns me the results from multiple databases, the
second does the same thing except it puts the result into a #temp
table? Could...
santaferubber@gmail.com
|
03-21-2007 02:38 AM
othellomy@yahoo.com | 1 | 42 |
| | | I am using SQL Server Express and ASP.
I have a table that contains news articles, headlines, start and end
dates. I am trying to create a...
t8ntboy
|
03-20-2007 04:02 PM
AlterEgo | 3 | 45 |
| | | Hi,
I posted this in an access adp newsgroup, but there don't seem to be any
messages there since 9-06.
I am accessing an online SQL Server (2k)...
JA
|
03-19-2007 11:38 PM
Jonathan Roberts | 1 | 52 |
| | | I was able to view table content easily before, but after I
reinstalled everything, I cannot find the option to view table content
in MS SQL Server...
antonyliu2002@yahoo.com
|
03-19-2007 10:09 PM
antonyliu2002@yahoo.com | 6 | 49 |
| | | Sorry if this seems too easy to be interesting - I have yet to find an
elegant solution, as I am completely new at this so don't really know
what to...
jrpfinch
|
03-19-2007 01:49 PM
David Portas | 2 | 45 |
| | | I have a table with a date_created and date_expired and I want to look
at the 15th of each month and every month since the system started and
count...
Giorgio
|
03-19-2007 01:41 PM
Hugo Kornelis | 1 | 51 |
| | | Can someone tell me options to do this statment because this one does
not work!
SELECT Name FROM tbl_J
WHERE J_ID IN
(SELECT J1, J2, J3, J4, J5,...
Giorgio
|
03-19-2007 08:02 AM
Roy Harvey | 3 | 51 |
| | | I installed an application which adds an extended stored procedure. I've
since uninstalled the application and deleted the xp it added, however...
Jwilliams
|
03-19-2007 06:58 AM
Jwilliams | 0 | 44 |
| | | I have a stored procedure that calls another stored procedure with the
first stored procedure opening a transaction:
BEGIN
SET XACT_ABORT ON
BEGIN...
cricketweb@gmail.com
|
03-18-2007 11:12 PM
M A Srinivas | 1 | 45 |
| | | What is the easiest way to solve "," problem
Fields A, B and C are float-values
INSERT INTO Table
(A, B, C)
VALUES (1,2,3)
This is ok, but. How...
Kaitsu
|
03-18-2007 10:13 AM
Dan Guzman | 1 | 54 |
