Viewing 15 posts - 2,971 through 2,985 (of 7,164 total)
What does this say on the instance causing the issue:
SELECT SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 3, 2012 at 11:48 am
OK, you have orphaned columns for a table that no longer exists. Here is how you can correct the problem on the 2000 instance:
http://msdn.microsoft.com/en-us/library/aa258741(v=SQL.80).aspx
** Take a FULL backup first and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 3, 2012 at 11:35 am
TJ-356724 (10/3/2012)
SELECT Object_Name(544525519) returns a NULL record. I have about 3 of them. How can I get rid of them?
On which system, 2000? or post-upgrade on 2008?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 3, 2012 at 10:31 am
K. Brian Kelley (10/3/2012)
opc.three (10/3/2012)
K. Brian Kelley (10/3/2012)
opc.three (9/28/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 3, 2012 at 9:27 am
K. Brian Kelley (10/3/2012)
opc.three (9/28/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 3, 2012 at 8:42 am
I cannot recreate the issue. Maybe it has been fixed. Here is the SQL I see when I script the 500-column VIEW as an ALTER:
exec sp_executesql N'SELECT
p.name AS [Name]
FROM
sys.all_views AS...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 2, 2012 at 11:04 am
Before going for BULK INSERT which implies there will be a directory where a file can be written that both the app and the SQL Server can reach I would...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 2, 2012 at 10:55 am
Jeff Moden (10/2/2012)
opc.three (10/1/2012)[hrThe fact remains that enabling xp_cmdshell introduces risk into an environment and there simply is no reason one needs to enable it to manage a database.
That fact...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 2, 2012 at 9:04 am
Mapping XEvents to Trace Events by Jonathan Kehayias
The mapping is more complete in SQL 2012.
Regarding the results being discarded, that's true for some targets like the ring buffer. You can...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 2, 2012 at 2:27 am
Jeff Moden (10/1/2012)
opc.three (10/1/2012)
Jeff Moden (10/1/2012)
Of course, you should make sure you're system is properly locked down first.Properly locking down your system, what exactly do you mean by that?
It's simple....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 10:01 pm
If you have the time and inclination to provide proof-of-concept code that could be used on any instance to reproduce the issue it would be helpful to the community if...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 5:06 pm
Jeff Moden (10/1/2012)
Of course, you should make sure you're system is properly locked down first.
Properly locking down your system, what exactly do you mean by that?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 5:04 pm
Example where 10 is the length of the string and 1252 is the Encoding:
REPLACE(IncomingColumnName, "String you want to replace", NULL(DT_STR,10,1252))
Example where 20 is the length of...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 4:45 pm
I guess you are not using SSIS Package Configurations to store Connection Manager info. If you are you can simply change the config files and the code will not need...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 4:35 pm
stillconfused (9/28/2012)
well if any DTS packages are there in 2000 then what are the possibilities of moving them..I have never done that before so need some suggestions.
The simplest way in...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 1, 2012 at 4:28 pm
Viewing 15 posts - 2,971 through 2,985 (of 7,164 total)