Ask SQL Server Central

0

votes

2

answers

26

views

sp_getschemalock is causing the lock of database servers

database blocking

1h ago Community♦ 1●2

1

vote

1

answer

31

views

clarification to answer for todays TSQL question

t-sql

4h ago Kev Riley♦ 1,862●1●10

0

votes

1

answer

8

views

Problem dropping full-text catalog

sql-server-2005 full-text

4h ago Kev Riley♦ 1,862●1●10

1

vote

1

answer

33

views

System Databases affected when upgrading from SQL 2000 to SQL 2008

sql-server-2000 upgrade sql-server-2008

7h ago Steve Jones - Editor♦ 2,074●9

1

vote

3

answers

40

views

SQL Update using variables

sql-server vb

7h ago Melvyn Harbour♦♦ 949●3●9

1

vote

0

answers

9

views

Profiler and broken client connections

performance sql-server-2008 profiler

7h ago Kev Riley♦ 1,862●1●10

1

vote

3

answers

34

views

Data-Reader needs to create views

data-reader view t-sql

9h ago unknown (google) 29●3

1

vote

1

answer

24

views

how can we use “Select into” statement with a newly declared table(Stored procedures)

stored-procedures t-sql

10h ago Melvyn Harbour♦♦ 949●3●9

4

votes

1

answer

24

views

SVN and SQLServer

version-control svn tortoisesvn

10h ago Melvyn Harbour♦♦ 949●3●9

2

votes

3

answers

47

views

Nightly Restore from SQL 2000 to SQL 2005

oltp olap sql-server-2000 sql-server-2005

12h ago Kev Riley♦ 1,862●1●10

0

votes

1

answer

37

views

SQL server login problems on reboot

sql-server-2005 sql-server-express

12h ago Kev Riley♦ 1,862●1●10

0

votes

1

answer

45

views

Execution plan or client statistics?

t-sql sql-server-2005

12h ago Kev Riley♦ 1,862●1●10

2

votes

3

answers

56

views

Query to check which edition and version of Sql Server 2005 is installed?

sql-server-2005

12h ago Kev Riley♦ 1,862●1●10

0

votes

5

answers

73

views

Updating an index with -1 or 9999, what is faster ?

performance t-sql sql-server-2005

12h ago Kev Riley♦ 1,862●1●10

0

votes

2

answers

68

views

Can I log ship from SQL Server 2000 to SQL Server 2005?

sql-server-2005 sql-server-2000 log-shipping disaster-recovery

12h ago Kev Riley♦ 1,862●1●10

2

votes

1

answer

40

views

Input Parameter for Stored Proc in Execute SQL Task 2008

stored-procedures sql-server-2008

12h ago Kev Riley♦ 1,862●1●10

0

votes

2

answers

8

views

Why do I get SQLSetConnectAttr Failed errors?

error-message sqlsetconnectattr

13h ago David Wimbush 146●5

0

votes

1

answer

10

views

Why does EM crash when I get an error in a stored procedure?

enterprise-manager stored-procedures

13h ago David Wimbush 146●5

1

vote

1

answer

16

views

Why does sp_spaceused return inaccurate values?

sp-spaceused

13h ago Tom Staab 1,546●1●9

4

votes

5

answers

87

views

How can I make my SQL queries case sensitive?

case-sensitive-sql-query

13h ago Anthony Osborn♦♦ 141●3

0

votes

2

answers

22

views

Problem executing sproc which calls an assembly within SQL

sql-server-2005 .net

14h ago Colin W 1

1

vote

4

answers

29

views

SQL 2008 DB on 2005 - running slowly

sql-server-2008

14h ago David Wimbush 146●5

2

votes

1

answer

32

views

SQL 2008 Standards

sql-server-2008 installation security maintenance

14h ago David Wimbush 146●5

0

votes

1

answer

14

views

Transaction hanging in SQL Server 2008 running on Windows Server 2003

sql-server-2008

15h ago Matt Whitfield♦ 3,237●1●9

