New answers tagged

1

I had the exact same problem and I found that it was caused by not enough memory allocation on the Hyper-V VM. I had memory set to dynamic but it was not scaling up as required - switching to a fixed amount of memory, in my case 32GB, solved the problem. The interaction between SqlBulkCopy and Sql Server does not seem able to get more memory when required??


0

You could probably write a script that uses dynamic SQL to do that, but why do that when you can use someone else's? Ola Hallengren's are the best known and free, but Minion Ware also has a free reindex script. If you insist on writing it yourself, something like this might work: Use mssqlDB01 Declare @TBname nvarchar(255), @SQL nvarchar(max) ...


0

I was having the same problem. Looking at the Agent log gave me more clues. (The agent log is not the same as the log file specified during creation of the Maintenance plan). In my case it contained a warning: SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'xxx\xxxxx', error code 0x54b. [SQLSTATE 42000] (ConnIsLoginSysAdmin)...


4

I know this is an old question, but it is the first question that shows up when searching "commvault" on serverfault. I have two years of experience with Commvault Simpana v9 and v10 as a support technician and a year as a systems engineer. First Question To answer your first question, yes, a typical database restore creates .mdf and .ldf files ...


2

Select the database as the active database-context using use before executing the SELECT-Statement. So it would: USE mydatabase; SELECT column_name FROM information_schema.columns WHERE table_name = 'Admins'; An alternative would be to include the database as a prefix to the information_schema like this: SELECT column_name FROM [mydatabase]....


1

When you start an agent job, it returns immediately with a success message. Take a look at this post (http://agilebi.com/cs/blogs/jwelch/archive/2009/02/20/check-for-sql-agent-job-completion.aspx)


1

Check the Publication Properties-->Snapshot-->Location of snapshot Files-- Make sure put files in the default folder is checked, in my case it was't check marked instead put files in the following folder was checked with a location address(C:\REPL) but i had my distributor in a different server other than publisher and the location address was misleading ...


0

Can you successfully connect to the database you are trying to connect the application to using Management Studio using the "sc" user? Is there a default database for the "sc" user? Is the default database the same database you are trying to connect to?


0

In my case I changed the connection mode from windows authentication mode to SQL Sever and Windows Authentication mode.Then it works!


0

It could be occure due to some dll file missing, you can also connect to your server without using instance name you have to reconfigure your server to use static TCP port. open SQL Server Configuration Manager; switch to the SQL Server Network Configuration | Protocols for SQLEXPRESS; double-click the TCP/IP protocol; select the Yes value in the Enabled ...


0

The depends on how the permissions on the database have been granted. When a domain user logs into a Windows console, their login session contains the list of group memberships that were valid at the time of login. If they are added to a new group after logging in, they won't actually get the benefits of that group membership on that computer until after ...


1

The PDO connection couldn't find the driver for me when using the curly braces. After removing those, I was able to connect just fine. Note my usage of the double quotes for the connection string which allows variable expansion. $mssqldriver = 'ODBC Driver 11 for SQL Server'; $connStr = "odbc:Driver=$mssqldriver;SERVER=<redacted>;DATABASE=<...


1

Is there anything else in Sql Server 2016 that wants Windows Server 2016 to work well? Or would I be fine with a Windows Server 2012 R2? There are a slew of new and updated features in Windows Server 2016. Unless any of them are specifically important to you, for example enhancements to storage spaces and CSV storage, I wouldn't specifically call out a ...


1

There could be a variety of reasons why this is going wrong. Most of which are related to the SQL Server components installed with VS2015. When VS2015 is installed, the default behavior is to also install the SQL Server data tools. These need to be compatible with the version of SQL Server that you're currently running. What I would do to troubleshoot your ...


1

When upgrading from one version of SQL Server Management Studio to another, e.g. 2014 to 2016, you can copy the SqlStudio.bin file from one directory to another and all of your connections will migrate to the new version. Shut down all instances of SSMS. Rename SqlStudio.bin to SqlStudio.bin.saved in "C:\Users\<username>\AppData\Roaming\Microsoft\SQL ...



Top 50 recent answers are included