Hello Hopefully a really simple question. We have just finsihed a SQL 2005 database and vb.net app. We have been using SQL server 2005...

Kerrin Banner

08-10-2008 11:48 PM
nidaar

Is there a table or structure that contains information that I can see via the Activity Monitor? I've searched the msdb database and I've not found...

rcamarda

08-10-2008 01:48 PM
Erland Sommarskog

I need to give one functionality in my application as applicationl lock. If my databsae is get lock at the time of backup, i need to give a message...

Manoj saini

08-08-2008 01:31 PM
Roy Harvey (SQL Server MVP)

Is there a way to write the information that appears in the "Messages" window in SQL Server Management Studio to an external log file? I'd like to...

Hermes

08-07-2008 04:23 PM
Erland Sommarskog

I cannot update the blobs correctly with mysql. I exported 3 rows from db2 to mysql database. There are blobs in the database. db2 display the 3...

Mary Lei

08-06-2008 04:10 PM
Erland Sommarskog

By Jenny Eagle , August 6th 2008 02:45PM Business Intelligence developer, Yellowfin, has taken two mature technologies - BI and GIS - and combined...

Yellowfin

08-06-2008 12:06 AM
Yellowfin

I've a query which happily returns a full set of data when run in SQL Studio but when I do the same query using IIS with Classic ASP connected via...

woakesd@googlemail.com

08-05-2008 04:20 PM
Erland Sommarskog

Hi, I'm new to Triggers, so forgive the elementary question. We have a process that saves data from a VB2005 form into a table in MS SQL 2005, and...

Alex

08-05-2008 01:57 PM
--CELKO--

Hi. I have a Dell Server with Windows 2003 R2 SP2 64bit ,SQL Server 2005 SP2 (also 64Bit) and 12GB Ram. The Problem is, that the SQL Server Process...

Ulf Dingler

08-05-2008 12:22 AM
Ed Murphy

Hi All, Certification in Mind??? Visit www.itjobguru.com for Latest Material. Regards, Naveen

Naveen

08-03-2008 01:50 PM
Naveen

Hello everyone. Hope someone can help. I have a table with two columns Material Number and Material Description. Sample data below: Material# ...

eighthman11

08-02-2008 03:18 AM
Erland Sommarskog

Hi, I am migrating SQL 2000 database from one machine to another using the detach/attach method. I used the TSQL script sp_help_revlogin procedure...

thaixyz@gmail.com

08-01-2008 04:25 PM
Erland Sommarskog

Hello to all, I have a small or big problem with a customer data base, where during a change of system we might have created duplicate records. This...

Thomas Arthur Seidel

08-01-2008 02:07 PM
Thomas Arthur Seidel

I'm using the DTS tool (generally called "Import and Export Data", two cogs) to export a table to a text file. However, it seems to be truncating...

Jim

08-01-2008 03:58 AM
Jim

I'm guessing the answer is 'no', but I thought I'd ask. Basically we have a client where it looks like someone has issued a DROP TABLE command - or...

Jim

08-01-2008 01:01 AM
Jim

Is there a way in SQL Server T-SQL to store commonly used SQL statements in a function, stored proc, or system variable? That way if that code ever...

jduhler@hotmail.com

07-31-2008 04:47 PM
Erland Sommarskog

Does anyone know how to export from SQL 2000 to Excel but exclude the header row containing column names? Thanks.

Artie

07-31-2008 11:06 AM
Artie

From a security point of view, is accepting wildcards like "%" in input parameters of stored procedures against any best practices? As an example,...

nidaar

07-31-2008 02:44 AM
Eric Isaacs

Hi all. I have this data: id GroupId DDate Value 1 1 7/31/2008 ...

Lemune

07-30-2008 10:20 PM
Lemune

Construyelo fácil y rápido. http://www.softclarity.com.ar/Builder

infoddf

07-30-2008 09:33 AM
infoddf

