Viewing 15 posts - 8,416 through 8,430 (of 49,571 total)
It's invalid values (not varchar data) that due to some bug somewhere has snuck into the table. That's about all you can say.
July 15, 2014 at 10:32 am
You need to update the column to legal values, consider altering the column later. But there's no guarantee that that is even a legal unicode string. Somehow invalid values have...
July 15, 2014 at 8:38 am
Looks like you have user-defined data types in that database. My guess, Notes is a data type that someone's created at some time. Select Into will keep the same data...
July 15, 2014 at 8:32 am
Never use DTA against a production database, it's incredibly dangerous. It's testing workloads so it will put a lot of load on whatever server it's pointing at. If you have...
July 15, 2014 at 8:31 am
Open up Books Online (the SQL help file, F1 in Management Studio), search for UPDATE and have a look at the syntax.
Yes, you can delete and insert, but why would...
July 15, 2014 at 7:15 am
If you want to update, then you probably want the UPDATE statement. Again well-documented in Books Online.
July 15, 2014 at 6:50 am
Steve Jones - SSC Editor (7/15/2014)
Miss me?
Who are you? 😉
July 15, 2014 at 4:35 am
Only if the applications set that property in the connection strings when they connect to SQL. If they do, you can query the Program_Name column in sys.dm_exec_sessions.
July 15, 2014 at 3:11 am
The 0x... Could be XML encoding. REPLACEs are often necessary to fix that. The unfin not coming from the data? Check filters.
July 15, 2014 at 2:58 am
Have a look at this (the XML method mainly): https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
July 15, 2014 at 2:30 am
Alan.B (7/14/2014)
TOP 100 PERCENT is not a kludge nor is TOP <really big number>.
It is kinda. TOP (100) PERCENT ... ORDER BY will result in SQL ignoring the order...
July 15, 2014 at 1:06 am
Duplicate post
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1592381-2799-1.aspx
July 15, 2014 at 12:53 am
Simon Su (7/14/2014)
Will this happen, the DB and mirroring DB are corrupt in the same time? I never thought about this.
Corrupt? Highly unlikely, the chance of two IO subsystems damaging...
July 15, 2014 at 12:41 am
Barcelona10 (7/14/2014)
How does Subscriber synchronizes with the Publisher (Merge replication) if it is not using trn log?
It's thoroughly documented in Books Online.
July 14, 2014 at 3:50 pm
georgeleonard70 (7/14/2014)
i usedEXEC sp_resetstatus D0011112;
ALTER DATABASE D0011112 SET EMERGENCY
DBCC checkdb(D0011112)
ALTER DATABASE D0011112 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (D0011112, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE D0011112 SET MULTI_USER
D0011112 is Suspected Database name
No, no, no!...
July 14, 2014 at 3:49 pm
Viewing 15 posts - 8,416 through 8,430 (of 49,571 total)