Viewing 15 posts - 421 through 435 (of 1,583 total)
Try DBCC CHECKTABLE on the table that has the clustered index. No point in checking the entire DB when it's just the one table reporting the issue?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2014 at 3:04 pm
Grant Fritchey (2/28/2014)
If you really want to see how intellisense ought to work, check out Red Gate SQL Prompt[/url].
Remember Grant is the "Product Evangelist for Red Gate Software" 🙂 :-D...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2014 at 5:54 am
You got me, seems rather odd the issue you are experiencing with the network share....are you using a fully qualified domain name? Or mapping to am admin share?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 2:03 pm
1. Are any of your databases offline?
2. What happens when you press Ctrl-J?
3. What compatibility level is the database? If it's an earlier version of SQL Server, intellisense may...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 10:58 am
Agreed, scalar function isn't the best application but the main thing I wanted to provide the OP, was some example code to use. Using Jeff's DelimitedSplit8K is a much...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 9:29 am
+1 @sean-2, I keep the important stuff in my brain but all the little odds-n-ends are cleaned out daily - that's why I have Google!!! 😀
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 9:03 am
Have you tried "Edit" > "Intellisense" > "Refresh local Cache"
?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 8:59 am
Just a shot in the dark here but try setting "Retain Same Connection" to True in your Connection Managers
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 8:58 am
You could create a simple scalar function and call that as needed (or take the code from this to use as well) CREATE FUNCTION [dbo].[fx_SetStringPadding] (
@OriginalString varchar(100),
@PadToLen int,
@PadChar char(1) =...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 8:54 am
Since you have many tables, I would recommend doing this via simple TSQL - the article below outlines the process quite well. If you have any further questions...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 8:31 am
Can you attach an example of the data in a flat file to this thread?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 6:31 am
NO problem, glad it helped!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2014 at 6:29 am
Create a temp table and insert the results from proc1 into it, do the same for proc2
select from temp table 1 use EXCEPT on the select from temp table...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 26, 2014 at 8:08 pm
@Lempster and @brandon - quite right, my ID10T error. I am fully aware of the flag in the publication options to replicate schema changes, however as a quick test...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 26, 2014 at 7:48 pm
If you attempt to modify a table that's currently being replicated, you will receive the following error
- Unable to modify table.
Cannot drop the table 'dbo.ts-services' because it...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 26, 2014 at 9:29 am
Viewing 15 posts - 421 through 435 (of 1,583 total)