1

vote

2

answers

24

views

Dateadd, update only from 27th of last month

query

15h ago Kev Riley♦ 1,862●1●10

1

vote

3

answers

19

views

How to automate the rendering of Reports to PDF

sql-server-2008

15h ago dave ballantyne 294●4

1

vote

4

answers

36

views

What are the alternatives to xp_cmdshell?

xp-cmdshell

20h ago KenJ 461●1●3

3

votes

13

answers

190

views

The ‘Word Permutation’ SQL Problem

challenge

22h ago Scot Hauder 1●1

0

votes

1

answer

16

views

SSIS - using variable to input into a column when loading flat file

ssis variable

1d ago Kev Riley♦ 1,862●1●10

1

vote

1

answer

12

views

SQL 08 Agent PowerShell job fails: “Logon failure: unknown user name or bad password”

sql-agent sql-server-2008

1d ago Blackhawk-17 795●1●9

0

votes

2

answers

18

views

Stop cube processing

cubes ssas sql-server-2008

1d ago Raj More 499●7

1

vote

1

answer

19

views

Identifying orphaned users

t-sql sql-server-2008 deprecated

1d ago Tom Staab 1,546●1●9

1

vote

0

answers

13

views

How to best use SQL Server Best Practices Analyzer?

best-practice

1d ago Jim Orten 223●4

1

vote

1

answer

16

views

How do additional files fill?

filegroup

1d ago TimothyAWiseman 902●8

1

vote

3

answers

37

views

Server role of public trumps db_owner and prevents SSMS from displaying database list?

ssms permissions sql-server-2008 security

1d ago MGS 1

2

votes

3

answers

52

views

SQL 2008 Logs Strange Message

sql-server-2008 sql-server-log

1d ago Håkan Winther 1,217●9

2

votes

1

answer

23

views

SQL Log : AppDomain unloaded

sql-server-2008 administration sql-server-log clr 64-bit

1d ago Håkan Winther 1,217●9

2

votes

1

answer

31

views

How does the Query Engine know how to order via newid()

t-sql query

1d ago Håkan Winther 1,217●9

1

vote

5

answers

49

views

Resetting ‘Log on as’ problems

sql-server-2008 permissions user

1d ago Matt Whitfield♦ 3,237●1●9

1

vote

1

answer

14

views

problem with information_schema.VIEW_TABLE_USAGE

sql-server-2008

1d ago Melvyn Harbour♦♦ 949●3●9

5

votes

5

answers

51

views

Which row-versioning transaction isolation level do you use?

transaction isolation-level row-versioning sql-server-2005 sql-server-2008

1d ago Melvyn Harbour♦♦ 949●3●9

1

vote

3

answers

44

views

How do you run a trace to grab the TSQL query that is using a specific index

sql-trace indexing profiler

1d ago Melvyn Harbour♦♦ 949●3●9

1

vote

2

answers

49

views

SQL 2005 Server with Client Connections using SQL 2000 client

sql-server-2005 performance client-tools

1d ago Community♦ 1●2

6

votes

5

answers

70

views

Stored procs with sp_ prefix

stored-procedures sql-server-2005

1d ago David Wimbush 146●5

1

vote

4

answers

33

views

Entity RelationShip Diagram

t-sql database-design sql-server-2008 existing-table erd

1d ago Kev Riley♦ 1,862●1●10

1

vote

2

answers

45

views

SSIS data flow causing system assertion

ssis sql-server-2008

1d ago Community♦ 1●2

0

votes

3

answers

48

views

How often does the front end interact with the database?

python gui performance pyodbc odbc

1d ago TimothyAWiseman 902●8

3

votes

4

answers

41

views

Any way around the PRINT limit of nvarchar(max) in SSMS

ssms t-sql

2d ago TimothyAWiseman 902●8

Recent Questions

Looking for more? Browse the complete list of questions, or popular tags. Help us answer unanswered questions.

Welcome to ask SQL Server Central

Recent Tags

Recent Badges