• Register

Recent questions tagged sql-server

0 votes
1 answer 1 view
Problem: Why am I seeing "you do not have permission to use the bulk load statement" in SQL Server?
asked 13 hours ago anika11 4.1k points
0 votes
1 answer 1 view
Problem: How to use the business intelligence development studio for sql server?
asked 15 hours ago jamuna1 18.1k points
0 votes
1 answer 1 view
Problem: SQL Server : store procedure transaction.Is that possible or do I have to make a stored procedure only for the transaction?
asked 21 hours ago sumaiya simi 15.8k points
0 votes
1 answer 1 view
Question: I have the following issue in SQL Server, I have some code that looks like this: DROP TABLE #TMPGUARDIAN CREATE TABLE #TMPGUARDIAN( LAST_NAME NVARCHAR(30), FRST_NAME NVARCHAR(30)) SELECT LAST_NAME,FRST_NAME INTO #TMPGUARDIAN FROM TBL_PEOPLE When I do this I get an error 'There is already an object named '#TMPGUARDIAN' in the database'. Can anyone tell me why I am getting this error?
asked 1 day ago munim01 12.9k points
0 votes
1 answer 2 views
Question: I have the following issue in SQL Server, I have some code that looks like this: DROP TABLE #TMPGUARDIAN CREATE TABLE #TMPGUARDIAN( LAST_NAME NVARCHAR(30), FRST_NAME NVARCHAR(30)) SELECT LAST_NAME,FRST_NAME INTO #TMPGUARDIAN FROM TBL_PEOPLE When I do this I get an error 'There is already an object named '#TMPGUARDIAN' in the database'. Can anyone tell me why I am getting this error?
asked 1 day ago munim01 12.9k points
0 votes
1 answer 1 view
Problem: How can I see if a table in SQL Server exists?
asked 1 day ago jamuna1 18.1k points
0 votes
1 answer 1 view
Problem: Do you know how to search a table in SQL Server exists?
asked 1 day ago jamuna1 18.1k points
0 votes
1 answer 1 view
Problem: Is there any way to check if a table exists in SQL Server?
asked 1 day ago jamuna1 18.1k points
0 votes
1 answer 1 view
Question: How can I solve the error in the following procedure? CREATE PROCEDURE cards @salesman VARCHAR(10), @RCV10 INT, @RCV09 INT, @RCV15 INT, @GPRS15 INT, @RCV20 INT, @RCV25FTT INT, @RCV25 INT, @RCV31 INT, @RCV30 INT, @RCV35 INT, @RCV50 INT, @RCV55 INT, @SIM ... /2013' gives the following error: Msg 8114, Level 16, State 5, Procedure cards, Line 0 Error converting data type varchar to datetime
asked 1 day ago Atik03 10.1k points
0 votes
1 answer 1 view
Problem: Is there a way to back up MySQL database automatically at certain times of the day for designated servers or send an email with an attachment.. Which ever do you think is the best and safest way to achieve this?
asked 1 day ago Humaira ahmed 15.1k points
0 votes
1 answer 1 view
Problem: Anyone answer me which are not displayed on a graph?
asked 2 days ago padma1 22.4k points
0 votes
1 answer 2 views
Problem: How can I execute the sp_change_users_login so that it will auto-fix all local sql accounts?
asked 2 days ago sumaiya simi 15.8k points
0 votes
1 answer 1 view
Question: I have two tables, Table1 and Table2. I want to select distinct rows in Table2 that are not contained in Table1. Here is an example: Table1 | A | | sem| ------------------ 1. | aa | | 1 | --------------- 2. | bb | | 1 | ---------------- 3. | aa ... | ee | ------ I would want the those row who is not common in this two table when sem = 1 like output for sem = 1 result | B | | cc | | ee |
asked 2 days ago Atik03 10.1k points
0 votes
1 answer 1 view
Question: I cannot start SSIS in SQL Server 2008. Here is a screenshot of SQL Server installer. Where should I begin to enable/install Integration Services in SQL Server 2008?
asked 2 days ago Atik03 10.1k points
0 votes
1 answer 2 views
Question: Please help me, how to filter words in SQL using a function? I'm having a hard time if I explain it so I'm giving example: ID | WebsiteName | ----------------------------------- 1 | www.yahoo.com | 2 | www.google.com | 3 | www.youtube.com | What I want is, ... How to remove the 'www.' and '.com' in the record. ID | WebsiteName -------------------------- 1 | yahoo Thanks for the help.
asked 2 days ago Atik03 10.1k points
0 votes
1 answer 2 views
Question: When I run a query with OPENROWSET in SQL Server 2000 it works. But the same query in SQL Server 2008 generates the following error: SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' ... the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure
asked 2 days ago Atik03 10.1k points
0 votes
1 answer 2 views
Problem: SQL Server 2012 - Permission for access to sys.dm_db_index_usage_stats in Contained Database.In a contained database, how to I grant users read access on this table?
asked 2 days ago sumaiya simi 15.8k points
0 votes
1 answer 3 views
Problem: How to I remove carriage return line feed from string in python, anyone can help?
asked 2 days ago jamuna1 18.1k points
0 votes
1 answer 1 view
Problem: What is the soluation of ssis error code dts_e_primeoutputfailed ?
asked 2 days ago jamuna1 18.1k points
0 votes
1 answer 3 views
Problem: What is the data science for the students of final year?
asked 2 days ago niyatiry 3.2k points