Hello, i have a problem using aliased column. I have the following query: With masids AS ( select masID, dbo.concat_friendly(masIDFrom) as...

Jan Hudecek

07-29-2008 10:44 AM
--CELKO--

I have an SQL Server 2005 database that is populated with a customer's data. I want to create a new database, in exactly the same format, so that I...

Andy Baker

07-28-2008 10:46 AM
Andy Baker

I have been using SQL Server 2005 for a total of 2 days and am trying to transfer table data from one server to another. For whatever reason the...

FutureShock

07-27-2008 11:52 AM
FutureShock

For files saved in source control, is it better to use code to DROP/ CREATE a procedure like...

semaj.remle 'at' gmail

07-25-2008 06:28 PM
Eric Isaacs

Jaros³aw Kozik (jkozik (AT) op (DOT) pl) writes: I'm sorry, but I don't understand what you are trying to achieve. Could you clarify? -- Erland...

Erland Sommarskog

07-25-2008 10:28 AM
dvdtknsn

I have set up a trigger that updates a table in another part of may database whenever a row is deleted - of the form CREATE TRIGGER t_Delete ON...

Andy Baker

07-25-2008 02:53 AM
Andy Baker

Intrusion Detection Strategies ----------------------------------- Until now, we’ve primarily discussed monitoring in how it relates to intrusion...

origami.takarana@gmail.com

07-24-2008 09:09 AM
origami.takarana@gmail.com

I've tried for hours... and my issue is this: Table 1 has FirstName, LastName, Address, Birthday, (and other columns) Table 2 has FirstName,...

Brian

07-21-2008 08:07 AM
Roy Harvey (SQL Server MVP)

how do i find out what process could have caused a transaction log to fill up possibly over hte last 24 or 48 hours? thanks in advance

lark

07-21-2008 06:47 AM
lark

Hi, I'm trying to use the result from the select within the same query. See code SELECT accountnum, char(ASCII(SUBSTRING(accountnum, 1, 1)))...

Dean g

07-21-2008 04:09 AM
Dean g

Dear ladies and gentlemen, Upscene Productions is happy to announce the next version of their test data generator tool: "Advanced Data Generator 2"...

Martijn Tonies

07-21-2008 02:43 AM
Martijn Tonies

I have a SQL Server 2000 SP4 Enterprise Edition with Build 8.00.2039. OS: Microsoft Windows Server 2003 Ent. SP2. 6GB Ram and AWE is enabled for SQL...

Query Builder

07-20-2008 07:41 PM
TheSQLGuru

For those that aren't familiar with SNL it's 'Saturday Nite Live'. It's a tv show that parodies celebrities, politicans, social behavior etc....

steve

07-19-2008 04:13 PM
Erland Sommarskog

Running MSDE 2000 SP2 on Windows XP SP3. I have a T-SQL script that is relatively simple (adding constraints, inserting rows, etc.) and short (maybe...

Larry Leonard

07-18-2008 04:10 PM
Erland Sommarskog

I'm new to SQL but not Excel I was given a Excel spreadsheet with Employee names. I have a large database with a Personal Table with Employee names...

Ty

07-17-2008 03:28 PM
Erland Sommarskog

I am trying to perform the following query on a table that has been indexed using Full Text Search. The table contains multiple columns than have...

Sham

07-16-2008 08:55 AM
nidaar

Salve a tutti, vorrei passare un progetto con un database piuttosto ricco di tabelle e dati in MSSQL senza troppi problemi e senza spendere un...

PadovaBoy (ovvero Giovanni)

07-16-2008 01:53 AM
PadovaBoy (ovvero Giovanni)

Find the latest updates in SQL server tools and techniques. More details on database management, software testing, flow chart prepartation and many...

surana

07-15-2008 07:59 PM
surana

Folks, I have 3 loosely linked problems which I am would appreciate feedback on. 1). T-Sql and Active directory roles. We want to be able to...

Tim

07-15-2008 04:47 PM
Erland Sommarskog

Hi I have visual Studio 2008. I was told to install SQL Server before Studio. But as it was too late. I decided to uninstall SQL server and re-boot....

Des

07-15-2008 01:53 PM
Helmut Woess

For a table of about 15 columns, is it all not nullable with default values better performance or some are nullable and some with default values. ...

DL

07-15-2008 03:29 AM
Erland Sommarskog

Folks, I'm trying to format a print string so that it reports progress whilst processing a looping structure with a date time stamp appended to...

Tim

07-15-2008 03:17 AM
Tim

Hi, I'm not familiar with backup procedures of SQL Server (i'm used to make simple file copies when no body works) and i have now the...

Gilles Nambert

07-14-2008 06:23 AM
Erland Sommarskog

DBC ensuring your applications don't fail due to a missing database structure object.DBC (Database Compare) is a fast, comprehensive database...

dingo

07-13-2008 10:46 PM
dingo

Hi .. i am trying to update a table where if field contents any duplictaed entries than one of the field should be updated with random number which...

php_mysql_beginer911

07-13-2008 05:59 PM
Erland Sommarskog

hello, just joined the group, i've run into a wall and am seeking some help. here is my query: SELECT DATEPART(year, TTmain.TTDate) AS...

Joe C.

07-11-2008 11:36 AM
Joe C.

DBC (Database Compare) is a fast, comprehensive database structure and data comparison tool.Sort sync scipts with database...

dingo

07-11-2008 05:16 AM
dingo

Hi, i want to use the DBGEN and QGEN on Windows XP. Can i do that, or i just can compile the tools on Unix? I am looking forward for your...

Nick

07-11-2008 12:30 AM
Nick

All, I am far from expert with SQL and have been unable to solve the following problem (stated in generic terms): I have three tables: 1. Employees...

jwwarrenva@gmail.com

07-10-2008 05:17 PM
Erland Sommarskog

Hi, I'm in the process of moving a database from a server running Windows 2000 SP4 to a PC running XP SP2. Basically, here's what I've managed to do...

Daniel Ngu

07-10-2008 05:15 PM
Erland Sommarskog