Hi, I have a linked server to an Oracle db and I want to disable a trigger before I update a record. I am able to select data from the table using...

Mounilk

09-16-2010 02:30 AM
Erland Sommarskog

how do i alter a table which has constraint. I am altering a table USE GO IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'') AND...

Swati Shrivastava

09-15-2010 04:41 PM
Erland Sommarskog

SQL server standard edition version 8.00.2039 on MSWindows NT 5.2 . We have a procedure that is scheduled to run every night . It is running fine...

=?Utf-8?B?ZGI=?=

09-14-2010 03:52 PM
Erland Sommarskog

Hello! Like in subject.... id like to know becouse i can`t find how works and how to create(setup) shared storage for sql server cluster? What i...

hehehe

09-14-2010 01:06 AM
hehehe

Hi, SansSQL blog has been updated recently. Please follow the below link to read more about the topic "Schema Changes History Report in SQL Server...

Sandy

09-13-2010 09:44 AM
Sandy

i'm writing up DBA standards for my boss and I'm recommending we don't use sa unless it's an emergency. So far so obvious. What I'm not so clear...

nzrdb6

09-13-2010 08:59 AM
nzrdb6

I need to let a windows Admin apply a hotfix but also need to prevent him being able to issue any DML against the user DBs. My first thought was to...

nzrdb6

09-13-2010 07:23 AM
Erland Sommarskog

Hi all, I have a report which uses a username as an input parameter. I need to schedule the report to run automatically and email only the page...

Lior_Me

09-12-2010 09:16 AM
Lior_Me

Using the following DMV I get to know which of the objects in the DB is in use dm_exec_trigger_stats, dm_exec_procedure_stats,...

Gal

09-12-2010 04:14 AM
Erland Sommarskog

What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft...

nntp@microsoft.com

09-11-2010 09:56 AM
nntp@microsoft.com

Hi all, Using ASP.NET, SQL SVR Express 2008 I want to use IN to select records that have one of a list of values like this: SELECT * FROM MyTable...

kpg

09-10-2010 03:46 PM
John Bell

I want to convert a MS SQL 2005 Database to sdf (Compact), and include all the tables, views and stored procedures. Is there a good tool available...

Brian Stoop

09-10-2010 01:38 PM
Brian Stoop

Hello Reader, For mirroring in the High Protection mode, I did understand that the transaction safety is FULL and therefore that there is no data...

ben brugman

09-10-2010 09:58 AM
Gert-Jan Strik

Hi All, I have a table which contains some status information. Table1 (device varchar(200) primary key, NumberOfUsage int) Now I have a store...

schaf

09-10-2010 08:00 AM
schaf

Morning, I am creating my first maintenance job today and I have some general questions about the order of steps regarding the db and t-logs. I am...

Noncentz

09-10-2010 02:54 AM
John Bell

Does a good reference or tutorial exist for this topic?? We only need READ access from SQL 2008 to the VFP tables -- various select queries for...

tom12010

09-09-2010 01:15 PM
tom12010

Hello: I know that the security update that makes SQL 2005 be version 9.0.4053 is just that--an update. But, where can you go to download this? I...

childofthe1980s

09-09-2010 11:13 AM
Abdul Waheed

I am running the SQL 2005 Upgrade advisor on a SQL 2000 box and I keep getting the following messages on the following objects. Timeout expired. ...

John Metaxas

09-09-2010 08:06 AM
dba

Dear All Sql 2000 following is DDL and sample data CREATE TABLE #tmp (

Jami

09-09-2010 12:02 AM
Tom Cooper

Hello, I've read where once you setup log shipping in SQL2008 you can't take any additional backups from your primary server. What's with this? We...

GiJeet

09-08-2010 04:40 PM
JoshBond

I'm looking to install a SQL Server into my virtual infrastructure. My hardware is setup like this... virtual host with 10Gb ethernet, SAN with 12...

Matthew

09-08-2010 01:48 PM
Matthew

Hi All, I'm looking for a unique identification of my MS SSQLServer 2008 R2. The DB_ID() is not enough, because I would like to have a...

schaf

09-08-2010 09:27 AM
schaf

Hi at all Do you know when the Lock Wait Time increases? What are the possible situations that allow it to increment ? Tk u very much. PIT

PIT

09-07-2010 07:56 AM
PIT

I HACK $3000 FROM PAYPAL At http://simpleupdates.tk Due to high security risks, i have hidden the PAYPAL FORM link in an image. in that website on...

paypal cash

09-07-2010 02:24 AM
paypal cash

I try to work with table with "sensitive to register" name through Linked Server (MSSQL 2005/2008) and get the problem with UPDATE...

Dmitry Kovalenko

09-06-2010 03:27 PM
Erland Sommarskog

All, when we create a job via the maintenance plan, we have the option of including "Clean up History" and "Maintenance Cleanup Task". Via the...

Gopinath Rajee

09-06-2010 12:16 PM
Jeffrey Williams

All, I want to understand the OFFLINE database state better. Suppose, if I want to move a database to another drive after the executing "ALTER...

rgn

09-06-2010 09:46 AM
amish

I'd like to use a Maintenace plan to run DBCC + Update Statistics on my DBs, but since i have one DB which is Read Only it stacs on that DB. What can...

Gal

09-05-2010 04:42 PM
Andrew J. Kelly

HI I have inherited a server that has SQL Server 2005 installed on MS Server2003 OS - Problem - MS SQL server manager studio EXPRESS is...

!ngeniuos

09-03-2010 03:30 PM
Erland Sommarskog

I have a Sql Cluster that failed with the following message in the event log. 'SQL Server' in Resource Group 'Disk Group 1' failed. The customer is...

Dan Holmes

09-03-2010 03:27 PM
Erland Sommarskog

Is there anyway to retrieve the product key from a SS2005 Standard Edition installation? Can I use Developer Edition media and convert to...

Kevin Doyle

09-03-2010 01:48 PM
Kevin Doyle

We have SQL 2008 server on our network and I am periodically losing connection to SQL Server on my Win 7 PC. I will be working in and out of SSMS...

DavidC

09-03-2010 11:30 AM
DavidC

Hi NG, I have a store procedure which is my error handler. In each catch- block of a try/catch a call this function for error analization. Now in...

schaf

09-03-2010 05:32 AM
schaf

Yo Geeks, SQL 2008 SP1 CU 5 Enterprise x64 Windows Server 2008 R2 Datacenter Wrote a basic Powershell script to get Membership of Certains Groups...

Andy Ball

09-03-2010 05:07 AM
Andy Ball

I have a database that has somehow become corrupt in that there is a primary key constraint in sysobjects that is no longer connected to the table...

GordonS

09-02-2010 05:55 PM
John Bell

I have lots of unused SP in my DB and i'd like to delete them. I need to find them. How can I know that a Stored procedure is not used. (with the...

Gal

09-02-2010 05:39 PM
John Bell

I am looking for a good database modelling tool in order to design an sql server database. What is about VISIO and which version is the best?

Gal

09-02-2010 05:16 PM
John Bell

I need to compress hudge files (PDF + TIFF) stored in a varbinary field. I found in BOL that :" Because of their size, large-value data types...

Gal

09-02-2010 05:06 PM
John Bell

In our applications once in a while the commands don't get through to the SQL Server for different reasons. Since it is an automatic process there...

Gal

09-02-2010 04:47 PM
Erland Sommarskog

I am trying to use the BCP command to execute the following statement, but I keep getting the following error: Starting copy... SQLState = S1000,...

ironryan77

09-02-2010 04:39 PM
Erland Sommarskog

I'm looking for a small DBMS to hold one data table with 10 columns (one of them is the data - varchar(max) avg is 1000 chars) and another few...

Gal

09-02-2010 02:01 PM
Gene Wirchenko

Hi all, Q1: Is there a way to tell what version number a dbf file is? Q2: Where can I find a list of version #'s, ex, 621 = SQL...

kpg

09-02-2010 02:51 AM
John Bell

Hi, Is there a way to deal with invalid dates during a select? Currently I'm getting dates in a column in this format: 20100726 (yyyy/mm/dd) I need...

soni2926

09-01-2010 09:46 PM
Tom Cooper

Hi, first i must apologize for crossposting but i hope someone has a answer for this: I try to install this (the 64 bit variant on my Windows 7 64...

Kerem Gümrükcü

09-01-2010 06:21 PM
Kerem Gümrükcü

Here's the database: The database scheme consists of four tables: Product(maker, model, type) PC(code, model, speed, ram, hd, cd,...

Yue

09-01-2010 04:10 PM
John Bell

I want to filter on the primary server name using a query. Do you know if the value '1089' is always the srvstatus for the primary server? Thanks...

Mitchell_Collen via SQLMonster.com

09-01-2010 08:23 AM
Mitchell_Collen via SQLMonster.com

I'm doing initial tests with different aspects of performance using PAGE compression with SQL 2008 R2. I've noticed that rebuilding indexes using...

Mikael Sorensen

08-31-2010 04:35 PM
Erland Sommarskog

Hi all, I have a question about Master db in a DR environment. Our customer has follow environment setup: Live Site: SQL Server 2008 Standard DR...

Tao

08-31-2010 02:34 PM
John Bell

I would like to create two linked servers to the same data source. The first linked server has fairly open access to the database. The second...

LisaM

08-31-2010 10:54 AM
LisaM

SQL Server 2008 on Win2008 R2 x64 Server, 8 GB RAM - running virtualized on VMWare ES-Server Every sunday some maintainance jobs are scheduled to...

Bernd Maierhofer

08-30-2010 10:37 AM
Bernd Maierhofer