Viewing 15 posts - 76 through 90 (of 90 total)
You could do something like this:
select 'ALTER TABLE [' + OBJECT_NAME(parent_object_id) + '] DROP CONSTRAINT [fk_'+ OBJECT_NAME(parent_object_id)+'_'+OBJECT_NAME(parent_object_id)+']'
from sys.foreign_keys
where name like 'fk_'+ OBJECT_NAME(parent_object_id)+'_'+OBJECT_NAME(parent_object_id)+'%'
You should get a list of statements that give...
January 2, 2011 at 10:07 pm
Well, you could use this query to find out what is not in ProcedureCache, but you would have to be sure that the coverage of the application has taken into...
January 2, 2011 at 9:54 pm
The data will not be gone. It will expand the definition in the header of the table and convert the data from nvarchar to varchar, but the data will...
December 9, 2010 at 9:11 pm
Well, really you are defining the limits of the column. It should be defined to that number that will be a limit based on the application design.
So you have...
December 9, 2010 at 8:34 pm
You should look at the links that were given to you.
But basically, you have to understand the var part of varchar or nvarchar. The 'var' is variable length, and...
December 9, 2010 at 7:19 pm
What I meant was is that the Datalength of a nvarchar(max) with 'Ben' inside, is 6 bytes, and Datalength of a varchar(max) with 'Ben' inside is 3 bytes, so because...
December 8, 2010 at 5:46 pm
If you are not needing Unicode data then you would not use nvarchar, you would use varchar. The difference is that if you are not usig Unicode data, then...
December 8, 2010 at 4:15 pm
The database version is a number stamped in the boot page of a database that indicates the SQL Server version of the most recent SQL Server instance the database was...
November 23, 2010 at 11:41 pm
As has been said, you cannot restore a database backup from a later version to an earlier version period.
When you bring a database forward to a later version from an...
November 23, 2010 at 3:13 pm
And to add on to that, if you do have a x64 environment and run it through SQL Agent, then the dtsexec will be x64 by default and you can...
November 23, 2010 at 3:06 pm
And it may be worth creating a variable above and putting the ';' + text + ';%' together in the variable and then using it in a like.
November 15, 2010 at 11:09 pm
I would recommend at least 8 GB of RAM, but would shoot for at least 12-16 if you can afford it. The other things are dependent on how heavy...
November 15, 2010 at 10:22 pm
The general rule for SQL Server on Internet Facing sites is you need to license it with Processor licensing. But the Web Version of SQL 2008 is another option,...
November 15, 2010 at 10:18 pm
The only thing I can think of on this is that you did not detach the right database. SQL releases the files on detach, and the OS does not...
August 6, 2009 at 12:53 pm
The other thing to remember is that there is a -A on the SQLCMD that invokes the DAC on the connection you are making.
Ben.
August 6, 2009 at 12:50 pm
Viewing 15 posts - 76 through 90 (of 90 total)