Search results for query: *

In order to schedule the job, you could always use Windows Scheduler. You just need to work out how you do the error checking, as I am not too familiar with options around failed jobs.

You can restore individual filegroups, but you will need to have ALL of the transaction logs available, in order to get the various filegroups all to the same LSN (Log Sequence Number). The database will not (and really should not) open if the files are not all restored to the same LSN, or...

Do not use an identity column for sequential numbers. Use a SEQUENCE object with the NOCACHE option.

Do you need to reboot between the uninstall, and the new install?

To simply disconnect, you would use the Close() method of the Connection object. This will release the connection back to the connection pool in IIS, or close the connection to SQL for other types of applications.

I have encountered issues where poorly configured linked servers can cause SQL Server to hang, but not crash. Is this linked server running in or out of process?

Is all of this on one single machine? What does the SQL Server (database engine) errorlog show for login failure messages (should be on by default)?

The user Tapit_DBA would be a user defined in SQL Server. Use SQL Server Management Studio to have a look in SQL Server to see if the MSDB database is online. Also, look at the Tapit_DBA login to see what his default database is (you should perhaps reset it to msdb). Also have a look at the...

Judging from I would check on the msdb database on the instance. It may be corrupt or offline. If the msdb database is offline, any attempt to log in to that database will result in a login failure. If the login is failing for a different reason, the SQL Server ERRORLOG should show the...

From your question, I am going to assume you are not part of the IT department where you work. When you do go to your Network or Firewall guys, they will not really hear "This is a test database" or "This is very small". For them, there is only a production network. Besides which, if the...

What is myReader declared as? If it is a SqlDataReader object, you might be looking to use the GetString(n) method to get the nth (0 based) field as a string.

To see where the connection is coming from (or at least what the program is reporting as it's host name), you can just use the host_name() function:select host_name()So, you can use this (replace the print statements with probably your RAISERROR command):if host_name() + '%' like @@servername...

You could call the ERROR_MESSAGE() function and have that printed out: https://msdn.microsoft.com/en-us/library/ms190358.aspx

I ran into a similar problem a few years back. Turns out the File Server cache was eating enormous amounts of memory, which was not represented in Task Manager. The first sign was the SQL Server crash after it had given away as much memory as it possibly could. So my question for you is when...

I have done this before, and you should not affect the other instances. In the SQL Server Setup (which does the actual uninstall), you will be presented with an option of which instance(s) you want to remove. If I recall, you will also be presented with a summary screen before you actually hit...

Can this be a permissions issue? Do the SQL Agent accounts have rights to log in to the other machine? Alternatively, when you set up replication, you get prompted to supply a user to handle the replication. If this was set up, what rights does it have on either machine?

You could isolate the permissions a little better by having the stored procedure push a message onto a service broker queue, then having a second (admin run) procedure read that queue, and extract the BLOBs.

I am going to assume this is a pull subscription. Have you tried configuring this as a push subscription? One other silly question: Is the distributor a different machine/instance from R and L?

The command to change the dateformat would be set dateformat dmy Should take effect for the duration of the session.

Actually, there are two separate EXECUTE AS clauses. The freeform or interactive one is the one that requires the impersonation permission. If you embed the impersonation in the trigger (or stored procedure), then it is the person who runs the CREATE TRIGGER statement who needs the...