Viewing 15 posts - 16 through 30 (of 221 total)
I'm not sure if this is the same with snapshot replication as with regular transactional replication but...
With transactional replication you can choose whether to replicate indexes or not. It may...
August 15, 2013 at 7:21 am
I only use the wizard if I have to transfer hundreds of tables and I'm too lazy to create the data flows myself.
So i guess BIML will become your new...
August 15, 2013 at 1:32 am
Hi,
That depends entirely on what they're doing with them. In my shop all developers have a local copy of SQL Server dev edition installed and there's also a dev edition...
August 14, 2013 at 9:36 am
You can setup a trust between the two domains. That will allow each one to see the other's logins.
August 14, 2013 at 9:33 am
I avoid that wizard where possible if i'm honest. Glad you got the data inserted! 🙂
August 14, 2013 at 8:53 am
Hi,
This is really strange. I've just created an SSIS package manually (i.e. not through the import wizard). If i say that the excel source has column headers in the first...
August 14, 2013 at 8:32 am
It seems if you open the package in SSDT then preview the source data it is trying to insert a NULL. I can't say i much understand why SSIS would...
August 14, 2013 at 8:18 am
Are you able to post the CREATE TABLE DDL statement for the table you're trying to import to and a sample file?
August 14, 2013 at 7:55 am
You need to create an operator. If you expand the SQL Server Agent node in SSMS there's an operators folder. Right-click that and create a new operator.
You'll also need to...
August 14, 2013 at 7:24 am
Glad you got it sorted. At this rate of learning you'll be a fully fledged battle worn DBA by the middle of next week. 😉
August 9, 2013 at 2:08 am
Cool! I didn't know you could do it from a right-click in the DSV but that's essentially the same thing as I described.
Thanks,
Simon
August 8, 2013 at 8:48 am
From what you describe it sounds like you've added a calculated column to your fact table in the data source view rather than add a calculated measure.
Calculated measures are added...
August 8, 2013 at 8:44 am
Hi,
Essentially the collation of your server and your database are different. In our environment our ASPNETDB is set to SQL_Latin1_General_CP1_CI_AS so i therefore assume that your server is Latin1_General_CI_AS. The...
August 5, 2013 at 7:33 am
Hi,
You could try SQL Search from RedGate that has proved to be an invaluable (free too!) tool for me at times.
Thanks,
Simon
August 5, 2013 at 5:06 am
Viewing 15 posts - 16 through 30 (of 221 total)