Topics
Started by
Posts
Last post
ALTER TRIGGER [dbo].[tr_datediff] ON [dbo] [JOURNAL] FOR INSERT,UPDATEASSELECT DATEDIFF(d,sta…
29 replies
I want to setup a SQL agent job that restores over an existing database. This will be do…
2 replies
I have created a role on my database called 'SU'.So how can I now list all users that are ass…
7 replies
I have a lot of stored procedures. Now, every time I add a user I must go through each one of them …
10 replies
I have a stored procedure like this :USE [MyDatabase]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONG…
2 replies
Hi all, Looking to get some help with the following that I just can't get the case statement right …
9 replies
Hi All, My first ever real post I think! After a late change in career I find myself responsible fo…
5 replies
I need to upgrade an SQL based application, which should in itself be fairly simple. However, part …
3 replies
What is the difference between Bulk Insert and BCP. Which will be most effective in importing a bul…
3 replies
I am unable to alter a database table with ddl admin permission. I get the following error: "You a…
7 replies
Does any one know of an open source tool that I can use to load data from csv files into sql server…
7 replies
I have a table as below TableA AssetName nvarchar(50) AssetID smallint SomeID smallint ActiveOrnot…
3 replies
Hi Good Day, Kindly please help me on my problem regarding the reporting services of SQL server…
9 replies
Using MS SQL Server 2014 I am trying to modify the system stored procedure sp_addlogin, but getting…
5 replies
MS SQLServer 2014 Correct me if I am wrong : I have to run 3 stored procedures to add a user to ser…
3 replies
Viewing 15 topics - 241 through 255 (of 5,050 total)
You must be logged in to create new topics.