Hi, I'm using MSSql Server 2005. My client is Oracle SQL Developer on Mac 10.6.3. My problem is that I'm trying to get the execution plan for...

laredotornado

07-21-2010 04:38 PM
Erland Sommarskog

Hi all, i found that the sql server cluster failover from node A to node B slow i saw the cluster log show below error, and we haven't set the...

ken

07-21-2010 02:02 AM
ken

I need to send emails to locations which come up in the query SELECT ,,,, FROM ' , each location shud get there own information emailed to...

dtrivedi

07-20-2010 03:47 PM
John Bell

Hello, I am looking for a way how to select field value, if the table and field name both are available as string parameters. I am aware that in SP...

Passiday

07-20-2010 03:32 PM
John Bell

Just curious if any of you run/have run SQL Server in a virtual environment and what your opinion is on doing so?

Matthew

07-20-2010 03:03 PM
Matija Kapraljevic [Revenger]

Does anyone know a free program that will repair coruppted sql databases (mdf files)? All I see on the net is paid ones. Thanks Dave

DCR

07-19-2010 10:37 PM
DCR

erver windows 2003 sp1. 64 bits, Paging file size for selected drive C is (custom selected) Initial 2046 MB, and maximum 4092 MB. It is currently...

DoleBludger

07-19-2010 04:46 PM
Erland Sommarskog

Please suggest me what kind of data type can I use in SQLServer that supports numbers whith two decimal digits. Thanks LAM

LAM

07-19-2010 03:21 PM
Gert-Jan Strik

SQL Express 2008 When attempting to attach a db I can only see a path of user/username and then the mdf has to be in that folder. I'd like to...

SAC

07-19-2010 02:25 PM
John Bell

Is there a simple way of determining the actual T-SQL being executed in the current transaction_id? The code below displays the active...

Rubens

07-19-2010 01:36 PM
Rubens

We seem to have hit an oddity. We have a stored procedure that gets the next sequence number. It is protected by a transaction so no two processes...

RG

07-19-2010 09:56 AM
Jeroen Mostert

Hi guys. On a previous project, the requirement was just to store who updated a row, and when. So, we have a: created_date, created_user_id,...

Craig Lister

07-19-2010 03:44 AM
Erland Sommarskog

Hello, Here's the strange thing: I can't see how to order text in Latvian language alhabetically, respecting the order of the special...

Passiday

07-18-2010 12:08 AM
Michael Kaplan

Hi, I wrote a stored procedure that is fed values via a table stored in a particular database on one of our SQL server environments. The values...

jam772

07-17-2010 01:44 AM
Jeroen Mostert

Hello, We've had performance issues with our server. We typically get 'insufficient resources' error and eventually wind up rebooting the...

Peter Capazzi

07-16-2010 04:42 PM
Erland Sommarskog

I have a SQL 2008 x64 Standard server with 16GB of memory. The database on this server is using almost of of this memory. The database is 35GB. ...

John

07-16-2010 09:42 AM
John

When an index is rebuilt are: (1) statistics updated on the index during the rebuild process, or (2) is a flag set so that when the index is used...

cbrichards via SQLMonster.com

07-16-2010 03:45 AM
Erland Sommarskog

Hi, I am sure there is a way that you can have a query that effectively takes two separate tables that have the identical column layout and add...

Siv

07-15-2010 04:47 PM
Erland Sommarskog

Hello, Goal: Find the row with the highest of lowest value (can be with extra conditions). Example 1 find the row with the highest value. Example...

ben brugman

07-15-2010 04:43 PM
Erland Sommarskog

Hi. Let I have a table with the following rows ERP No. Name Code 5585 John 097 5585 John 098 5585 John 701 12210 Tom 153 12210 Tom 154

Muhammad Bilal

07-15-2010 04:32 PM
Erland Sommarskog

A stored procedure running from server A database db1 updates both local tables, as well as, remote ones, on server B database db2 via a db link. ...

RG

07-15-2010 04:30 PM
Erland Sommarskog

Problem: How can I access SQL server on...

SAFEKOM

07-15-2010 04:25 PM
Erland Sommarskog

after i upgraded from SQL 2008 to R2, the reporting service no longer start and with error "Default appdomain failed to initialize". I tried to...

CK

07-15-2010 04:17 PM
Nick Tyrrell

I have serveral database servers with SQL Server 2005 and SQL Server 2008 when I create the maintenance plan to delete backup files older than 5...

Joe K.

07-15-2010 10:38 AM
Siv

Hello: We have two database integrity checks jobs in SQL 2005 that are failing. One job is for our financial app databases, while the other is for...

SQL Programmer

07-15-2010 03:25 AM
Erland Sommarskog

