Viewing 15 posts - 10,231 through 10,245 (of 26,489 total)
I can tell you it took some playing when I was doing it. Problem is it was so long ago it is hard to remember what we did. ...
August 8, 2012 at 8:42 am
Brandie Tarvin (8/8/2012)
Jan Van der Eecken (8/8/2012)
Brandie Tarvin (8/8/2012)
Wait. How the heck do you have more visits than I do and less points?You jealous, Brandie?
Just really confused. You should have...
August 8, 2012 at 8:39 am
I'm thinking about trying to get to the SQL Saturday in SLC in October. Hoping I will be able to swing it, but will probably need to find a...
August 8, 2012 at 8:32 am
tim.cloud (8/8/2012)
ALTER PROCEDURE [dbo].[usp_Index_Fragment_Daily_Log]
-- Add the parameters for the stored procedure here
AS
BEGIN
-- SET...
August 8, 2012 at 8:30 am
farooq.hbs (8/8/2012)
Hi guysCan we create Primary_Key Constraints on the View?
If Not Is there any other solution for this to get Sequences??
Please read the following, it discusses Indexed Views:
http://msdn.microsoft.com/en-us/library/ms191432(v=sql.100).aspx
August 8, 2012 at 8:24 am
Can you you get the BCP to work manually? I know I have done this myself, just can't remember how I handled it of the top of my head.
August 8, 2012 at 8:11 am
dwain.c (8/8/2012)
;WITH Unpivoted AS (
SELECT RaceCode, Code, Value
...
August 8, 2012 at 4:02 am
MyDoggieJessie (8/7/2012)
August 8, 2012 at 3:58 am
Go to sqlpass.org and do a search for user groups in your area. You could make some good contacts there.
August 7, 2012 at 7:51 pm
OMG.
OP: I run this T-SQL to change the location of these datbases but when I try to open the database SQL says it can't find the files.
Me: Have you physically...
August 7, 2012 at 4:44 pm
Angelindiego (8/7/2012)
August 7, 2012 at 4:40 pm
Heimillers (8/7/2012)
August 7, 2012 at 4:36 pm
If you undo what you did, in other words run the t-sql to put them back to their original location, does the database open successfully?
August 7, 2012 at 4:31 pm
Dumb question, have you physically copied the mdf/ldf files to the new location after running the t-sql code and taking the database offline?
August 7, 2012 at 4:29 pm
Viewing 15 posts - 10,231 through 10,245 (of 26,489 total)