|
|
| recovery mode |
| Hi, my database is simple recorvery model now, what is the good/bad things if
I swith to full? thanks... on 20-Nov-09 |
| |
|
| QA - edit procedure shows "create" |
| SQL 2000 Query Analyzer. Well this seems very odd to me. Every stored
procedure I can ever remember doing this with has never done this. When you
have the object browser open and right click a stored... on 20-Nov-09 |
| |
|
| INSERT INTO behaviour??? |
| Hi all I was just writing a quick insert INTO and got an error
Msg 156, Level 15, State 1, Line 15
Incorrect syntax near the keyword 'ORDER'.
INSERT INTO [Test].[dbo].[address1]
(
[ID] ,
[customerId... on 20-Nov-09 |
| |
|
| display duplicates |
| Hi Champs,
I do have a table in which machine info is stored. It does has lot of
duplicate entries. I have written a simple code to list them..
select a.Name0,count(*) from v_r_system group by Name... on 20-Nov-09 |
| |
|
| replicating euro symbol from oracle to sqlserver |
| Hi,
I have a problem regarding euro symbol (?) replication from Oracle to
SQLserver2005. At oracle side we have a column containing ? (euro symbol).
which is being replicated to sql server. The s... on 20-Nov-09 |
| |
|
| Stored Procedure Update on Multiple Servers |
| Hi,
I am wondering if this is at all possible, I have a number of SQL Server
2000/2005 servers with different names with the same database name on them
but within different locations and containing ... on 20-Nov-09 |
| |
|
| Truncate Table Table variable |
| Hi,
Sql Server 2005
I am using table variable with in a stored procedure and within a
table variable i am using identity field.
Sometimes I required to truncate the table variable to rseed the
identi... on 20-Nov-09 |
| |
|
|
|