Viewing 15 posts - 91 through 105 (of 105 total)
Created index on foreign key tables , for key column of the base table. but no luck.
Execution plan shows index seek for these tables.
After disabling the foreign keys on this...
February 20, 2013 at 3:17 am
sorry jeetsingh.cs i did not understand you reply.
What i want is
CREATE TABLE [abc](
[Code] [CHAR](3) CONSTRAINT CK_abc_Code CHECK (UPPER(Code) LIKE '[A-Z][A-Z][A-Z]') NOT NULL,
[Description]...
January 30, 2013 at 6:08 am
I know it works with sp_bind syntax. I wanted to do it with out it.
Also after correcting the typo error it still gives error "incorrect syntax near Default".
January 21, 2013 at 3:35 am
I tried but it gives error message incorrect synatx near default
CREATE TYPE a FROM integer NOT NULL DFAULT 1;
January 20, 2013 at 8:19 pm
Thanks all for your replies.
I agree that we should exclude row version column but there my be many developers working on the DB. And if sombody uses the select...
January 16, 2013 at 1:08 am
can u suggest any other method other than shrink to reduce the log size?
November 14, 2012 at 9:36 am
I checked default template does not cater to my changing parameter reuirement. Also it is not showing me how to make table type paramter as optional
November 6, 2012 at 6:52 am
Dear Valued member
this is not taking care of the null value in parameter
October 8, 2012 at 5:16 am
The log file size had increaded due to BCP operaiton. Hence i did the shrink. Is it ok to do dhrink in this case?
October 8, 2012 at 1:40 am
thanks for the link. After shrinking the log file now DB size has reduced to 6GB.
October 1, 2012 at 3:35 am
I just took Full backup but still the log file size is showing 9GB? I did it using sqlcmd command and the procedure sp_BackupDatabases
October 1, 2012 at 2:08 am
in syabse we faced an issue that when server was resatrted before stopping the service there was jump in identity value. But server on its own can control this jump...
May 30, 2012 at 4:22 am
Viewing 15 posts - 91 through 105 (of 105 total)