Viewing 15 posts - 4,381 through 4,395 (of 6,679 total)
Since you have the schema_id column in your results, can't you just join to sys.schemas and get the name?
If you really don't want to join on another table, you could...
November 17, 2009 at 2:56 pm
It is not possible from T-SQL, but if you download the Powershell provider for SQL Server 2008 and Powershell, you can get to that information easily.
From the Powershell prompt, after...
November 17, 2009 at 1:50 pm
I am going to need some clarification on what is not working here. How are the results not as expected and what have you found to be the problem?
November 17, 2009 at 11:16 am
GSquared (11/16/2009)
If it has multiple peanuts, it's clustered. If it's just one peanut per database, then it's not. Seems simple to me.
What if you have a bunch of...
November 16, 2009 at 11:40 am
Bru Medishetty (11/13/2009)
Hmm Seems to be strange, have not got an idea what does it alter?Any way have you tried to rerun that job?
I think the alter is part of...
November 13, 2009 at 1:45 pm
Never mind about the version - I reviewed the original post and see that you are running SP3. Verify the account running both SQL Server and the Agent and...
November 13, 2009 at 1:44 pm
What is the version of SQL Server? I recall that there were some issues with SP1 and Integrity checks. Not sure if that applies here.
Is SQL Server running...
November 13, 2009 at 1:41 pm
View the history for the maintenance plan instead of the SQL Agent job. You will find additional information that might indicate exactly what is causing the failure.
November 13, 2009 at 1:04 pm
You don't have to perform a backup after switching between bulk-logged and full recovery models. Now, if you switch to simple - it will break the log chain and...
November 12, 2009 at 2:50 pm
Make sure you are using local temp tables instead of global temp tables. Local temp tables are preceded by a single # - global temp tables are preceded by...
November 12, 2009 at 11:52 am
You need to look up DATEADD in help (Books Online). You are going to setup a query where you will filter the results using the above function. Example:
SELECT...
November 10, 2009 at 4:41 pm
In BIDS - when designing the report, setup the parameters with default values. The default values you will use would be something like:
=DateAdd(DateInterval.Day, -1, Today())
Figure out what defaults you...
November 10, 2009 at 2:07 pm
You are going to have to look at setting up and using a linked server to access the database on another instance. What I would recommend you look at...
November 9, 2009 at 4:54 pm
Viewing 15 posts - 4,381 through 4,395 (of 6,679 total)