Viewing 15 posts - 3,661 through 3,675 (of 7,187 total)
If you need to run it regularly then it's worth taking the time to script it properly. Are the databases that contain the table the same databases from week...
January 21, 2014 at 5:38 am
What are the permissions on ther actual file itself?
When changing NTFS permissions, you either need to change them at the level they were originally set and cascade them down, or...
January 21, 2014 at 5:36 am
Why do you say "like sp_msforeachdb"? Is there any reason not to use that stored procedure? Is this a one-off, or a regular requirement?
John
January 21, 2014 at 5:31 am
Have you checked your NTFS permissions on the package file?
John
January 21, 2014 at 5:16 am
In that case, I think I'd import into SQL Server tables as is, then use a splitter (search this site for how to do that) to separate the values, and...
January 21, 2014 at 2:05 am
Notwithstanding Sean's point about SSNs, you could do something like this. It splits the string into a table of component characters, performs the transformation, and then reconcatenates them.
with numbers(n)as...
January 20, 2014 at 8:45 am
I don't use packages in msdb, so I'm not entirely sure. Are you using a deployment manifest? If so, you sholuld be able to just specify the location...
January 20, 2014 at 8:26 am
What are you going to do with the data once you have separated the columns - import it into SQL Server, or something else? Is there a maximum number...
January 20, 2014 at 8:18 am
Not enough information. File system or SQL Server deployment? And what precisely do you want avoid doing - visiting the server physically, using an RDP session, mapping a...
January 20, 2014 at 8:14 am
GilaMonster (1/20/2014)
richardmgreen1 (1/20/2014)
In your experience, is it a change you would make?No. Not unless I had an exceptionally good reason.
If you're getting collation conflict errors, you have three options:
(1) Insert...
January 20, 2014 at 7:42 am
I found this script...
It's not even as simple as that, I'm afraid. Where you have primary or foreign key constraints on any of the columns you're changing, they need...
January 20, 2014 at 7:35 am
Jeff
If the file is being used by another instance, that instance is going to be on the same computer. Are you able to see whether any other instances are...
January 17, 2014 at 9:49 am
Agreed, yes, and much has been written about the importance of doing test restores. I still verify my backups as well - after all, there's no point in going...
January 17, 2014 at 9:08 am
You can query the code of stored procedures in table [syscomments].
Best to use sys.sql_modules, since syscomments starts a new row after every 4000 characters (I think) of the definition. ...
January 17, 2014 at 8:57 am
Where you have a duplicate, how do you decide which one to throw away? And why do you want to use MERGE? MERGE is used for updating, inserting...
January 17, 2014 at 6:44 am
Viewing 15 posts - 3,661 through 3,675 (of 7,187 total)