Questions in topic: sql-server-2005 - SQL Server Q&A from the SQL Server Central community

Questions in topic: sql-server-2005

votes

answers

336

views

Sql 2005 Database Mail stopped working, what is happening ?

Nov 06 '12 at 08:28 AM Kev Riley ♦♦ 46.1k

sql-server-2005

votes

answers

239

views

Checking backup & Restore

Nov 05 '12 at 12:35 PM btcstore30 (suspended)

sql-server-2005

votes

answers

417

views

execute the below query

Nov 05 '12 at 12:35 PM btcstore30 (suspended)

sql-server-2005

votes

answers

1.5k

views

convert varbinary to varchar... it works in select statement but not update statement why?

Nov 02 '12 at 03:51 PM Usman Butt 13.8k

sql-server-2005 tsql performance nvarchar

votes

answers

405

views

About Fill Factor?

Nov 02 '12 at 03:50 PM KenJ 12.4k

sql-server-2005

votes

answers

249

views

Dimension table in wrong order

Nov 02 '12 at 02:08 PM Pavel Pawlowski 20.3k

sql-server-2005

votes

answers

282

views

SQL server 2005 with Win Server 2008

Nov 02 '12 at 09:46 AM Tim 31.5k

sql-server-2005 installation windows-2008

votes

answers

178

views

Modify the code for the desired output

Nov 01 '12 at 11:08 AM Fatherjack ♦♦ 38.8k

sql-server-2005 sql-server

votes

answers

215

views

How to add custom xml tags like in web.config in dtsconfig of SSIS 2005?,How to store custom tags in dtsconfig file for SSIS package in MSSQL2005?

Nov 01 '12 at 09:12 AM Harishpin 0

sql-server-2005 ssis mssql

votes

answers

872

views

hashbytes password update

Oct 30 '12 at 09:54 AM askmlx121 2.4k

sql-server-2005 tsql performance password

votes

answers

354

views

Update staticstics in sql server 2005?

Oct 30 '12 at 09:44 AM Sacred Jewel 1.6k

sql-server-2005 statistics query-plan selectivity

votes

answers

174

views

Disabling an AD account causing an audit trigger to fail

Oct 29 '12 at 12:23 PM Dave_Green 1.7k

sql-server-2005 ddl triggers

votes

answers

347

views

Is there any alternative for like operators - for searching data

Oct 29 '12 at 06:36 AM Pavel Pawlowski 20.3k

sql-server-2005 sql sql-server tsql

votes

answers

236

views

How is user variable added to Oracle sql expression used in SSIS variable

Oct 26 '12 at 01:30 PM paws27284 223

sql-server-2005 ssis

votes

answers

418

views

Sql server Stored procedure to execute the below query

Oct 24 '12 at 08:46 AM Valentino Vranken 1.4k

sql-server-2005 stored-procedures with-clause

votes

answers

125

views

I have scenario which login have permissions on which tables?

Oct 23 '12 at 05:33 AM narendba 480

sql-server-2005

votes

answers

405

views

Better way to write correlated subquery

Oct 22 '12 at 12:53 PM JohnM 4.5k

sql-server-2005 cte correlated

votes

answers

369

views

Category import with recursion and no cursor

Oct 22 '12 at 08:22 AM Fatherjack ♦♦ 38.8k

sql-server-2005 recursion

votes

answers

359

views

How can I do this without a cursor or loop?

Oct 19 '12 at 02:27 PM mjharper 768

sql-server-2005 cursor merge set-based upsert

votes

answers

228

views

Why does my add column, insert not work

Oct 19 '12 at 01:53 PM Fatherjack ♦♦ 38.8k

sql-server-2005 batch-seperator

votes

answers

512

views

Output from multiple identity inserts into another table

Oct 19 '12 at 01:36 PM Dave Morrison 302

sql-server-2005

votes

answers

203

views

sql server 2005 service sp4 upgrade

Oct 18 '12 at 12:49 PM Grant Fritchey ♦♦ 62.2k

sql-server-2005

votes

answers

277

views

SQL SERVER STORED PROC OPTIONAL PARAMETER

Oct 16 '12 at 05:33 PM tusharsnk 40

sql-server-2005

votes

answers

340

views

database size to 30 GB

Oct 16 '12 at 12:43 PM Blackhawk-17 10.5k

sql-server-2005 database

votes

answers

281

