Viewing 15 posts - 3,736 through 3,750 (of 6,041 total)
gosven07 (6/16/2015)
Convert 100 xml files individually to pdf's and zip them in a folder along with the source files.
Can it be possible in SQL server BI world?
If possible make this...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 16, 2015 at 12:11 pm
Revenant (6/16/2015)
Eric M Russell (6/16/2015)
Ed Wagner (6/16/2015)
Eric M Russell (6/16/2015)
Ed Wagner (6/16/2015)
BL0B_EATER (6/16/2015)
TomThomson (6/15/2015)
Ed Wagner (6/15/2015)
djj (6/15/2015)
Eirikur Eiriksson (6/15/2015)
Ed Wagner (6/15/2015)
Revenant (6/15/2015)
Ed Wagner (6/15/2015)
djj (6/15/2015)
crookj (6/15/2015)
Guzzled
Gin (reference to the late...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 16, 2015 at 11:56 am
Notice that when including a quote ' with quotes '', you need to double it up.
REPLACE( Column1, '''', '"' )
To make it more readable, you can also specify char(39) in...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 16, 2015 at 11:29 am
Ed Wagner (6/16/2015)
Eric M Russell (6/16/2015)
Ed Wagner (6/16/2015)
BL0B_EATER (6/16/2015)
TomThomson (6/15/2015)
Ed Wagner (6/15/2015)
djj (6/15/2015)
Eirikur Eiriksson (6/15/2015)
Ed Wagner (6/15/2015)
Revenant (6/15/2015)
Ed Wagner (6/15/2015)
djj (6/15/2015)
crookj (6/15/2015)
GuzzledGin (reference to the late Red Skelton)
Rum
Captain
Picard
Packard
Automobile
Repair
Mend
patch
Update
Cumulative
Distribution
Labor
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 16, 2015 at 11:20 am
Rumor has it that when this forum reaches page (255), SQL Server Central web app will crash and Steve will have to login at 2AM in the morning to fix...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 16, 2015 at 10:53 am
Ed Wagner (6/16/2015)
BL0B_EATER (6/16/2015)
TomThomson (6/15/2015)
Ed Wagner (6/15/2015)
djj (6/15/2015)
Eirikur Eiriksson (6/15/2015)
Ed Wagner (6/15/2015)
Revenant (6/15/2015)
Ed Wagner (6/15/2015)
djj (6/15/2015)
crookj (6/15/2015)
GuzzledGin (reference to the late Red Skelton)
Rum
Captain
Picard
Packard
Automobile
Repair
Mend
patch
Update
Cumulative
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 16, 2015 at 10:50 am
If are a sysadmin on the SQL Server instance, then you can setup a SQL Profiler or Extended Event trace for connections.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 16, 2015 at 10:48 am
Alessandro Alpi (6/16/2015)
Eric M Russell (6/16/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 16, 2015 at 10:43 am
Just out of curiosity, does anyone here use SYNONYMNs as part of your database refactoring? If so then what unexpected limitations or quirks did you encounter?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 16, 2015 at 9:33 am
Hacking databases has become so common, it's as if the people doing the hacking are some of the same people who develope the networking infrastructure, applications, and database systems in...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 16, 2015 at 7:25 am
Jeff Moden (6/12/2015)
charipg (6/12/2015)
user have db_datareader role in in a database.But user is not able to see the storedprocedures.
any suggestion pls.
I have a different suggestion than the others... why is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 12, 2015 at 3:37 pm
If what you need is to grant execute permission on ALL procedures and visibility on ALL objects, then you can use the following database level commands. However, as Jack suggested,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 12, 2015 at 12:39 pm
Jeff Moden (6/12/2015)
Eric M Russell (6/12/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 12, 2015 at 8:37 am
I don't use tools to generate DDL scripts, so writing T-SQL to do things like adding non-null columns, or dropping unnamed constraints and re-adding a named constraint, that's all situation...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 12, 2015 at 8:19 am
DanMcClain (6/12/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 12, 2015 at 7:52 am
Viewing 15 posts - 3,736 through 3,750 (of 6,041 total)