SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Import from excel; Why can I import using wizard and not using sproc?

  So I've tried to run the following code and get the error below: SELECT * FROM OPENROWSET('Microsof…

  Jamez36

  2 replies

  13 years, 11 months ago

  By: Jamez36

• SSAS Calculated member with filter

  Dear All, There was a created member in a SSAS cube which basically calculates the % of CPM revenue…

  vee_jess

  4 replies

  13 years, 11 months ago

  By: vee_jess

• Down the Rabbit [Role]?

  I'm playing with discovering permissions, and having trouble constructing a recursive CTE that will…

  Lowell

  1 replies

  13 years, 11 months ago

  By: MVDBA (Mike Vessey)

• Dealing with multiple products with the same database?

  Hi, I have an architectural question.. We are a healthcare company and working with various product…

  mda

  4 replies

  13 years, 11 months ago

  By: mda

• Problems with xp_cmdshell

  I'm hoping people can help me on this one, I'm having problem using the xp_cmdshell to rename or de…

  RedDoorSQL

  6 replies

  13 years, 11 months ago

  By: Lowell

• Installation error -SQL server 2008R2 failover cluster through cmd prompt

  Hi, I tried to install single node SQL server 2008R2 failover cluster using the below commands. set…

  Ryan007

  3 replies

  13 years, 11 months ago

  By: EdVassie

• how to check datas from date to to date in a table by passing two parameter?

  here in this table which has lot of data for example i have written 3 value in the table and i w…

  Sivaganesh Tamilvendhan

  12 replies

  13 years, 11 months ago

  By: Ant-Green

• Need to get DB status on a Server

  Hi, I'l like to get the DBs status on a Server. Means, I need to know what are the DBs are being us…

  ajay.g

  2 replies

  13 years, 11 months ago

  By: ajay.g

• Stored procedure error

  Hi, I try to execute the following stored procedure: USE [SGSC] GO /****** Object: StoredProcedur…

  river1

  14 replies

  13 years, 11 months ago

  By: sanket kokane

• how to check sql server health

  I restarted server. i could see sql is running in congig manager but how to make sure sql is up and…

  HBK_4700

  1 replies

  13 years, 11 months ago

  By: Andy Hyslop

• Avoid Junk character in SQL server

  Hi All, I have an excel that I need to port into my SQL server table. But, there are few junk…

  Latheesh NK

  6 replies

  13 years, 11 months ago

  By: Latheesh NK

• SQL Access

  I have access to windows Server and I need access to SQL Server 2008 , the 3rd party team installed…

  Nita Reddy

  3 replies

  13 years, 11 months ago

  By: kkanaya

• Stored Proc or Table Valued Function? Pivot problem

  Hi Guys, I've wriiten a stored procedure to dynamically sum monthly totals in a financial year. How…

  niteshrajgopal

  2 replies

  13 years, 11 months ago

  By: ChrisM@Work

• Upgrade Sql 2008 (build 10.00.1600) to 10.50.1617

  Hi, I recently tried to restore a backup of sql DB to my local machine from a remote machine. Whe…

  S-322532

  2 replies

  13 years, 11 months ago

  By: Gail Shaw

• Split UK Postcode with SQL Server function

  I coded a function today to split a UK postcode into part one and two, even if the space is missing…

  C# Gnu

  12 replies

  13 years, 11 months ago

  By: C# Gnu