SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Script to change linked server password

  Hi, Anyone have any script to change linked server password..or advise how to change linked server …

  SQLisAwe5oMe

  2 replies

  13 years, 7 months ago

  By: SQLisAwe5oMe

• Help converting a decimal time in db4 to an actual time in sql server.

  I am pulling data from an AS400 where the actual time is stored as a decimal (example - 113804 woul…

  srobinson 596

  2 replies

  13 years, 7 months ago

  By: srobinson 596

• Data-Modeler-Tool

  Hello, can anyone give a recommendation for a data modeling tool that ER data modeling. allowed wit…

  info 58414

  5 replies

  13 years, 7 months ago

  By: SteveBell

• SQL Server has encountered occurrence(s) of I/O requests taking longer than 15 seconds to complete

  I have a few SQL Server 2008R2 SP1 and SP2 as well as a couple SQL Server 2008 SP3 getting this err…

  Anonymous

  9 replies

  13 years, 7 months ago

  By: TheSQLGuru

• AWE and PAE both should be enable on Windows 2008 R2 32 bit?

  Hi Operating system - Windows 2008 Enterprise Edition 32 bit. SQL SERVER - MS SQLSERVER 2008 R2 32 …

  SQL Galaxy

  2 replies

  13 years, 7 months ago

  By: TheSQLGuru

• Return resultset or use OUTPUT parameters in SP

  Hi, If I have a stored procedure that only checks if a customer exists (simple case) it's better to…

  PiMané

  1 replies

  13 years, 7 months ago

  By: Eugene Elutin

• IDENTIY COLUMN Property behaviour

  Hi All, I have a table with IDENTITY(1,1), it will generate a sequence number. How SQL Server is ge…

  SQL*

  12 replies

  13 years, 7 months ago

  By: Ellen-477471

• mtd, yesterday and previous month data in 1table

  I am trying to get mtd, yesterday and previos month data in 1 table. Can someone please help me..

  deep_patel1

  4 replies

  13 years, 7 months ago

  By: deep_patel1

• Help needed with a query (Cursors+union+pivot?)

  Hello, I've been trying to figure out how to solve this for a while, with no success. I have 2 tabl…

  gianlud75

  10 replies

  13 years, 7 months ago

  By: gianlud75

• Cross joining one table to find duplicates

  I have been working on cleaning a database with addresses in an attempt to dedupe it. There's a lot…

  d.aarts

  2 replies

  13 years, 7 months ago

  By: d.aarts

• how to find out which user (employee) belong to which login?

  At my work in SQL server 2008, users are created in active directory. User come and ask me to provi…

  Sen1

  2 replies

  13 years, 7 months ago

  By: Sen1

• Table/view doesn not exist, VS_ISBROKEN

  Hi, We have following issue. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600…

  chalamsbi

  2 replies

  13 years, 7 months ago

  By: PaulB-TheOneAndOnly

• Is there a way to tell if a box is really a VM or physical server?

  We have infrasctructure folks that setup and configure hardware when we need a new SQL Server for s…

  Larry Kruse

  9 replies

  13 years, 7 months ago

  By: Ignacio A. Salom Rangel

• Which databaes a job is attached to

  Hello - I'm using SQL Server 2008 Standard. What is the T-SQL to use to find out which databaes a j…

  NJDave

  3 replies

  13 years, 7 months ago

  By: tim_harkin

• Practice exam for 70-451

  Can anyone recommend a practice exam for the 70-451? I usually use measureup but they don't appear…

  Kenneth.Fisher

  3 replies

  13 years, 7 months ago

  By: Kenneth.Fisher