When I'm trying to rename a table in the tempdb table, I'm getting an error when I run it in a stored procedure or code, but it works ok on MSSMS. I...

Cindy Lee

07-14-2010 05:03 PM
Erland Sommarskog

Hi All, we found that the sql server can't connect and the log show below message, but we haven't do any shutdown action before, but the physical...

ken

07-14-2010 03:55 AM
Erland Sommarskog

hi, I am having 2 logins from my domain. one is normal user and another one is domain admin. domain admin is in ITAdmins group, which have SQL...

John

07-14-2010 02:02 AM
Steen Schlüter Persson

still learning of the sql command HOW TO DISABLE XP_CMDSHELL AND DISABLE BOTH MAIL PROCEDURES

DD

07-14-2010 01:51 AM
DD

Hello, after completing the Mainentance Plan wizard in which the Integrity Checks and Transaction Log Backup job fail I came across...

.

07-13-2010 05:19 PM
Erland Sommarskog

I am running 2003 Server and I require the SQL Server 2005 service to use a specified AD user account (named SQLUser), when I edit the service...

Davey

07-13-2010 01:52 PM
Dave Bishop

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: " Database Workbench 4.0.3...

Martijn Tonies

07-13-2010 09:03 AM
Martijn Tonies

Hi I'm using the following expression to join two text fields where one of them should be null: table1.name1 & ' ' & isnull(table1.name2,'') as...

LuisM

07-13-2010 08:04 AM
LuisM

What is the name of that disk I/O tool?

Jay

07-13-2010 03:47 AM
Erland Sommarskog

All, I am a sql newb and in a bind and all out of ideas at the moment but I was thrown into figuring a query out to report back what my manager...

sqlnewb

07-12-2010 04:23 PM
John Bell

Please, can somebody help with issue: SQL Standart server 2005 can't see my local folder ? I restarted the server, changed letter but nothing...

Marek Zaremba

07-12-2010 01:42 AM
Marek Zaremba

I ran “select * from sys.certificates” in our Central Management Server. Most of them have this set of certificates that are created...

todwith1d

07-09-2010 04:51 PM
John Bell

I installed a network printer on my 2008 server R2 64 bit. When i go to share it out i get the following error message Printer settings could not...

Jason Marino

07-09-2010 02:51 PM
Erland Sommarskog

Hi! On my own sqlDB, I need to link tables form other sqlDB in the same machine and then, create views that combine fields of my own tables and...

LAM

07-09-2010 02:51 PM
Erland Sommarskog

Hello, Could someone please direct me to a page/url/pgNo in BOL/etc.. which contains information on the following: A list of all the possible...

sqlcatz@hotmail.com

07-09-2010 09:06 AM
sqlcatz@hotmail.com

I have one server with common data that when inserted, updated, or deleted I am sending to the change to 4 seperate instances. I have one database...

ThorSG1

07-08-2010 04:21 PM
ThorSG1

Is SQL 2005 SP3 32 bit compatible with Windows 2008 R2? Fails every time i try the install. Thanks

Tammyh

07-08-2010 04:03 PM
Erland Sommarskog

Alberto (assistenza (AT) adb (DOT) it) writes: That looks bad. You would have to contact Microsoft support to get an analysis of this dump. But I...

Alberto

07-08-2010 03:57 PM
Erland Sommarskog

I use the ssms gui for table creation most of the time; ie, I right click the tables entry, select "new table", and add the columns in design view....

mat

07-08-2010 03:45 PM
Erland Sommarskog

Hello, I am running a script against a list of SQL Servers using a DOS Batch file. The .bat generates one output file per SQL Server instance. I can...

Ada

07-08-2010 03:21 PM
Ada

Sql 2005 Standard Ed. 64 bit installed on Windows 2008 64 bit server standard SP2 Creating Maintanance Plan, I obtain errors: Stato Creazione...

a

07-08-2010 10:41 AM
a

Does anyone know of a way to move all objects in a db from schema dbo to another schema?

mat

07-08-2010 05:38 AM
Erland Sommarskog

Hi All, I would like to ask if there is a specific ID for each server or at least for each instance? I would like to use it like @@nodeid (which i...

schaf

07-08-2010 01:26 AM
schaf

Hi. Let Create table #temp1(erpnbr int, svpname varchar(50), dcode char(3), ucode char(3)) Create table #temp2(nbr char(13)) Insert into #temp1...

Muhammad Bilal

07-07-2010 11:52 PM
Ahmad Bilal

I have this simple table: ID------DATE------- 1----2004-08-02 12:30:AM---- 2----2004-08-03 4:30:AM---- 3----2004-10-17 9:30:AM---- 4----2004-08-02...

aleem510

07-07-2010 11:50 PM
aleem510 via SQLMonster.com