Viewing 15 posts - 1 through 15 (of 1,247 total)
Did you try?
SELECT * FROM sys.sysobjects WHERE type = 'U' AND name = 'yourTableName'
April 5, 2013 at 10:27 am
The execution plan is saved by SQL Server after the first run. The plan will be changed if you changed your query.
If you run the same query twice, you...
April 3, 2013 at 8:56 am
Just my two cents.
The execution plan is saved within the cashe allocated to SQL Server instance. It is not related to the other setting outside SQL Server.
The ANSI setting affects...
April 3, 2013 at 8:34 am
Bobby Glover (3/20/2013)
March 20, 2013 at 9:07 am
Bobby Glover (3/20/2013)Are you talking about a production db. I would not shrink a production db POINT BLANK.
Thank you for your input. Unfortunately, I am asking a solution not asking...
March 20, 2013 at 9:04 am
John Mitchell-245523 (3/20/2013)
March 20, 2013 at 9:03 am
Although the user does not have own any table, view, ... , the user have a schedma. You have to delete the schema first before dropping the user account.
February 4, 2013 at 1:08 pm
Robert Davis (7/19/2012)SQL ORACLE (7/19/2012)Make a full backup for this database and then shrink the database.What difference will that make?
Robert Davis (7/19/2012)
SQL ORACLE (7/19/2012)Make a full backup for this database and then shrink the database.
SQL ORACLE (7/19/2012)
What difference will that make?
We need to truncate the log to release the space from...
July 19, 2012 at 2:39 pm
Make a full backup for this database and then shrink the database.
July 19, 2012 at 1:56 pm
Right click My Computer wizard and choose the manage;
Go to the Services folder and browse whether or not you have SQL Server Integration Services there.
May I answer your question.
July 19, 2012 at 1:53 pm
Sometimes, restore this database is faster in my experience.
March 13, 2012 at 2:28 pm
In the level 1: you showed the screenshot where the controls under the Maintenance Plan Tasks are enabled.
Could you explain briefly how you did it? The controls in my...
March 9, 2012 at 2:47 pm
bhupendra.patel (3/2/2012)If look closely they are controls for SSIS packages, they are available to be used when you design the SSIS packages in BIDS environment.
If you looked at the
March 9, 2012 at 2:29 pm
In my memory,
1. You should install the driver on this server;
2. You should configure the connectivity for this driver if necessary;
For example, in Sybase, you need to configure Data Access\Data...
March 1, 2012 at 1:00 pm
Did you check the following issues?
What is the default schema this user has?
What permission does the user have on this schema?
March 1, 2012 at 12:39 pm