SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• how to insert DBNnull into binary column via parameter list?

  The table was created using the following script: CREATE TABLE [USERS] ( [USER_PASSWORD] binary(100…

  j2bmw

  2 replies

  15 years, 5 months ago

  By: j2bmw

• Fibre Channel vs NFS for Data and Log files

  Anyone out there have any experience or opinions on Sql Server 2008 performance and stability when …

  gianmh

  8 replies

  15 years, 5 months ago

  By: Steve Jones - SSC Editor

• oledb provider not registerd error

  SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\test1.xls;IMEX=1','SELEC…

  jamessdba

  3 replies

  15 years, 5 months ago

  By: jamessdba

• How To Audit All DBA Actions

  Can anyone please point me towards server & DB audit spec scripts that will let me cover off a…

  nzrdb6

  4 replies

  15 years, 5 months ago

  By: Steve Jones - SSC Editor

• xp_cmdshell disabled after reboot

  I have a SQL Server 2008 STD server that has xp_cmdshell enabled for a vendor process. Whenever th…

  Road Kill

  3 replies

  15 years, 5 months ago

  By: Road Kill

• Need help combining separate date / time fields

  Hello, I have a table with a date in one field, and time in another. I need to combine these into …

  Sector7G

  4 replies

  15 years, 5 months ago

  By: WayneS

• Connect to SQL Server using I/P address in SSMS

  Hi All, I have 2 instances of SQL Server installed on my desktop Instance1 name being default and I…

  RaviShankar1234

  10 replies

  15 years, 5 months ago

  By: Perry Whittle

• Is it possible to convert decimal format data directly to datetime without converting to nvarchar first?

  I'm getting data from an external source that comes in with dates in decimal format. Sample data…

  caspersql

  2 replies

  15 years, 5 months ago

  By: Stefan_G

• Using an SQL instance IP to RDP a server box?

  I believe I am confused. How could it be? But it is there. Does anyone know when we need this kind…

  SQL ORACLE

  8 replies

  15 years, 5 months ago

  By: subhash.pant

• Testing before upgrading to Compatibility Level 100 (SQL 2008)

  Few weeks back we successfully upgraded the database from SQL 2000 to SQL 2008, however the compati…

  joshivaibhav

  3 replies

  15 years, 5 months ago

  By: Ron McCullough

• Creating reports for SSIS packages

  I want to create reports which list the results of SSIS packages in SQL 2008. The reports would in…

  David.Parks

  2 replies

  15 years, 5 months ago

  By: @SQLFRNDZ

• SQL Server 2008 DML Auditing

  Hi, I am trying to know if the new feature of Auditing in SQL Server 2008 includes column changes a…

  Ajdba

  2 replies

  15 years, 5 months ago

  By: Ajdba

• Query Grouping on multiple fields

  Hi I want to write a query which will allow me to see the age of particular item in particular dept…

  HakunaMatata

  6 replies

  15 years, 5 months ago

  By: HakunaMatata

• Inserting the File Name into a column,

  I have a package that loads multi flat files from a directory. Each file is named "Business Area -…

  David.Parks

  5 replies

  15 years, 5 months ago

  By: WayneS

• Script to insert all columns' name into a table

  How to create a Script to insert only columns' name of one table into another table?

  adonetok

  5 replies

  15 years, 5 months ago

  By: Lowell