SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• query a column of xml files

  Hi, this problem perplex me for a long time, can you help me? I want to query a column of xml files…

  ertao0215

  2 replies

  11 years ago

  By: ertao0215

• Complexity of migrating data

  Hi All, can someone tell me the complexity of converting a MySQL Database into a MS SQL Database? I…

  LearningDBA

  1 replies

  11 years ago

  By: Eirikur Eiriksson

• give permission to someone

  Hi All, Any idea how to give permission to someone to access database in SQL server without using S…

  WhiteLotus

  3 replies

  11 years ago

  By: WhiteLotus

• Where SQL Server stores SSIS packages?

  I created an SSIS package (or something very similar to it) in SQL Server Import and Export Wizard …

  SQL Guy 1

  2 replies

  11 years ago

  By: SQL Guy 1

• Monitor Database Growth and if any DB is grown by 20%, sending mail alerts

  Hi Experts, Is there any automated script available to - "Monitor Database Growth and if any DB is …

  SQL_Hunt

  5 replies

  11 years ago

  By: SQL_Hunt

• Getting a stupid conversion error.

  Hi, I am trying to send an email alert when the dbgrowth >=20% Error 8115, Severity 16, State 6,…

  SQL_Hunt

  4 replies

  11 years ago

  By: SQL_Hunt

• Creating Primary Key on temporary table question

  All, Environment: Microsoft SQL Server Standard Edition (64-bit), 10.0.5520.0 I was doing a code re…

  jhager

  12 replies

  11 years ago

  By: spaghettidba

• Exclude Columns When Using Bulk Insert

  I'm able to successfully import data in a tab-delimited .txt file using the following statement. B…

  david.holley

  18 replies

  11 years ago

  By: Jeff Moden

• Tricky query issue

  Hello, Below is my sample data. I can't figure out how to select Unique phonenumber contacts for th…

  datsun

  2 replies

  11 years ago

  By: datsun

• SQL user password hash algorithm and salt value

  Hi All.. How to find hash algorithm and salt value for sql logins in sql server 2005.

  SQL!$@w$0ME

  7 replies

  11 years ago

  By: Mike C

• Trouble playing with dates

  i have trouble getting this to work properly: SELECT MONTH(Anniversaire) AS MM, DAY(Anniversaire) A…

  dany.fortier

  8 replies

  11 years ago

  By: dany.fortier

• Failed Task in Maintenance Plan Not Being Reported by Database Mail

  I have inherited a server on which is a maintenance plan with two subplans on different schedules. …

  lmarkum

  1 replies

  11 years ago

  By: lmarkum

• Move tables and SP from Master to user DB

  HI all, I just notice that my MASTER database has some user tables and user SP ( I have no idea who…

  WhiteLotus

  5 replies

  11 years ago

  By: ScottPletcher

• Running WinSCP in SSIS Task / .bat file

  All, I'm trying to call WinSCP in a SSIS Execute Process Task using a .bat file to automate. SSIS i…

  Brandie Tarvin

  24 replies

  11 years ago

  By: Brandie Tarvin

• Hi, first post! Interested in "Calls"

  Hello guys! What I am trying to do is create functions I can call sort of like programming, Ive res…

  rourrourlogan

  8 replies

  11 years ago

  By: MMartin1