SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Can't query remote database from SSMS

  In SSMS I have connected to the remote server (SQL 2000 over a WAN)- it's in the Object Explorer wi…

  Caruncles

  11 replies

  14 years, 10 months ago

  By: Caruncles

• In SSIS, can I write the value of a variable to a SQL table?

  This seems like it should be easy to do, but I can't figure it out. In my Control Flow I have an Ex…

  jpSQLDude

  4 replies

  14 years, 10 months ago

  By: Evil Kraig F

• How to retrieve Image file from a SQL Table

  Hi, How can we retrieve the Image data stored in a SQL table? Can we view it as image without usin…

  srivivek84

  3 replies

  14 years, 10 months ago

  By: Lowell

• the account to create database

  As a dba, when you create database on production server, what account do you usually use? user sa a…

  sqlfriend

  14 replies

  14 years, 10 months ago

  By: Jeffrey Williams

• Create a new field in between two other existing fields

  Is it possible to create a new field in between two existing fields by using T-SQL? For eg: CREATE…

  C.K.Shaiju

  6 replies

  14 years, 10 months ago

  By: ben.reese

• db_datareader

  Hi I have a login with db_datareader and nothing else however I was quite suprised to find I could…

  Sarah 38992

  1 replies

  14 years, 10 months ago

  By: Lowell

• Would you run SQLIO on a production server?

  I have been hired in order to evaluate and troubleshoot some performance issue on a 2008 SQL server…

  gnobile15200

  5 replies

  14 years, 10 months ago

  By: Perry Whittle

• Queries executed in particular time

  If i need to find which queries have run on the database in a particular time period lets say 3 pm …

  Anam Verma

  3 replies

  14 years, 10 months ago

  By: Gail Shaw

• Restore SQL 2000 Database on SQL 2008 and consolidate 5 mdf files

  Hi, I'm trying to restore a SQL 2000 database on a SQL 2008 server. However, this SQL 2000 databas…

  Roger Abram

  4 replies

  14 years, 10 months ago

  By: Michael Valentine Jones

• database file size

  I got an alert about one of our databses mdf file is 96% full. The database is setup to auto grow, …

  sqlfriend

  4 replies

  14 years, 10 months ago

  By: Grant Fritchey

• SUM and ROUND functions

  Hi FOLKS IM HAVING BOTHER WITH THIS LINE OF CODE..I NEED IT SET TO 0 DECIMAL PLACES?.. select ROUND…

  normanshongo2003

  6 replies

  14 years, 10 months ago

  By: normanshongo2003

• Password policy enforcement

  Hi Hope someone can help me out here. I need to ensure that password policies are not enforced when…

  MickyD

  1 replies

  14 years, 10 months ago

  By: John Mitchell-245523

• Failed attempt at using shortcutting to produce efficient query

  I've spent the last few hours trying to get the second query below to complete without doing any di…

  waxingsatirical

  3 replies

  14 years, 10 months ago

  By: waxingsatirical

• How to find the collation an index was built with

  Hi, I am doing some sanity checking of our database build scripts, I need to make sure that the co…

  ben.reese

  8 replies

  14 years, 10 months ago

  By: ben.reese

• Data Structure for Date Scheduling

  I'm building an application to manage meetings held by a number of project teams. I'm now at the st…

  webskater

  2 replies

  14 years, 10 months ago

  By: webskater