views

when new dabase created how can I gave the access permission to all users in server?

Oct 16 '12 at 07:44 AM DirkHondong 1.3k

sql-server-2005 server

votes

answers

292

views

upgrade or buy new?

Oct 15 '12 at 08:50 PM Fatherjack ♦♦ 38.8k

sql-server-2005 server

votes

answers

209

views

database roles and server roles

Oct 15 '12 at 03:16 PM Fatherjack ♦♦ 38.8k

sql-server-2005 database permissions

votes

answers

298

views

Error formatting query

Oct 12 '12 at 01:18 PM sand143eep 541

sql-server-2005

votes

answers

275

views

providing the value automatically

Oct 12 '12 at 11:39 AM sand143eep 541

sql-server-2005

votes

answers

344

views

sql users and passwords

Oct 12 '12 at 08:54 AM Phil Factor 3.2k

sql-server-2005 password

votes

answers

673

views

using if condition in select statement

Oct 12 '12 at 08:54 AM sand143eep 541

sql-server-2005

votes

answers

378

views

What is wrong with this Update SQL command

Oct 12 '12 at 06:22 AM eghetto 1.5k

sql-server-2005 update

votes

answers

349

views

was that a hack attempt

Oct 11 '12 at 05:42 PM TimothyAWiseman 14.3k

sql-server-2005

votes

answers

245

views

open view

Oct 10 '12 at 10:58 AM Grant Fritchey ♦♦ 62.2k

sql-server-2005 views

votes

answers

263

views

Shrinking issue

Oct 09 '12 at 12:59 PM ThomasRushton ♦ 29.4k

sql-server-2005 tempdb shrink-database

votes

answers

337

views

query related to split function

Oct 09 '12 at 12:46 PM tsaliki 140

sql-server-2005 split

votes

answers

322

views

help to Display the table in html format using sql server

Oct 05 '12 at 01:05 PM Fatherjack ♦♦ 38.8k

sql-server-2005 stored-procedures html

votes

answers

345

views

Temp db size drastically increased

Oct 05 '12 at 10:27 AM Tim 31.5k

sql-server-2005

votes

answers

1.4k

views

Move tempdb

Oct 03 '12 at 05:46 PM Blackhawk-17 10.5k

sql-server-2005 tempdb system-databases

votes

answers

272

views

If the servers will changes to RTM(sql server 2005) to SP2, What are the advantages will get?

Oct 03 '12 at 12:50 PM K. Brian Kelley 933

sql-server-2005

votes

answers

347

views

How should I avoid this deadlock?

Oct 02 '12 at 11:35 AM Grant Fritchey ♦♦ 62.2k

sql-server-2005 sql-server-2008 sql-server-2008-r2 deadlock locking

votes

answers

370

views

Merge Replication 2005 - Add article to existing Publication

Sep 28 '12 at 01:23 PM Newbie Bala 293

sql-server-2005 merge-replication add articles

votes

answers

149

views

creating an index on aperticular query

Sep 27 '12 at 05:26 PM TimothyAWiseman 14.3k

sql-server-2005

votes

answers

210

views

Help with cube operator

Sep 27 '12 at 11:36 AM Kev Riley ♦♦ 46.1k

sql-server-2005 cube

votes

answers

347

views

Is there any impact to tempdb if we run checkdb on 800GB database?

Sep 27 '12 at 10:26 AM DirkHondong 1.3k

sql-server-2005

votes

answers

1.4k

views

SQL job failure due to timeout

Sep 27 '12 at 07:57 AM Kev Riley ♦♦ 46.1k

sql-server-2005 database timeout-expired jobs timeout

votes

answers

238

views

SQl server stored procedure help

Sep 26 '12 at 04:45 PM DirkHondong 1.3k

sql-server-2005 stored-procedures html

votes

answers

587

views

SSIS [2005/2008] plugins for Visual Studio 2010

Sep 26 '12 at 01:39 PM JohnM 4.5k

sql-server-2005 sql-server-2008 ssis visual-studio-2010

votes

answers

296

views

SSIS Connection Managers not connecting in debug

Sep 25 '12 at 07:07 PM paws27284 223

sql-server-2005 ssis

votes

answers

162

views

Get Average amount for different type

Sep 24 '12 at 11:46 AM Grant Fritchey ♦♦ 62.2k

sql-server-2005

1834 questions

3351answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags