Viewing 15 posts - 3,241 through 3,255 (of 9,712 total)
Are you looking for the difference between a SQL login and a Windows login? Or something else?
April 18, 2014 at 5:58 am
I force an XML source to generate an XSD when first adding a new file, then open up the XSD in TextPad or another editor to verify all the datatypes...
April 18, 2014 at 5:54 am
FYI: Indexed Views don't do well on high-volume insert tables.
I also seem to recall that trying to update the schema of underlying tables used in Indexed Views (WITH SCHEMABINDING)...
April 18, 2014 at 5:52 am
Depends on how big the backup is. You could use an Execute T-SQL Statement Task to send the email, but I think there's a size limitation on the attachment using...
April 18, 2014 at 5:44 am
vignesh.ms (4/18/2014)
also explain how does above query works ???
SQL Server Books Online is your best friend. If you don't have a local copy, download it from Microsoft.
Click Index and search...
April 18, 2014 at 5:37 am
What is the specific kind of locks that you are encountering?
How are your articles designed? Are they whole tables or queries? If queries, can you paste the offending ones here...
April 18, 2014 at 5:35 am
Googling the phrase "Export Novell eDirectory data to SQL Server 2008" gets me some links back to Microsoft, but none that specifically reference SQL Server. This link about ForeFront Identity...
April 18, 2014 at 5:32 am
Does it have to be Replication or can you just use SSIS to grab the data and move it into SQL that way?
April 18, 2014 at 5:25 am
Actually, it just occurs to me... Can I use WebClient.UploadFile method with this code? Do I have to create a physical file for this or can I just stream it...
April 18, 2014 at 5:24 am
BRILLIANT!
That's exactly what I needed. I thought I had to load the file into Powershell before playing with it (ala a temp table).
Thank you. Now I just have to figure...
April 18, 2014 at 4:32 am
FYI: Followup Powershell question at http://www.sqlservercentral.com/Forums/Topic1562838-1351-1.aspx
If I weren't on a deadline of three days ago, this wouldn't be so hard and I'd already have my answer. I just know it......
April 17, 2014 at 1:49 pm
That is a good point that I didn't think fully through. Thank you for the reminder.
There's got to be a better way for the users to get what they need,...
April 17, 2014 at 9:00 am
kbnyny (4/17/2014)
Brandie when I took out he Binary Base64 I still get the same funny character on the XML output file.
Can you give us a DDL for the table and...
April 17, 2014 at 8:50 am
Hmm. I'm not able to replicate the strange character pattern on my flat file. It comes out as all binary. And when changing datatypes in the connection manager, I appear...
April 17, 2014 at 5:15 am
I am trying to replicate this in my environment, using my own tables. Can you post the set up of the flat file connection manager (General and Advanced tabs)?
You can...
April 17, 2014 at 4:47 am
Viewing 15 posts - 3,241 through 3,255 (of 9,712 total)